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 :)
|
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. ..... ....
|
mysqldump <databasename> <tablename>
mysqldump database will dump all the tables for that database, just redirect it into a text file ( > somefile.sql ) |
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.