Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Change name on tables in DB?


Guest

Recommended Posts

Hi

 

A short question...

If i only have access to one database and i would like to have a second OsC-store on my server, is it possible to change the beginning of the database tables in the SQL-file before the installation of OsC and get it work properly without any fuss to the previously installed OsC?

 

What i mean with change the table is from (CREATE TABLE `address_book) to (CREATE TABLE `osc2_address_book)?

 

Is this possible or do i have to change thousands of lines of code inside the php-files???

 

 

 

Thanx for your input....

Link to comment
Share on other sites

I would imagine that you would have to find and change all the table names in the .sql file to the new table names.

 

Then you probably would need to do a massisive find/replace within the .php files too. They'll be still referencing to the old table names.

 

Make sure you backup your complete database and site before attempting it though.

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Link to comment
Share on other sites

Hi

 

A short question...

If i only have access to one database and i would like to have a second OsC-store on my server, is it possible to change the beginning of the database tables in the SQL-file before the installation of OsC and get it work properly without any fuss to the previously installed OsC?

 

What i mean with change the table is from (CREATE TABLE `address_book) to (CREATE TABLE `osc2_address_book)?

 

Is this possible or do i have to change thousands of lines of code inside the php-files???

Thanx for your input....

 

 

Take a look in the contributions, search for multi store or similar terms. This has already been done so no need to reinvent the wheel.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

Take a look in the contributions, search for multi store or similar terms. This has already been done so no need to reinvent the wheel.

 

 

Thanks for sharing that. I haven't had need to do it, and this will definitely serve me good. I wouldn't want to do it the way I suggested if there is something that already does it.

 

I'm gonna get me one. Thanks

 

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...