[Solved]: backing up data base - How?

[dapazman]

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

[François Keller]

Are 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

[Joachim Müller]

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.

[dapazman]

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

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?

[Joachim Müller]

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.

[dapazman]

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.

[Joachim Müller]

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