phpMyAdmin...restoring from large files

jomaco1 · #1 05-31-2005, 01:32 PM

I have a db backup file that is over 4MB. phpMyAdmin says (under the query window) "Max: 2,048MB" for running a query from a text file. Is there another way to restore from a text file without having to break the file down into smaller files?

keliix06 · #2 05-31-2005, 01:37 PM

That's because of the php filesize limit. Breaking it up (I would just copy/paste parts directly into phpMyAdmin) would be best to keep the server from overloading.

Mambohut · #3 05-31-2005, 01:39 PM

You can upload it to the server and run this command from sxxxx as root
#mysql -uroot -p dbname < db.sql

jomaco1 · #4 05-31-2005, 01:43 PM

Thanks guys!

mambovince · #5 05-31-2005, 06:50 PM

If you don't have command line access, this seems to be made for such situations:

http://www.ozerov.de/bigdump

- Vince

jomaco1 · #6 05-31-2005, 07:09 PM

Thanks! That's definitely worth taking a look at.

mambovince · #7 06-14-2005, 05:48 PM

Hi Mark,
did it work out for you?

- Vince

buglerroller · #8 06-25-2005, 07:24 PM

yo should try to compress(gzip works the best) your sql file before upload. had the same issue and before changes to time/file_size limits were changed, compression was the best route.