[thelist] MySQL PHPMyadmin
Paul Bennett
Paul.Bennett at wcc.govt.nz
Thu Jan 12 14:27:41 CST 2006
I can't remember the exact syntax, so this is from the MySQL manual[1]
Cmd > mysql -h path.to.dbserver.com -u user_name -p your_pass
The command line is fantastic for importing / exporting big files - you don't get the timeouts that phpmyadmin gives you and the operations seem to be processed faster
[1] http://dev.mysql.com/doc/refman/5.0/en/connecting.html
HTH,
Paul
-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of A Maynes
Sent: Thursday, January 12, 2006 10:22 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] MySQL PHPMyadmin
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 !
--
* * 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