MySQL DB ?

[bighof]

I have switched hosts and cannot open th db.

Here is what my host wrote may be the problem.

 

It looks like you are using a incorrect mySQL server name. We do not run mySQL on localhost has many smaller hosts does ? we use a dedicated server for that (for performance and security).

 

The mySQL hostname you should use is: mysql.servage.net or mysql2.servage.net, mysql3.servage.net or mysql4.servage.net.

 

Where do I change the settings from localhost?

John

[WiseWombat]

I have switched hosts and cannot open th db.

Here is what my host wrote may be the problem.

 

It looks like you are using a incorrect mySQL server name. We do not run mySQL on localhost has many smaller hosts does ? we use a dedicated server for that (for performance and security).

 

The mySQL hostname you should use is: mysql.servage.net or mysql2.servage.net, mysql3.servage.net or mysql4.servage.net.

 

Where do I change the settings from localhost?

John

<{POST_SNAPBACK}>

Take a look in your configure.php files

inside your catalog/includes/configure.php

and your catalog/admin/includes/configure.php files

[bighof]

Hi

Did that and made changes.....BUT

 

I think I need to change the name of the db I imported, but how if needed. . At my new host I created a new db and put all the info as above.

Here is what I get when I call the store, with the old db name bighof_osc1

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

And here is what I get when I use the name of my new created db

 

1146 - Table 'my_new_name.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

This is what I was given by the host when I created a new db.

 

For your convenience we have included a small PHP example showing how to connect to the database:

 

<?php

 

$connection = mysql_connect("mysql4.servage.net",

"UserName",

"Password");

mysql_select_db("db_name", $connection);

 

?>

 

Help what do I need to do??? Did I need to make a new db?

When I go to the control I show no other dbs except the one I created.

If I do not need a new db, then I can leave the db name, and password the same...right??? But will the password etc. be reconized? Will the db show up after I do a restore? I put the db in via the backup db onto my desktop and then ftp into the db backup file in the admin, so the db name is still the old name, BUT the db has not been restored as I get the same messages when I try to get into the osCommerce admin

 

 

 

I have switched hosts and cannot open th db.

Here is what my host wrote may be the problem.

 

It looks like you are using a incorrect mySQL server name. We do not run mySQL on localhost has many smaller hosts does ? we use a dedicated server for that (for performance and security).

 

The mySQL hostname you should use is: mysql.servage.net or mysql2.servage.net, mysql3.servage.net or mysql4.servage.net.

 

Where do I change the settings from localhost?

John

<{POST_SNAPBACK}>

[WiseWombat]

Hi

Did that and made changes.....BUT

 

I think I need to change the name of the db I imported, but how if needed. . At my new host I created a new db and put all the info as above.

Here is what I get when I call the store, with the old db name bighof_osc1

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

And here is what I get when I use the name of my new created db

 

1146 - Table 'my_new_name.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

This is what I was given by the host when I created a new db.

 

For your convenience we have included a small PHP example showing how to connect to the database:

 

<?php

 

$connection = mysql_connect("mysql4.servage.net",

"UserName",

"Password");

mysql_select_db("db_name", $connection);

 

?>

 

Help what do I need to do??? Did I need to make a new db?

When I go to the control I show no other dbs except the one I created.

If I do not need a new db, then I can leave the db name, and password the same...right??? But will the password etc. be reconized? Will the db show up after I do a restore? I put the db in via the backup db onto my desktop and then ftp into the db backup file in the admin, so the db name is still the old name, BUT the db has not been restored as I get the same messages when I try to get into the osCommerce admin

<{POST_SNAPBACK}>

You can import your db_back.sql from your catalog/admin/backups/db_back.sql to your new database using phpmyadmin

[Wendy James]

Here is what I get when I call the store, with the old db name bighof_osc1

1046 - No Database Selected

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

And here is what I get when I use the name of my new created db

1146 - Table 'my_new_name.configuration' doesn't exist

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

 

These are two different errors.

The first is because you put the wrong name in the configuration.php file(s).

The second looks like you do not have any information in your database. Are you sure you installed the database? (sql file)