Big MySQL database, what is the best practice to backup (VPS/Dedicated)?
Posted by Rockland Steel on December 23, 2009 at 5:45am
Hello,
My website (shared hosting) is growing bigger.
Usually I backup using MySQLDumper (http://www.mysqldumper.net/)
It will backup fine, also no error when restoring. Then, when browse the site, some post will missing (not found), but the link to that missing posts still there. I have no idea whats going on. When looking at the database by checking the tables and compare it to the original database, it looks like no data loss, with same number of lines.
I dont really like idea of dump database. MySQLDumper is just best choice for shared hosting.
Read moreSubscribe with RSS 