LOCALHOST importing problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

LOCALHOST importing problem

Post 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.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: LOCALHOST importing problem

Post by Celauran »

phpMyAdmin might not let you import beyond a certain amount, but the CLI sure will.

Code: Select all

mysql databasename < filename.sql[
Dodon
Forum Commoner
Posts: 64
Joined: Wed Aug 03, 2011 4:11 am
Location: Netherlands

Re: LOCALHOST importing problem

Post 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
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

Re: LOCALHOST importing problem

Post 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.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
Post Reply