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
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.