EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   dumping database (https://www.eqemulator.org/forums/showthread.php?t=6725)

Fleyhum 04-20-2003 07:12 PM

dumping database
 
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


All times are GMT -4. The time now is 06:09 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.