Page 1 of 1

LOCALHOST importing problem

Posted: Fri Sep 30, 2011 5:17 am
by simonmlewis
Hi
I had to do a factory reset on my laptop.
I was able to export 16mb of the entire LOCAL Host database.
But now it won't let me import over 8mb, so I have about 25 databases and I cannot install them.

Is there a way around this? Why on earth does it let you import over 8mb, if you cannot import it.
I've been "led up a garden path"!!!

Hope someone can help.

Re: LOCALHOST importing problem

Posted: Fri Sep 30, 2011 6:39 am
by Celauran
phpMyAdmin might not let you import beyond a certain amount, but the CLI sure will.

Code: Select all

mysql databasename < filename.sql[

Re: LOCALHOST importing problem

Posted: Fri Sep 30, 2011 6:52 am
by Dodon
You can also increase the POST_MAX_SIZE in the php.ini that will solve the issue as well
Also upload_max_filesize in the php.ini

Re: LOCALHOST importing problem

Posted: Fri Sep 30, 2011 10:05 am
by simonmlewis
Or the other answer as I discovered by accident, is to use an older versino of XAMP as that allowed 128mb, and didn't have the apache problems the newer version had.

Thanks all.