Re: phpmyadmin import
| From: | Paul Scott | Date: | Mon, 23 Jan 2006 19:02:40 +0000 |
| Subject: | Re: phpmyadmin import | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-229115@lists.php.net to get a copy of this message | ||
On Mon, 2006-01-23 at 13:00 -0500, Austin Denyer wrote:
> Check the following entry in your php.ini file:
>
> memory_limit
>
> It's possible you may also need to check this one, too:
>
> post_max_size
I realise that I may get flamed for this on a PHP list, but, generally
when I import sql files to mysql larger than the PHP seetings can
handle, I would use the mysql command line to do it:
mysql> \. /path/to/file.sql
That way, in the case that it is just once off test data, you don't have
to worry about fixing your PHP config later. OTOH if you do a lot of
large imports then it probably is worth your while changing the php.ini
in the ways described in this thread.
--Paul