Upload Backup Database

[Vapor]

How/where do you upload backup database??

Please help!

Thanks!!!

email: indefinable[at]gmail.com

[Joachim Müller]

http://coppermine.sourceforge.net/faq.php#BackupDatabase

Joachim

[isajade]

thanks that helped me too 

[Vapor]

Uh, that only showed me how to backup my database not to upload/replace an existing db with the backup file i downloaded via. cpanel....  I tried the cpanel upload an existing backup feature but nothing happens....... does the gallery have a auto backup upload feature?

wow, i hate my life, this is going to be horrible if i have to redo everything....

[Tranz]

You would use phpmyadmin. Click the SQL tab, browse the backup file and click Go.

[ChaosCrusader]

I'm also having a problem with this.  I've followed the steps mentioned above to upload my backup using phpmyadmin.  The database contains the date etc, but when I go into Coppermine nothing has been changed.

I'm switching servers and using CPG1.3.1 on one and CPG1.3.2 on the new server.  It seems that the tables in my backup is named cpg131_table and CPG1.3.2 using cpg132_table.  Is there an easy way to get the data into the new tables?

[Joachim Müller]

before importing the mySQL dump into your new database, edit it with a plain text editor and do a search/replace. Search for "cpg131_" and replace with "cpg132_".

Joachim

[ChaosCrusader]

Thanks.  I figured that out after a while, although for some reason it didn't work for the comments, but that's not a big problem.

[xomaru]

hi guys,

i'm switching webhost and have followed instructions available on this board. but i am stuck at the restoration of the dumped file in the new server.

in PHPMyAdmin, i go to "SQL". then i browse to the dumped file and clicked "go!".

after a while, i get this message:

"No SQL Query! No tables found in database."

do i have to create all the tables before i can do the restoration? if not, what else do i need to do?

any advice will be apppreciated. i'm totally lost.

hope to hear from someone soon. much thanks in advance!

cheers,
dan.

[xomaru]

hi guys, an update!

i've managed to restore the dumped file into the new server.

a coupla things i did wrong which i thot i'd lay down in the off chance that it might benefit someone else:

1) when i exported/dumped the file from the original server, i actually FORGOT to select all the tables before exporting them! make sure you "Select All" the tables.
2) tick ONLY "structure" and "data" under the "SQL options" section. by default there may be other items such as "Add Auto_Increment value" and "Enclose table and field names with backquotes" ticked. i had these ticked the first time round and got an error when i tried importing the dumped file. so make sure you untick everything except "structure" and "data".

yep, that's about it. i'm off to my next step. so hopefully that's my gallery migrated!

cheers,
dan.