Database backup

solid11 · #1 03-10-2005, 08:20 PM

What is the easiest and/or safest way to backup your database and restore it?

Camaris · #2 03-10-2005, 09:23 PM

Copy the folder \mysql\data\eq...

sysadmin · #3 03-10-2005, 10:23 PM

Paste this on a batch file and run it, will do a complete database backup, just replace eq with your database name.

Quote:

cd\
cd \mysql\bin
mysqldump -u root eq > eqbackup.sql
exit

solid11 · #4 03-11-2005, 06:03 AM

I understand both ways, so if I make a backup .sql file I'll have to resource it then right? If I just backup the data folder then after I reinstall Mysql, I would just copy that database folder in there and it will work right?

mrea · #5 03-11-2005, 06:47 AM

Yeah, that way works as well.