MySQL import too big/large: BigDump != helpful

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

MySQL import too big/large: BigDump != helpful

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

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

Post by Christopher »

How are you trying to import the files?
(#10850)
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

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

Post by JAB Creations »

PhpMyAdmin.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

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

Post by Christopher »

Use the MySQL from the command line.
(#10850)
anto91
Forum Commoner
Posts: 58
Joined: Mon Mar 10, 2008 10:59 am
Location: Sweden

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

Post by anto91 »

JAB Creations wrote:PhpMyAdmin.
You should not use PhpMyAdmin to import file since phpmyadmin does not handle triggers and constraints correctly.
Post Reply