https://www.webmaster-forums.net/crss/node/1035242 en https://www.webmaster-forums.net/web-database-development/uploading-sql-error#comment-1204168 <blockquote class="bb-quote-body"><p><strong>Greg K wrote:</strong> Check what version of mySQL is on each server. I know I tried to test an export from version 5 of mySQL on an older server and it errored out. Back on a v5 server again it worked fine. Try doing a search and replace on the file, searching for <strong>ENGINE=MyISAM DEFAULT CHARDET=latin1</strong> and replace it with either a blank, or just a space. As long as when you set up the databases to begin with you didn't specify anything other than defaults for ENGINE and CHARSET, it should work fine.</p> <p>-Greg</p></blockquote> <p>Wow it worked great! Thanks so much!, That saved me hours of work. My host couldn't even help me with that. </p> <p>Thanks again!<br /> Jamie</p> Sat, 15 Jul 2006 08:42:09 +0000 john23 comment 1204168 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/uploading-sql-error#comment-1204133 <p>Check what version of mySQL is on each server. I know I tried to test an export from version 5 of mySQL on an older server and it errored out. Back on a v5 server again it worked fine. Try doing a search and replace on the file, searching for <strong>ENGINE=MyISAM DEFAULT CHARDET=latin1</strong> and replace it with either a blank, or just a space. As long as when you set up the databases to begin with you didn't specify anything other than defaults for ENGINE and CHARSET, it should work fine.</p> <p>-Greg</p> Fri, 14 Jul 2006 21:59:45 +0000 Greg K comment 1204133 at https://www.webmaster-forums.net