Help restoring database - nothing seems to work

OK..i've been doing this for hours now. I've done a fresh install of Zencart 1.3.01. I backed up my database through phpmyadmin on my old site. I've gone through the restore bit. It looked like it went in, but the site still shows a fresh install. I Put my configure.php files from my old site in there, even changed the names of the database and the SQL server info. All that did was make it to where when I refreshed my site, it went to a 404 error saying zc_install could not be found. Of course it can't ... i deleted it after the fresh install was done!

No matter what I do, it goes back to that! I'm trying to move this entire site before June 10th or this host is gonna charge me another month.

Need more information.

you did a backup. ... assuming from the old host
you did "the restore bit" .... ? ... what exactly did you do here?
"when I refreshed the site" .... which site? what URL? what's the URL of the "old" site?

Sorry :) Guess its not good to assume anything..

you did a backup. ... assuming from the old host
I backed up my database through phpmyadmin on my old site. I've gone through the restore bit.
I did my restore through phpmyadmin on the new site at http://c11.servage.net/~sc20038-PLDS/store
(this is my temp url while I build the site back up). the old site - and i feel i have to give warning - is an adult fetish site at trampledelights.com/store

Your site is hosted on an Apache server - not Windows.

Vger

Vger:

Your site is hosted on an Apache server - not Windows.

Vger

AK! good god. Sorry about that guys. Can someone move this to the Linux section?

moved to correct forum

now..in looking through the sql file, everything has a zen_ prefix...whereas my new database does not...can i simply remove that prefix in the sql file?

techbot:

now..in looking through the sql file, everything has a zen_ prefix...whereas my new database does not...can i simply remove that prefix in the sql file?

That or you could re-install and put in the "zen_" prefix on the db settings page. Of course you should be able to change this in the config file(s) as well.

techbot:

now..in looking through the sql file, everything has a zen_ prefix...whereas my new database does not...can i simply remove that prefix in the sql file?

Since you're trying to restore your old database, the easiest way is to set your configure.php files to use the same table prefixes as the old site had.

Changing the prefixes can be done later, after you have your data up and running.

My main issue right now is that it keeps trying to read the zc_install folder...when I deleted it after install.

going to http://c11.servage.net/~sc20038-PLDS/store/

pops up a 404 error saying that > The requested URL /~sc20038-PLDS/store/zc_install/index.php was not found on this server.

DrByte:

Since you're trying to restore your old database, the easiest way is to set your configure.php files to use the same table prefixes as the old site had.

Changing the prefixes can be done later, after you have your data up and running.

OK...i just reinstalled. Here is my configure.php database section

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

my old database has the zen_ prefix, whereas my new database does not. I don't see anywhere in the new hosts database creation area to put prefixes or i would have done that

techbot:

OK...i just reinstalled. Here is my configure.php database section

my old database has the zen_ prefix, whereas my new database does not. I don't see anywhere in the new hosts database creation area to put prefixes or i would have done that

Zen Cart adds the table-prefixes during installation of a new site. So, if your old database has the prefixes, then you accepted the suggested prefix of zen_ during installation (it was a default during versions 1.2.0 thru 1.2.4).

So, if you just did a fresh install, and entered "zen_" for a table-prefix, but when you check the database, you don't have any tables using "zen_" as their name, then you've got the wrong database. Scroll all the way down the list to locate the "zen_" entries, since Z is kinda late in the alphabet :)

If you have both (with and without prefixes), you can delete the set without the prefix if you like.

In fact, if you have your new install working, and it's using the zen_ tables, then you can delete all the tables, then re-import your old database contents.
Then test.
Then upgrade the database if needed.

You'll most likely get that error if your two configure.php files aren't set up correctly - in which case the install folder is looked for.

Vger