Page 1 of 1

MySQL import too big/large: BigDump != helpful

Posted: Tue Mar 04, 2008 4:31 pm
by JAB Creations
I'm running a local WAMP server and I am unable to import large SQL files. How do I remove file size limits altogether? What file(s) and line(s) do I have to modify? This is only for my local server which MySQL has no internet access to, just local.

Re: MySQL import too big/large: BigDump != helpful

Posted: Tue Mar 04, 2008 6:49 pm
by Christopher
How are you trying to import the files?

Re: MySQL import too big/large: BigDump != helpful

Posted: Tue Mar 04, 2008 7:08 pm
by JAB Creations
PhpMyAdmin.

Re: MySQL import too big/large: BigDump != helpful

Posted: Tue Mar 04, 2008 10:21 pm
by Christopher
Use the MySQL from the command line.

Re: MySQL import too big/large: BigDump != helpful

Posted: Mon Mar 10, 2008 1:12 pm
by anto91
JAB Creations wrote:PhpMyAdmin.
You should not use PhpMyAdmin to import file since phpmyadmin does not handle triggers and constraints correctly.