1030 got error 1 from storage engine

[Hawk007]

Hi, i have moved my cre loaded oscommerce shop from a server using:

 

Vista, php5, mysql 4.1,

 

I moved the site to a Server 2003 OS, php5 and mysql 4.1

 

I copied the database to the data folder on the new server then changed the configure files in: admin/includes and root/includes.

 

I get the following error:

 

"1030 got error 1 from storage engine"

 

Ive searched the net for answers over the past month but to no avail.

 

I also moved lots of pther php scripts that work fine on the new server.

 

If i reinstall the shop it works ok.

 

The original still works on the old server and has no database problems. But on logong on to phpmyadmin the database states Storage Engine Error when checking the tables.

 

Any help would be appreciated, many thanks s hawkins

[Jan Zonjee]

If i reinstall the shop it works ok.

 

The original still works on the old server and has no database problems. But on logong on to phpmyadmin the database states Storage Engine Error when checking the tables.

I would "drop" the database on the new store. Make a new one and use a MySQL backup from the database on the old server to populate the database on the new server with phpMyAdmin.

It sounds like you copied the binary files with the database and there is a problem with that.