View Single Post
  #2  
Old 03-08-2002, 09:13 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

You can use mysqldump.exe to dump just the tables you want, or I found a great tool for managing mysql: DBTools I would subbest that you just write a query to copy the info you want to/from another backup database.

Edit: Use this command line command to backup your account and character data (run from the mysql\bin directory)
Code:
mysqldump.exe -t eq23 account character_ > backup.sql
where:
eq23 = database name
account = 1st table to output
character_ = 2nd table to output
backup.sql = output file for data

Add more tables if you want.

then use:
Code:
mysql.exe -f eq23 < backup.sql
to restore the data
Reply With Quote