MySQL Database's backup, how?

[faiesk]

I know that there's a option "Export" on phpMyAdmin, I used it, then I select the DataBase and click on Go, and it didn't give me the option to where export, just appear a text in the phpmyadmin, there's no option to save that.

But I think I discovery another way to backup it, which is:

C:\xampp\mysql\data\my_database_name

Just copy that folder (the ots' database), and then I can format my computer and paste it there normally, would it work fine?

Thanks

 

[Saj]

I dont think so, you have to export it and save it a file.. like I did

 

[ntmr]

Execute this (or make a .bat script with it):

C:\xampp\mysql\bin\mysqldump.exe -u [B][COLOR=Red]USERNAME[/COLOR][/B] -p[B][COLOR=Red]PASSWORD[/COLOR][/B] [B][COLOR=Red]DATABASENAME[/COLOR][/B] > C:\backup.sql

Edit what are in red.

Note: there is no space between -p and the password.

 

[faiesk]

It worked, but I have a last question

To restaure it when I format my comp, I just need to install XAMPP and then create a database with the same name and click to import it? or I don't need to create the database to restore it?

Thanks

 

[Saj]

That's all you have to do!

 

[Jester]

I use to do that and works fine.

 

[ntmr]

It worked, but I have a last question

To restaure it when I format my comp, I just need to install XAMPP and then create a database with the same name and click to import it? or I don't need to create the database to restore it?

Thanks

To restore, just put the backup.sql on C:\ and change the ">" to "<" on the code :thumbup:

 

[faiesk]

My doubt is been resolved, thanks.