Database backup

[solid11]

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

[Camaris]

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

[sysadmin]

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

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

[solid11]

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]

Yeah, that way works as well.