I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL 4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin and MySQL 4.0.17.
I have a large database (200mb) and I'm trying to move it over. I made a dump using "mysqldump -u USER -pPASSWORD DATABASE > filename.sql", transferred it between servers via SCP, and tried importing it using "mysql -u USER -pPASSWORD DATABASE < filename.sql". After the last command runs for about an hour and a half, I get: ERROR 1067 at line 161570: Invalid default value for 'membersince' OK, so I look in the dump, and line 161570 has no reference to 'membersince'. The first occurance of that field is in line 326189. Any clue? Is this a bug with MySQL 4.0.17 and should I update? I've tried creating new dumps, transferring it directly to the server, transferring it from server -> my pc -> server, ftp, scp, etc. It makes this error everytime. Any help is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]