I am trying to add an SQL dump to my exisitng DB.
The dump files are large (up to 60MB) in size.

I was going to use the SQL tab on myphpAdmin to add the dump to my SQL DB.


Using phpMyadmin 2.5.7
Now on the SQL page I see
"_ Show this query here again

Or Location of the textfile_:
_(Max: 2,048KB)
Compression: Autodetect___ None___ "gzipped"___ "bzipped"___"

1. HOw can I raise the Max size of the textfile?

2. Or, how can I upload the SQL dump first and THEN add it to the DB?

3. Should I upload as "filename.sql.bz" in order to make the upload faster? (will phpmyadminn know how to uncompres the file into the database?)

Thanks in advance

Yes, if you gzip the file ( run gzip file.sql to make it file.sql.gz ) that will reduce the size heaps, and yes phpmyadmin can uncompress it.

Gzip makes files slighly larger than bzip, but bzip takes much longer to run to it's usually best to use gzip for compressing stuff unless you really need the extra few bytes space.

Ok I'll try to use the Gzip first,
How can I raise the Max of the textfile?

I do it the old fashioned way - open up the SQL text file and copy and paste. :)

How I do it :
- Have one Internet page open (phpMyAdmin).
- Have the SQL text file open (your 60 MB file).
- Place my cursor on the first SQL line.
- Press the shift key
- Press the 'Page Down' key
- Wait about 30 secs.
- Copy it to your clip board
- Paste it into the SQL Query box
- Give it a go
- Repeat steps above until finished.

I bet I'm not much of a help, ay ?