https://www.webmaster-forums.net/crss/node/1030193 en https://www.webmaster-forums.net/web-database-development/syntax-error-when-uploading-database-phpmyadmin#comment-1176676 <p>What is the error?</p> <p>A common error is Default ''; or Default '0'; fix is to remove the default bit</p> Mon, 15 Aug 2005 23:26:03 +0000 Busy comment 1176676 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/syntax-error-when-uploading-database-phpmyadmin#comment-1176651 <p>I've also found similar problems exist if you've dumped the file out to an .sql file using one version of phpmyadmin and are trying to import it using a new version of phpmyadmin. If it's still not working, open up the sql file and try doing addin the file chunk by chunk to the sql query window of phpmyadmin.</p> <p>Hope that helps!</p> Mon, 15 Aug 2005 18:01:38 +0000 gfawce1 comment 1176651 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/syntax-error-when-uploading-database-phpmyadmin#comment-1175893 <p>The syntax of MySQL commands changed from 4.0.x to 4.1.x, so that's probably the problem. You can use a text-editor's Replace feature to fix the commands in the .sql file.</p> Tue, 02 Aug 2005 00:14:38 +0000 IanD comment 1175893 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/syntax-error-when-uploading-database-phpmyadmin#comment-1175817 <p>Sounds like you have something wrong in the database flat file.</p> <p>Can you paste this file or is it sensitive info?</p> <p>Could be something as silly as a ' in the wrong spot.</p> Sun, 31 Jul 2005 14:49:55 +0000 techniner comment 1175817 at https://www.webmaster-forums.net