My former host disappeared off the planet a few days ago and I have to get my site running asap. I have purchased hosting from Godaddy and set up a whole new fresh install of Zencart (1.3.9h).

I had a complete backup of all the files which I uploaded successfully but I am now stuck because I cannot get the database to connect.

Here is what I found: My old SQL and admin config file does not reference zen_ on any tables at all but the new SQL and admin config does.

Other than comparing and making changes line by line on a huge SQL file, is there a way to get my database recognized by the new cart? As a test I edited the admin config file by removing the zen_ (define('DB_PREFIX', 'zen_') and the database was recognized but it caused my website to be in maintenance mode permanently. I then added the line back to the config which allowed me to access my store.

Any suggestions for an SQL and database dummy?