Hi, On our server we currently use mySQL Admin (great product) on our windows 2003 server to backup a db daily. It stores the entire db in a text file. We need to automate this hourly but mySQL Admin doesn't allow that. How can we do this efficently and of course it needs to be reliable? Thanks
Hello, I would write a script that runs command line utility like mysqldump every hour. Or you can use program like this: http://backup-watcher-for-mysql.desktop-software.qarchive.org/ pixel876
If you have system shedule service, you can create a task, and run a simple bat file mysqldump dbname --user username --pass=password > dumpfile.ext
Hi, Yes I can do that. One problem is "locking" the tables. Is it possible to perform a "mysqldump" withotu locking the tables much like an innotable dump? Thanks
You can also stand up a second MySql server and have them synchronize (cluster) so both are identical at all times. One is read/write for your site, and one is just write only for a backup copy.
Yes this sounds a good way of securing data. Does mySQL allow this to be performed over the internet? For example if I have a server in a remote location for added security. If "write" only this wouldn't use too much b\w I doubt. Are there any issues using this method and lastly is it easy to set up replication of this kind (for example setting up HD raid is pain unless you start with RAID and not adding it at a later point?) Cheers
I've done it over the Internet before, yes. It doesn't use much bandwidth, since you're just writing changes. Issues? I am sure there are, it took me a little while to figure everything out but otherwise worked fine. Check the MySql site and search for clustering, or any number of Google results, and you'll find more than you could imagine, I'm sure!
Ok I will look into it! Looks a great way to backup data. Last Q. Is there any security issues with opening port 3306 on the firewall?