Jump to content

How do i duplicate a mysql data base?


bobsci

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.