How to change database

[GlennCoco]

Hello,

 

I was just wondering if anyone had any tips on how I can easily transfer and change the database. What I have is a database, called "xxxxxxx_oscommerce" with all of the tables in it, no prefixes for the tables. What I need to do is to change the database to "xxxxxxx_website" with a prefix of "osc_" for all of the tables. The reason I need this is because originally I only had one database because I only had this store set up. Since then I installed a Coppermine photo gallery and a calendar. Each one has its own database, and I'm trying to combine them all into one database with the appropriate prefixes.

 

So what I need help with first is to see if there is an easy way to change the MySQL file, other than the find and replace feature to insert the table prefix. Secondly I don't know which file(s) I need to change for the store to use the database in the new location.

 

Thanks in advance for any help.

[Nacer]

You can rename you database the way you wants, and them fill that name in you two config files.

 

Regards,

 

Nacer.

[GlennCoco]

I am now getting this error:

 

Warning: mysql_connect(): Access denied for user: 'theslabs_slabs@localhost' (Using password: YES) in /home/theslabs/public_html/store/includes/functions/database.php on line 19

Unable to connect to database server!

 

I am pretty sure I am using the proper username, DB name, etc. Since I changed the table prefixes, is there something I have to do there to make it work?

[GlennCoco]

Got it. I had to change the database tables in 2 different files. I didn't see that in the original instructions.

 

Thanks.