MySql Backup
 

Hello All,

I have just started working with MySQl for a small personal project. Although it is small and personal, the data in the database is crucially important.

I have MySQL 5.0.27 running on my local machine, in the event i have to format the machine:

Is there a way to back up the MySql database into a sort of file (like an MDF file) or something i can save to a cd or other disk drive so when i reinstall windows i can just use this magical file to restore my data.

ps: (I do not have my data in scripts my data is inputted into a servlet that connects to the database)

I suppose worst case scenario I could construct a script based on my input and what not..but am looking for an easier way)

Thnaks

If you have installed MySql Administrator then its all easy. Just go to the backup and schedule a backup whenever you want. Look at all the other options about where to save the backup file and stuff like this and if you want to backup it at the moment just click the "backup now" button. The file will be saved as a .sql file. And after you format your computer go again to the MySql Administrator and select restore. This is how you do it. I hope it helps.

well see i build websites and some of them i build you have to use mysql and they have a thing you can click and will will save teh database as .sql.gz

so if the site ever goes down the only thing i have to do is back and reupload that back up of the database and it will fix everything

but it depends if you are goin to add a little program to the thing you are making to back up the database like every 12 hours or like every 6 hours
or you could go into the mysql admin panel and do a back manually and save it to your computer.

Well the MySql Administrator has a schedule backup option.

i know that i mess with a lot of sql and things when i build websites

Once a prison director was waiting for a letter from regarding one of its prisoners, if he had to release or execute him. Finally the letter came and this was written from the judge :
"Freedom no death."

MySql Administrator does that come with the standard binary of MySql or is it a separate download

Thanks

i think there should be an entire room here for database programming

MySql Administrator is freely downloadable at mysql.com along with MySql Query Browser.

Go here in order to download the gui tools.