dmccabe Posted March 12, 2008 Share Posted March 12, 2008 I am running a wordpress installation on an internal web server as I am going to use it as a backend for our intranet. It is running through IIS on a Windows 2000 server. Can anyone tell me how I would go about creating an automated backup of the mysql database ? Edit: - If my database is called "wp" do I simply need to backup the \\lch-web1\c$\MySQL\data\wp directory on the server? Quote Link to comment https://forums.phpfreaks.com/topic/95772-automated-backup-of-mysql-database/ Share on other sites More sharing options...
jcombs_31 Posted March 12, 2008 Share Posted March 12, 2008 You could back up the data directory or you can schedule a mysqldump to run through scheduled tasks. Quote Link to comment https://forums.phpfreaks.com/topic/95772-automated-backup-of-mysql-database/#findComment-490373 Share on other sites More sharing options...
tomfmason Posted March 12, 2008 Share Posted March 12, 2008 Edit: - If my database is called "wp" do I simply need to backup the \\lch-web1\c$\MySQL\data\wp directory on the server? I wouldn't do that. Use an sql dump instead. Here is a batch file I just wrote that is based off of a tutorial by phpfreak sql_backup.bat @echo off call mysqldump --opt -c -e -Q -u %1 -p%2 %3 > %4 Usage: sql_backup mysql_user mysql_pass database_name output_file To make it more automatic you could add a scheduled task that would run that script every x hours or whatever. This also assumes that you have C:\path\to\mysql\bin in your path. Quote Link to comment https://forums.phpfreaks.com/topic/95772-automated-backup-of-mysql-database/#findComment-490378 Share on other sites More sharing options...
fenway Posted March 12, 2008 Share Posted March 12, 2008 Or look at Ma'atkit. Quote Link to comment https://forums.phpfreaks.com/topic/95772-automated-backup-of-mysql-database/#findComment-490382 Share on other sites More sharing options...
dmccabe Posted March 12, 2008 Author Share Posted March 12, 2008 Thanks guys I didnt get chance to check back on this post till I was at home, so I will put the automated script in place tomorrow! Quote Link to comment https://forums.phpfreaks.com/topic/95772-automated-backup-of-mysql-database/#findComment-490664 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.