RationalDev

more of an aspiration than a claim

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
-- -------------------------------------------------------