Backing Up

Neal-UK · July 13th, 2005, 07:11 PM

How can I backup the images in my old database to move into my new one if possible, and then how do I add them back?

ConqSoft · July 13th, 2005, 07:14 PM

Back up the database. Back up everything under the files directory under your Gallery directory.

ConqSoft · July 13th, 2005, 07:15 PM

The images aren't stored in the DB, only info about them. The actual images are in that files directory.

Neal-UK · July 14th, 2005, 11:01 AM

Right i've copied all users images to files on my computer. Kept them in the same directory structure. I've also backed up my gallery database and saved that to my computer also.

However, my forum db tables now start with FORUM so how can I add this back so users images are how they were before I changed the forum around? I've also moved the forum to a new folder so it's not www.sgfdgdgd.com/fourm but now www.sfr4tr4gt53.com/community

Neal-UK · July 15th, 2005, 11:44 AM

Brian, are you there?

Is there a way to do this?

July 15th, 2005, 12:21 PM

Just upload the images, restore your gallery backup, and then rename the tables and add the prefix to each one.

Neal-UK · July 15th, 2005, 02:20 PM

Right, i have the text file backed up onto my computer. How do I install this back into the database. The text file is named '_TABLE_.sql' and is 367kb in size.

I'm just re-uploading my users images back into the gallery folders on my server.

Neal-UK · July 15th, 2005, 02:22 PM

..bearing in mind that i now already have vbgallery installed again with prefixes FORUMtablename already, but it is turned off and there are no new images

July 15th, 2005, 02:39 PM

Either go to phpMyAdmin and upload the sql file through there, or restore it through telnet. Then delete the gallery tables that were created when you installed it again and rename the tables you just restored.

Neal-UK · July 15th, 2005, 04:12 PM

Okay, with telnet I can use this command can't I? I don't want to delete my db (I have backed up though):

mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/NEW/FILE.SQL

July 15th, 2005, 04:35 PM

Yes.

Neal-UK · July 15th, 2005, 06:48 PM

Well it didn't work. Users were assigned to the wrong images and images were not assigned to anyone. Even when updating counters.

Never mind, just have to start from new.

ConqSoft · July 15th, 2005, 06:56 PM

If users were assigned to the wrong images, then you didn't use the same user table that you were using before. The userids don't get changed during a backup/restore.

Neal-UK · July 15th, 2005, 09:15 PM

I first re-inserted the forum database for my new forum.

I then inserted the gallery database and changed the adv_gallery_name_thingy to FORUMadv_gallery_name_thingy

My database prefix is now FORUM, I had none before.

It didn't work. My forum does.

ConqSoft · July 15th, 2005, 10:23 PM

Reinserted? Or Restored?

Neal-UK · July 17th, 2005, 09:11 AM

restored

July 17th, 2005, 08:04 PM

There's no way that would happen unless you modifed your user table and/or your gallery tables.

Neal-UK · July 18th, 2005, 05:08 PM

My tables were exactly the same as they were when they were downloaded. I wouldn't know how to alter them.