Jump to content

How do i duplicate a mysql data base?


Recommended Posts

hi all,

i have a MySQL database and wanted to keep a \'mirrored\' backup (ie: every time a request is sent to it the server the backup is made) of it on the same server in a different directory for backup purposes. Is is possible to do this?

 

Obviously this would have something to do with CRON but i have absolutley no idea how to script it and would not want to touch it after the great linux box crash of last week.

Link to comment
https://forums.phpfreaks.com/topic/1374-how-do-i-duplicate-a-mysql-data-base/
Share on other sites

There is a hot backup plugin available for mySQL

 

http://www.mysql.com/press/partners/release_343.html

 

Since the mySQL databases are stored as files on the server you could also setup something yourself to archive the files somewhere else every so often.

 

http://www.mysql.com/doc/en/Backup.html

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.