Rational Dev

Database

MySQL Dump Incorrect Format Bug

I had some fun trying to import:


-- MySQL dump 8.23
--
-- Host: blah Database: blah
---------------------------------------------------------

Which was giving me the strange error, "DROP TABLE IF EXIS' at line"

Turns out you need a space after a comment, so to fix it will be as follows:


-- MySQL dump 8.23
--
-- Host: blah Database: blah
-- -------------------------------------------------------

Posted On: August 30, 2009 - 3:45pm by Rational
( categories: )

SQL Command Reference Listing

Can't remember those SQL commands? Here is a list of SQL commands with in depth syntax and examples that can come in handy.

Posted On: February 1, 2007 - 2:54pm by Rational
( categories: )
Syndicate content
Google

Navigation