We help IT Professionals succeed at work.

create parallel tables on Mysql database - SlideShowPro Director

Trevor Local
Trevor Local asked
on
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!
Comment
Watch Question

Top Expert 2012

Commented:
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/

Author

Commented:
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!!



Top Expert 2012

Commented:
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.

Author

Commented:
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_

Top Expert 2012
Commented:
Okay so the table prefix is addressed, so you're next step is to transfer data from old database to new one?  How many tables does the application use?  One way is to do the following for each:

insert into ssp2_table1name select * from table1name;
insert into ssp2_table2name select * from table2name;

Author

Commented:
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.
Top Expert 2012

Commented:
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.

Author

Commented:
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.  
Top Expert 2012

Commented:
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.

Author

Commented:
thanks for the help!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.