Trevor Local
asked on
create parallel tables on Mysql database - SlideShowPro Director
Hello
I have built a new website to replace the old, and am using SlideShowPro Director. The new site has a different layout (galleries / albums) than the original. I would like to populate the new site with content but not sure how I can do that. My hosting is on a shared host configuration so I can't use a new mysql database. I believe there might be a way to create parallel entries with prefixes on the current live database without affecting anything, but I'm not sure how that would work.
Ideally I could populate the contents (database) before going live with the new website layout.
Any tips greatly appreciated. thanks!
I have built a new website to replace the old, and am using SlideShowPro Director. The new site has a different layout (galleries / albums) than the original. I would like to populate the new site with content but not sure how I can do that. My hosting is on a shared host configuration so I can't use a new mysql database. I believe there might be a way to create parallel entries with prefixes on the current live database without affecting anything, but I'm not sure how that would work.
Ideally I could populate the contents (database) before going live with the new website layout.
Any tips greatly appreciated. thanks!
johanntagle
First of all, if my shared hosting provider only allows me to create only one MySQL database, I'd switch hosts =). Now, I believe by prefixes you mean you have something like prefixname_table1, prefixname_table2. Many applications support this as part of their configuration option - you only need to put the prefix name. But this is dependent on how the application is built so I think you better ask the SlideShowPro makers themselves at http://help.slideshowpro.net/
ASKER
thanks johanntagle. I'd really like to switch hosts. I'd take a recommendation if you have one.
I'll try SSP support and I'll ask them about the prefixname_table1. I don't know much about databases, but I doubt I'm the first to be in this situation, so hopefully the answer is a good one!!
I'll try SSP support and I'll ask them about the prefixname_table1. I don't know much about databases, but I doubt I'm the first to be in this situation, so hopefully the answer is a good one!!
I no longer use shared hosting, so sorry, no I cant recommend any. In the past I've used Hostmonster and SitEGround and was satisfied, but that was more than 4 years back and my needs were much simpler then.
ASKER
I got a reply from support:
When installing Director for the second time, you can enter a new database prefix in step 4 of the install process. Use something like: ssp2_
When installing Director for the second time, you can enter a new database prefix in step 4 of the install process. Use something like: ssp2_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Not sure how many tables are used. The thing that is different is the number of galleries, so not sure what SSP needs to create for that. The old site has one gallery, the new has four. I will copy the old gallery data into one of the new galleries. How that's done? No idea! But my main concern at this point is not interrupting the live website.
you need to determine which tables are for the galleries and copy them using the commands I described above. how do you access mysql? i'd imagine you have phpmyadmin (if you don't, I would really recommend you switch hosts). you can view the tables via phpmyadmin and do the copying from there. Suggest you just copy ALL tables from old to new then clean up from there.
ASKER
I just installed WampServer and connected via myphpadmin. I would like to take a backup for myself before we start anything. I assume it's as easy as hitting the "export" tab? Looks like there's an Quick and Custom.
To answer your earlier question there's 8 tables.
To answer your earlier question there's 8 tables.
With just 8 tables the procedure I described to copy all data over to the new tables should be easy. To backup, select database, click Export, select all tables, choose SQL, click save as file, enter filename, click go, then save the downloaded file.
ASKER
thanks for the help!