BigDump alternative

An alternative is to use a dedicated software that can open .sql files.

You can use HeidiSQL, download here (free).

From HeidiSQL, file > load sql file and pick to upload directly.

You will notice that the sql file is loaded into your database and you can manage it from there.

A good idea is to install Wamp (apache, php, mysql server) on your computer and connect and manage the sql file from there. Wamp is extremely easy to use. Just type “localhost” into your browser after you have installed it.

It is much faster than having to upload a 300-500mb sql file to a web server.

Wamp is also free and can be downloaded from here.

I have tried to upload a 400Mb sql file with the BidDump php script and “MySQLDumper” and both didn’t worked. They gave some errors: “MySQL says:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DELIMITER ;; /*!50003 SET SESSION SQL_MODE=”” */’ at line 1

Error in Query:
DELIMITER ;; /*!50003 SET SESSION SQL_MODE=”” */;;”

Anyway, use HeidiSql, this one should work.

mysql

ADD A COMMENT: