Moved Servers, Reinstalled Osc, imported mysql dbases

[Twanya]

Hello,

 

I tried to move my current unlauched store to a different server domain via cpanel, the old site was on cpanel as well. I installed osc on the new domain server, then imported in my old dbase only. I assigned the admin user to the dbase. Then, I updated the config page in admin and the root directories.

 

1. Here's what happens when I try to view the home page:

 

Error Message:

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

2. Here's what happens when I try to log in to admin:

 

1146 - Table 'foxyfm_foxytoys.administrators' doesn't exist

 

select id from administrators limit 1

 

[TEP STOP]

 

I'm not sure how to troubleshoot these.

 

Help?

 

Thanks

D n D

[FIMBLE]

Have you changed the username of the database? likely you have a different web username that need to prefix the database name and username.

Myusername_mydatabasename etc...

[Twanya]

Hello, thanks for your help.

 

Here's what I got when I followed the suggestion above.

 

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'foxytoys_admin2'@'localhost' (using password: YES) in /home/foxyfm/public_html/foxy_toys/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

Help?