I want to use old database with new install

I am trying to install a fresh install of zen-cart v150. After installing, I want to change the new database to my old database which has lots of products and customers and other data. When I import the old database to the new one, I cant see the data in old database in the new site. I dont know much about databases but I can see the database tables prefixes different, for e.g. new database table has "xyz_admin" while the old database table has zen_admin". Could it be the problem the site not showing old data once old copy is imported.
All I need is use the old database with the new install. Pls help.

geel:

All I need is use the old database with the new install. Pls help.

I'd advice against going the export/import route.

When you have the new install all up and running you should be able to edit the two configure.php files to point to the old database, then just run the DB update scripts.

As usual, make a backup of your database(s) before making any changes.

Cheers
Rod

thanks for the quick reply. I am trying as you suggested but I dont know how to run the database update script.

I dont know how to run the database update script
Run zc_install and you should be presented with "update database only"

thanks for the reply.
I edited the configure file and then uploaded it. Now it seems the site is not connecting the database. Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.

geel:

thanks for the reply.
I edited the configure file and then uploaded it. Now it seems the site is not connecting the database. Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.

Using these "one-click install" processes is not advised. In your case the install will auto-create a dbase name, a dbase user and dbase user-password, and will append these to the configure.php files. (So at least you have a visible reference to what the auto-install has named these components.)

If you are "not connecting to the database" it can only be a case of:

1. The NAME of the database in the configure.php files is not correct.

2. The USERNAME for the database in the configure.php files is not correct.

3. The USERNAME-PASSWORD for the database in the configure.php files is not correct.

If you have made a COPY of the database (with a different name) and are now trying to point the site to that new database, then the same "rules" apply.

The USER in the database must also have ALL PERMISSIONS to administer the database. This is a stage in the C-PANEL database creation function, and cannot be missed.

Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.
Go to the home page here and download a fresh distribution of ZenCart 1.5.0
Expand it on your PC and FTP the zc_install folder to your server

Hey Geel... howcome you get to live in paradise (Maldives)?

I am really envious of you !