Jump to content


Photo

How do i duplicate a mysql data base?


  • Please log in to reply
1 reply to this topic

#1 bobsci

bobsci
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 16 November 2003 - 02:46 AM

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.
"...The Best way to blow up the libary is to put some C4 around the second last column near the periodicals..." - My international studies teacher

#2 sirmanson

sirmanson
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationTucson, AZ USA

Posted 17 November 2003 - 03:09 PM

There is a hot backup plugin available for mySQL

http://www.mysql.com...elease_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.../en/Backup.html




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users