PDA

View Full Version : dumping database


Fleyhum
04-20-2003, 07:12 PM
oki i changed msql versions and now i dont know how to dump the database can anyone help

i tried msqldump eq > newdb.sql and i get error 1064 you have a error in your SQL syntax at line 1

vetoeq
04-20-2003, 08:29 PM
Did you run this from the commandline or from inside of mysql.exe?

It needs to be run from the command line:

C:\mysql\bin\mysqldump eq >eq-backup.sql

--
VetoEQ

Graypaint
04-21-2003, 01:27 AM
can you dump a specific table
For instance
could i dump item data or just account and chacracter data?

Trumpcard
04-21-2003, 01:42 AM
mysqldump <databasename> <tablename> > filename


so, mysqldump eq items > somefile


All this information is available if you type mysqldump with no parameters. It will give you a usage explaination.

Graypaint
04-21-2003, 01:44 AM
Could you also do
<dbname> <tablename> <row#> ->File
?

Fleyhum
04-21-2003, 04:18 AM
Thanks for the help its dumped and ready