Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

MySQL Import Error

Nov 5, 2005, 10:34 PM
Clint
User (387 posts)
Nov 5, 2005, 10:34 PM
Post #1 of 2
Views: 1648
Shortcut
Quote Reply
MySQL Import Error
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:-
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

Last edited by:

Clint: Nov 5, 2005, 10:47 PM
Nov 6, 2005, 5:40 AM
Clint
User (387 posts)
Nov 6, 2005, 5:40 AM
Post #2 of 2
Views: 1590
Shortcut
Quote Reply
Re: [Clint] MySQL Import Error In reply to
Greetings!

Worked out the problem to the above thanks. Tables were being created as INNODB and this was causing the problem. Doing the dump with phpMyAdmin solved the problem.


Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory