mysqldump <databasename> <tablename> > table.sql
So, say you want to dump account and character_ in a database called eq.
mysqldump eq character_ > character.sql
mysqldump eq account > account.sql
That will create the source files for those 2 tables. Then to put them back in
mysql eq < filename
will reload them...
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
|