EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   quick question, how to backup my database.. (https://www.eqemulator.org/forums/showthread.php?t=11817)

Swiftwing 02-08-2004 10:33 PM

quick question, how to backup my database..
 
I cant remember the comand to save a database, anyone know, I need to take my working DB and dump it to a safe directory for storage :)

samandhi 02-08-2004 10:40 PM

not totally sure of the SQL command forf this, but if you get MySQLFront, you can just click export and save as .sql or .htm and so on. ..... ....

Trumpcard 02-09-2004 12:58 AM

mysqldump <databasename> <tablename>

mysqldump database will dump all the tables for that database, just redirect it into a text file ( > somefile.sql )

Monrezz 02-09-2004 02:54 AM

mysqldump eq > Backup.sql

Will backup your whole database into a file called Backup.sql. To restore the database just drop your current one and then source in the file.

Monrezz


All times are GMT -4. The time now is 04:57 AM.

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