CiviCRM Community Forums (archive)

We are on version 1.9 and I'm looking again at trying to upgrade to the current version 3.0.2.  We currently have 1.4 million records, with most being activity records.  While we seem to be able to backup using PhpMyAdmin, I'm pretty sure I can't reload to the test server with PHPMyAdmin because of the number of records.  I have used a utility called bigdump to do with large phpBB forum, but not sure that is the best.

I tried the Cpanel backup MySQL which appeared to work, but the reload only creates the database, not the tables within it.

How are others moving larger CiviCRM installations between servers?

My intent is to tryout the http://dharmatech.org/blog/civicrmupgradetool/03/06/09 tools to see if they might help with the upgrade, if not afraid of a very long process to upgrade release by release.   Do any others have experience upgrading across versions?

See also: http://forum.civicrm.org/index.php/topic,6433.msg34316.html#msg34316

Thanks.

Thanks - MySQLDumper does look interesting.  It appears that it only uses the PERL for scheduled backups, which is good, somehow, I seem to be allergic to PERL.  

Note, the problem is the restore because of file size, not the dump from PhpMyAdmin.  MySQLDumper looks like it goes both ways which is good.  I'll try it out.

Thanks.

hey DT:

any chance u'll can take a look into providing a patch for CRM-4987

the UpdateMembershipRecordScript is not very efficient and can be improved significantly, IMO

lobo