updating database

[Neemisha]

Thanks Kuroi for your quick reply

can we first solve the problem of database.........

To change the database on server I import the sql script

of the local computer in the server database
and it just replaced the all the tables with data.

after that the error generated is:

//ERROR
0 DB_ERROR_NOT_CONNECTED
in:
[select * from facelift _project_version WHERE

project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button

in your browser and re-check the information you had

entered to be sure you left no blank fields.
//--


I also compared both the database tables and data but

could not find any difference.

[kuroi]

The answer to your problem is going to be in the details.

How did you create the SQL script that you are importing to your hosted server?
Is it dropping and replacing the database and tables, or just the tables?
Did you also copy your configure.php files from your local computer?

[Neemisha]

The sql script from the local database was successfully imported on server database.
now I have 2 database on the server.
one created while installing zencart and other imported
I then changed the configure.php of the server to use the database imported from the local computer.

on my local computer I have setup the zencart and made changes as well as add my categories and products through the admin setting according to the features required.
Now I want to use this local database on server so that I don't have to again go through the admin setting and make the changes or add categories.

my local computer is windows based and server is Apache/linux

and also when I m using the server database with my local computer the zencart is working perfectly but viceaversa is not working

plz help