Greetings:
Am running MySQL 3.23.5x on my 'live' server (Linux) and MySQL 5.015 on my home server (Win). I recently did a MySQL Dump from my Live Server and tried to import it into my home server. Everything seems to go okay until about 30 secs into the import when I get this message:-
( my_folder_id int(10) unsigned DEFAULT ''
NOT NULL auto_increment, my_folder_name varchar(255) DEFAULT ''
NOT NULL , my_folder_description varchar(255) ,
my_folder_user_username_fk varchar(50) , my_folder_default tinyint(3)
unsigned DEFAULT '0' NOT NULL , my_folder_public tinyint(3)
unsigned DEFAULT '0' NOT NULL , PRIMARY KEY (my_folder_id) );
When I did the MySQL Dump I used the 'Drop Tables' and 'Create Tables' options. I didn't have 'complete inserts' on. My guess is that it may have something to do with no data being in that particular table??
Any ideas?
Regards,
Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory
Am running MySQL 3.23.5x on my 'live' server (Linux) and MySQL 5.015 on my home server (Win). I recently did a MySQL Dump from my Live Server and tried to import it into my home server. Everything seems to go okay until about 30 secs into the import when I get this message:-
Code:
MySQL said: Invalid default value for 'my_folder_id'. <P> ( my_folder_id int(10) unsigned DEFAULT ''
NOT NULL auto_increment, my_folder_name varchar(255) DEFAULT ''
NOT NULL , my_folder_description varchar(255) ,
my_folder_user_username_fk varchar(50) , my_folder_default tinyint(3)
unsigned DEFAULT '0' NOT NULL , my_folder_public tinyint(3)
unsigned DEFAULT '0' NOT NULL , PRIMARY KEY (my_folder_id) );
When I did the MySQL Dump I used the 'Drop Tables' and 'Create Tables' options. I didn't have 'complete inserts' on. My guess is that it may have something to do with no data being in that particular table??
Any ideas?
Regards,
Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory
MySQL Import Error