coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: dapazman on April 23, 2008, 03:13:01 AM

Title: [Solved]: backing up data base - How?
Post by: dapazman on April 23, 2008, 03:13:01 AM
Going from 1.4.14 to 1.4.18 - In the docs the first step is "First, make a backup (dump) of your database"  Are you refering to the items in the SQL folder (basic.sql, schema.sql, update.sql) ? Or is this something I need my Host (GoDaddy) to do.  I can ftp my entire site down to my local drive, will that do it? phpMyAdmin is beyond me, so don't recommend that.

Thanks
Title: Re: backing up data base - How?
Post by: François Keller on April 23, 2008, 07:05:28 AM
QuoteAre you refering to the items in the SQL folder (basic.sql, schema.sql, update.sql) ?
No that's not this.
if you cannot use phpmyadmin or another similar tool, you can use the backup plugin http://forum.coppermine-gallery.net/index.php/topic,40439.0.html (http://forum.coppermine-gallery.net/index.php/topic,40439.0.html)
Title: Re: backing up data base - How?
Post by: Joachim Müller on April 23, 2008, 08:06:18 AM
Coppermine galleries installed by your webhost GoDaddy might cause issues - godaddy is notorious for not allowing users to move away. If you have issues creating the backup you need, search the board for "godaddy" and you will find some threads where people complain that their godaddy-driven install is shielded against backups.
Title: Re: backing up data base - How?
Post by: dapazman on April 23, 2008, 06:00:33 PM
Quote from: François Keller on April 23, 2008, 07:05:28 AM
No that's not this.
if you cannot use phpmyadmin or another similar tool, you can use the backup plugin http://forum.coppermine-gallery.net/index.php/topic,40439.0.html (http://forum.coppermine-gallery.net/index.php/topic,40439.0.html)

Ok, this is great! Your salaries should be doubled! However, I was about to use version 2.3 of the plugin, but noted the  - Add "DROP TABLE" - was checked.  In other postings I read where this should not be checked :
(FAQ http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#BackupDatabase)  Yes or No to checking Add Drop Table?
Title: Re: backing up data base - How?
Post by: Joachim Müller on April 24, 2008, 07:11:28 AM
The drop table doesn't mean that your gallery's tables are going to be emptied when you run the backup. The option means: drop the tables if you perform a restore. As you only will need to perform a restore if something goes wrong, you shouldn't be too concerned. Additionally, you can easily get rid of the drop commands with any plain text editor. So after all, it doesn't matter wether you tick that option or not.
Title: Re: backing up data base - How?
Post by: dapazman on April 25, 2008, 04:33:54 PM
OK, I upgraded from 1.4.14 to 1.4.18 successfully, using the backup plugin to backup the database.  After running the plugin, the progress bar stopped at 94%.  Based on other comments elsewhere, I assume the backup is OK and only the progress bar has a problem.


...Coppermine galleries installed by your webhost GoDaddy might cause issues ...
   Having been warned before about GoDaddy I installed Ver 1.4.16 from this site not GoDaddys

...The option means: drop the tables if you perform a restore...
   Gotcha. Thank you for that explanation.

Thanks for your help. I only wish I was a programmer to help out on this wonderful project.

  Original issue is definitly closed, thanks again.
Title: Re: backing up data base - How?
Post by: Joachim Müller on April 26, 2008, 09:36:06 AM
Quote from: dapazman on April 25, 2008, 04:33:54 PM
Thanks for your help. I only wish I was a programmer to help out on this wonderful project.
You don't need to be a programmer, see http://forum.coppermine-gallery.net/index.php/topic,14227.0.html