Hi, Im running a database server (mysql). In the past few weeks i have had a lot of downtime on the server meaning my websites can work with out my database. Im about to purchase some more hosting and i would like to create a back of this database on the new host so that if my main database goes down i can quickly switch to the backup version. What is the best and most secure way to backup my database? it is changing on a minute by minute basis? Any suggestions?
Put phpmyadmin on then goto Export --> save as file an then save the sql code on ur comptuer. then you can run that and it will create the tables on another database by clicking SQL and finding the document
darrens does the mysql service on the host go down or does the whole server go down? If the whole server goes down there's absolutely no point in buying another account, rather go for clustered failover service (choose wisely). If mysql fails then the host should see what breaks it.
Sorry to hijack a thread but I wonder if Darrens is getting a similar problem to what I am? Does anyone know how I would go about cloning a database from one of my sites and moving it to another? I have tried the above and get problems with access because site1_database cannot be accessed by site2_database (I hope that makes sense?) Any help would be much apprecated.
Hi, The issue with my present supplier isn't that bad but for saftey reasons i feel happier if i have my database in 2 places ! As for phpmyadmin + export ... this would rely on someone manually doing this? is there not a way that everytime one database was edited the second cound be done at the same time (realtime)
You could write some php code to create a db backup but you are far better off just getting a decent host. Mine backs up everything offsite every day. If I delete a table by accident they can upload a backup within hours. I backup to my PC once a week as well.
If you have cpanel, click the backup icon and download the database. Then on the new account, upload the DB. Simple.