By sinisa.ilic on

Hi,

I have drupal development site at my home (localhost) and real site on the web. Usually I update content of my site at home firstly (add new pages, create new view, etc.) and after that I create dump file using mysqldump (the user name, password etc. on my site are equal to those of my hosting provider). My hosting provider has given to me ssh access to host server and I can copy dump file and restore the content of my home site.

I have spend a month to create new 30 000 pages at my home site and I wanted to copy them to web site. But, because the dump file was about 1.5GB large, the restoring took more than 10 hours.

Is there some easier way to copy only newer records from my home site to web site (with no root permission on web site)? Some synchronizing tool that can be triggered manually?

Thanks
Sinclair

⋅ Categories: Drupal 6.x

Comments

stevenc’s picture

stevenc commented

If you local and server are otherwise identical, you can use the module "Backup and Migrate" to manage your MySQL migrations.

http://drupal.org/project/backup_migrate

Whether you use this module or keep doing it by hand, be aware that you can (and usually should) exclude the "cache" tables' data from your backup file (any table that starts with "cache"). These tables can cause massive bloating of a MySQL dump and are unnecessary - after the migration, just run "Clear Cached Data".

Note that I said the table's data - you still need the structure of the tables to exist, just not the data inside.

30,000 records is still a lot to migrate so rebuilding the Cache will take time as well, but it should be much better than trying to run a 1.5GB restore.

---------------------------------
Steven Wright

Slalom