MySQL Database Import

ballistic509 · 03-29-2007, 08:02 PM

I currently have a 6MB SQL file, phpMyadmin only allows up to 2MB. How can I import this whole file into MySQL?

kstan · 03-29-2007, 09:39 PM

Hi ballistic509,

inside the phpmyadmin folder, type
grep -n "max" * (Max, MAX, or etc)

to see whether have any ideal

Good luck,
Ks

Guttorm · 03-30-2007, 07:52 AM

I think the 2mb limit is in php.ini, not in phpmyadmin. On my server I've increased it to 40mb in php.ini and phpmyadmin says the limit is 40mb.

A simpler solution is to gzip/bzip2 the sql file before uploading. Phpmyadmin will autodetect that it's compressed and uncompress it on the fly.

ballistic509 · 03-30-2007, 12:22 PM

Thanks both of you for your replies. As I researched into this, i learned that the best way to do bigger databases was to use the mysql command from the console so thats what I did and it worked just fine.

kstan,

When I used the command you gave I just got a screen full of information I couldnt make out lol, but thanks.

kstan · 03-31-2007, 01:26 AM

hi, the command will tell you what keyword you find in particular file (and the row number too). So you can slowly see through and find which file you going to ammend.