MySQL dump is too large to upload through phpMyAdmin

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

MySQL dump is too large to upload through phpMyAdmin

Postby What » 25. September 2008 08:11

I installed Xampp to test a phpBB install locally. I exported the database and my dump is 160MB. In Xampp, phpMyAdmin limits imports to 2MB. I tried changing those limits in php.ini without success.

Is there any way to import a large MySQL dump? Thanks!
What
 
Posts: 3
Joined: 25. September 2008 08:09

Postby Wiedmann » 25. September 2008 08:28

I tried changing those limits in php.ini without success.

How exactly?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby What » 25. September 2008 08:51

Thanks for answering! I tried to follow those instructions:

http://localhost/phpmyadmin/Documentation.html#faq1_16

I changed:
max_execution_time = 300000
max_input_time = 600000
memory_limit = 210M
post_max_size = 210M
upload_max_filesize = 200M

But in phpMyAdmin it still says:

Location of the text file [choose file] (Max: 2,048 KiB)

EDIT: I restarted Apache and now it says (Max: 205 kKiB) - but it still doesn't seem to work. I get a progress bar in my browser for about one or two minutes, then it stops, and, nothing...
What
 
Posts: 3
Joined: 25. September 2008 08:09

Postby Wiedmann » 25. September 2008 10:35

I get a progress bar in my browser for about one or two minutes, then it stops, and, nothing...

Can you see something in the error_log?

Making a large import with phpMyAdmin is not easy.

Maybe the UploadDir feature from phpMyAdmin can help.

Or just use the MySQL command line client. (This works every time).
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby What » 25. September 2008 23:14

Wiedmann, Thanks for the help. I kinda gave up for now as I'm trying to do the update live wihtout having to test it locally. But this is info I'll come back to if (when) I have to do some local testing again.

Thanks!
What
 
Posts: 3
Joined: 25. September 2008 08:09


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 1 guest