Database problems

[jo_h1971]

Wow everyone thanks for the replies.

How would I find out for definite which database is being used?

The admin/configure.php and admin/includes/configures.php database entries are definitely different.

Thank you so much again

[jo_h1971]

Come to think about it, the new host backed up the files and then transferred them themselves. I am nearly 100% sure that the database is still being hosted by the old hosts because we sometimes get the 0_db error not connected message and when I have contacted the new hosts about it, they said it is because it is still being hosted elsewhere

[niccol]

Questions:

What makes you think it is the old database that is being used? This is very very unlikey.

What did you do when you moved the site? Was the database exported in any way?

Can you find out from your present host how to access the database directly? As I said you are looking for phpMyAdmin or a similar tool. If you can do this then just change a bit of data, for instance a product name, in the database and see if that change is reflected in the shop. If it is then the new database is being used.

[niccol]

so, if the database was exported, then what is the problem with just making sure the new database is used?

Why do you want to try to export the old database again?

Surely you just want to make the configure files both point towards the new database?

Nick

[niccol]

And when did you transfer the site? How long ago?

[jo_h1971]

Hi Nick

Thanks so much for taking the time and trouble to help.

The site was hosted by a company who have been mentioned in several other threads on this site. Basically the site went down one day and we couldn't contact the hosts to get the site back up. We found another host and they managed to do a back up and transferred all the files so the site was up and running again, we didn't do any of it ourselves as we didn't know how to!

We switched hosts in Feb last year.

The new site is now hosted on a Plesk basis and although I have found the database on there, I cannot currently access that as that looks like it is password protected.

This is the info on the admin/configure.php

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '****_****');
define('DB_SERVER_PASSWORD', '****');
define('DB_DATABASE', '****_****');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

and this is the info on admin/includes/configure.php

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', '****.****.co.uk'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '********_****');
define('DB_SERVER_PASSWORD', '*******');
define('DB_DATABASE', '********_****');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'


Does this info help at all?

[niccol]

OK.

Well, the 'localhost' is a bit meaningless becuase that could be any host.

The other one on the other hand is specific to a host. Is this the new host or the old host? Do you know? Are you hosted by that company or is that the old company? It has the address of a hosting company after the first '.' and before the '.co.uk' so if this is the current hosting company then you should be able to tell us.

[jo_h1971]

Hi Nick

The first one is where I "think" the database still is. The second one is the host that we moved to. Like I said I cannot access the database with the new host because although I have found where it is it looks as though it is password protected.

Thank you again