Database problems

[jo_h1971]

Hello

Hoping someone may be able to help!

I am having a similar issue to the person in this thread http://www.zen-cart.com/forum/showthread.php?t=50603 as I see two databases when I look at the admin.configure.php file and admin/includes/configure.php

I am no longer able to access one of the databases as we were having lots of problems with the host and then moved hosts. I think that the website is still picking up the products from the database that I cannot get in to so how can I update and backup the database if I can't get to it at all?!

Thanks in advance

[jammin320]

If your two config files are showing two different databases, then you certainly have an issue. They both should be pointed to the same DB. You will want to figure out which one is correct (probably by checking the behavior in your store), and make the appropriate adjustments.

As far as accessing the database, that is something that you will likely need to work out with your hosting company. They will have the information to allow you to access the database directly.

[jo_h1971]

Hi Ben

Thanks for your reply.

Thats the problem in a nutshell! The database is pointing to a host that I cannot contact anymore and have no access to. Is there anyway at all that I can do a back up of it somehow so I can move it to my new host?

Thanks for your help

[afo]

The database information in the config files should match. Do you know which one is correct?

If you didn't back up the database before the move, I doubt you can do it now.

[niccol]

If what you are saying is that the present install is using the old database then actually there might be hope. But to be honest this seems quite unlikely.

So:

Find out for sure which database is being used by the present install as it stands at this moment. Find out for sure before you do anything else.

Your present host should be able to give you access to the new database via phpMyAdmin (or a similar tool) Use that to really assure yourself that it is not the new database that is being used.

[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?