Thread: database backup
View Single Post
  #2  
Old 01-27-2011, 07:39 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default

Quote:
Originally Posted by secondattack View Post
i need to move my server to another system, what tables do i need to backup to save my players, and custom NPC's?
players to include bots.
You Can save the whole database by typing the following (for mysql);
( the destination after the > is an example. Use what you want)

Code:
mysqldump -uroot -ppassword peq > c:\backup\peq_backup.sql
You can name the sql file what you want. The "peq" is name of your DB.

Also if you want to back up the login, (whatever you named it, peqlogindb or whatever),
just change the name of "peq" to that of the logindb and the destination file name.
Reply With Quote