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? 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. 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. 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. 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! 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
Archived
This topic is now archived and is closed to further replies.