Big MySQL database, what is the best practice to backup (VPS/Dedicated)?
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 moreMeeting Notes : 2009.09.02
Discussions - Links
Project Tracking
- Pivotal Tracker - http://www.pivotaltracker.com/
- Open Atrium - http://www.openatrium.com/
SEO
- SEO Checklist - http://drupal.org/project/seo_checklist
Theming - Misc
- Fusion - http://www.topnotchthemes.com/blog/090709/tnt-2-0-and-future-drupal-them...
- Top Drupal Dev Firms - http://developmentseed.com http://pingv.com/
Backup Migration and Legacy DB Support
<
ul>
Read moreDrupal Dev Environment Virtual Machine. Install notes and scripts.
Hi,
Imagine being able to teach someone to review/create patches, without having to teach them to setup a LAMP development environment.
Imagine windows and mac users, friends, learning together to do (blank) with a virtual machine development environment.
I created a virtualbox Drupal development image. I wanted a simple platform to collaborate with several others on for a project. I thought others might benefit from the work.
Features include:
- Slim lightweight image (OS+tools are under 1gig)
- LAMP with APC
- Netbeans and Eclipse with debugging
Make a clean snapshot of a drupal website, files and databases
The classical mysqldump is not enough to backup a drupal website.
With Snapshot, you can freeze your website and make a clean snapshot, mysql data and files. Different backup type can be done, simple copy, rsync and even rdiff-backup wich provide differential backup.
For now, only myIsam tables can be backuped. I follow percona work to handle innodb soon. Postgres must not be hard to handle.
For now, backup is local. Soon, distant copy will be handled with rsync, ftp and even S3.
Beta version is on github : http://github.com/athoune/Drupal-Snapshot/tree/master
Read more
