Database problem

- 429 Posts
c-m Reply #1, 17 years, 1 month ago
Hi,

I am trying to move a site from one hosting another account.

I copied the files and folders over as usual but have been unable to import the database.

This is from a windows host to another windows host. when I try to import the database i get the following error;
```
Error

SQL query:

#
# Dumping data for table `webshop_active_users`
#
INSERT INTO `webshop_active_users`
VALUES (
'1', 'admin', '1254301818', '', '93', '62.249.228.140'
);

MySQL said: Documentation
#1366 - Incorrect integer value: '' for column 'id' at row 1 
```
The thing is I have successfully imported this database into a Linux hosted account, but it just will not work importing via phpmyadmin in windows.

Any ideas?
- 2,204 Posts
Dimmy Reply #2, 17 years, 1 month ago

there are som things you have to check:

is the version you export the db from lower or ecual to the new mysql server?
you exported it from linux? try file encoding from linux to windows can be differnces in that

try exporting using compatibility mode in mysql

Greets Dimmy
follow me on twitter: @dimmy01