MySQL Database Backups

Expand Post »

Hi everyone,

I feel like such a dumb*** because I don't know how to make automatic database backups.

I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though.

I'm using MySQL and Windows and my current method of database backing is to do it manually. I navigate to the mysql data directory, and copy and then paste it onto a CD of mine.

I hate how I have to manually do this all the time. I tried Windows scheduled task manager to create a backup of the mysql data directory but its a no go. Somehow it always fails when trying to back it up.

Is there any other alternatives?

Thanks,
Bobby

Similar Threads

Update entire Mysql DataBase with PhP in PHP
How To Connect Remote Mysql Database in Visual Basic 4 / 5 / 6
can i use mysql database with asp in ASP
Php code confusion. Not sure how to describe in PHP
URGENT: UBBThreads MySQL database merge in MySQL

bobby08

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Aug 2006

Permalink

Oct 4th, 2006

Re: MySQL Database Backups

Click to Expand / Collapse Quote originally posted by bobby08 ...

Hi everyone,

I feel like such a dumb*** because I don't know how to make automatic database backups.

I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though.

I'm using MySQL and Windows and my current method of database backing is to do it manually. I navigate to the mysql data directory, and copy and then paste it onto a CD of mine.

I hate how I have to manually do this all the time. I tried Windows scheduled task manager to create a backup of the mysql data directory but its a no go. Somehow it always fails when trying to back it up.

Is there any other alternatives?

Thanks,
Bobby

You should use mysqlhotcopy instead of manually copy and pasting the files to a cd. Unless you are stopoping mysql and then doing the deed, then it doesnt matter as there will be no writes to the files.
As for automating this, depending on your version of M$ you can schedule a job to run at a certain time. You can also compress the db files to save space once you have them in a different directory.

The command you want to run would look something like this:

MySQL Syntax (Toggle Plain Text)

mysqlhotcopy --user=me --password=hello --allowold db1 db2 db3 backup_folder

If all else fails you can use mysqldump.

hope this helps

sn4rf3r

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

133 posts
since Sep 2006

Permalink

Oct 5th, 2006

Re: MySQL Database Backups

If you want to consider a third party tool, then Navicat is a good option. It's not expensive, and includes a scheduler for SQL jobs. It can also administer databases, and easily transfer databases across servers. For more info: http://www.navicat.com/product.html

And no, I have nothing to do with, I am just a satisfied user.

pritaeas

Sponsor

Featured Poster

Reputation Points: 550

Solved Threads: 731

Bite my shiny metal ass!

Offline

4,177 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Converting mdb to mdf

Next Thread in MySQL Forum Timeline: What is Microsoft solution Framework(MSF) used for?

DaniWeb Message

Cancel Changes

User Name
Password