Automated Backup
General April 10th, 2005I have been experimenting with backing up and synchronising data between my local server and my web server (Delphi) at Site5.
I have setup MySQL Administrator to backup my databases to my server on a daily basis. This is a fully automated backup of all databases.
I have also setup SQLyog to synchronise selected databases between my server and Delphi. This allows me to post this blog entry locally and for it to be replicated accross to the MySQL database on Delphi automatically, and vice versa.
The next step is fully automate the backing up of files between the two servers.
4 Responses to “Automated Backup”
Leave a Reply
You must be logged in to post a comment.
April 11th, 2005 at 6:28 am
I had written up a couple of lines about all the above when your blogging system told me my comment was too long. Gutted! Now my email is incorrect too.
April 11th, 2005 at 7:23 am
I had set a size limit on comments before I had setup the anti-spam plugins and forgotten to remove it afterwards. I have now removed this and so you should be able to write as much as you like!
I also had an option enabled to check for MX records for email addresses to validate them, this causes the invalid email address error message. I have disabled this for the time being.
April 14th, 2005 at 10:13 am
Well, I assure you bootc.net has 2 valid MX records
On with big rants!
April 14th, 2005 at 5:00 pm
Well it couldn’t seem to access them! I suspect dodgy code or something my host have done to block access.