[thelist] MySQL PHPMyadmin

A Maynes andrew at milords.com
Thu Jan 12 03:21:41 CST 2006


Hi Max, I have heard that the command loine is the best method but
runnig one from a remote machine to the server is the problem although I
do have remote access.  Any suggestions? Examples of a command line
import?

Andrew


-----Original Message-----
From: Max Schwanekamp [mailto:lists at neptunewebworks.com] 
Sent: 11 January 2006 19:56
To: thelist at lists.evolt.org
Subject: Re: [thelist] MySQL PHPMyadmin


A Maynes wrote:
> Does anyone have a resolution as to why a gzipped import using 
> PHPmyAdmin times out after 300 seconds?  Everything was working finr 
> before xmas but now I can't import, very strange!

How big is the file?  You might be running into one of the php resource 
limits set in php.ini (e.g. max_execution_time, memory_limit, 
max_input_time, post_max_size, upload_max_filesize).  I've always found 
PMA handles non-compressed files better, and if it's larger than 1M or 
so, skip PMA and do it from the command line instead.

-- 
Max Schwanekamp
http://www.neptunewebworks.com/
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 





More information about the thelist mailing list