hi

sorry for double posting
but i just remebered one thing
if you don't have ssh access you could  create a .sh file with the dump commands, 
upload it along with your db file and call exec (.sh file) from a php page 
(setting it as a background process), hmm. i think it should work; haven't tested it 
though

regards


26/12/2001 15:11:05, Miles Thompson <[EMAIL PROTECTED]> wrote:

>Andy,
>
>That's a rather large file. It looks like execution time is under the 
>control of your ISP, so you don't have the option of increasing it. So 
>chunk your table. Assuming it is stored locally at present, break it into 
>into chunks, and move and each chunk, eliminating the table creation code 
>from the text created by mysqldump after you have imported the first chunk.
>
>Have you console, i.e telnet or SSH access to the web server? You could ftp 
>the whole thing to whatever directory you have access to, then execute 
>"mysql  database_name < name_of_mysql_dump_file". Or get your ISP to 
>execute that command. 75 MB is a  rather large file
>
>Cheers, and as before, Merry Christmas - Miles Thompson
>
>
>At 11:59 AM 12/26/2001 +0100, Andy wrote:
>>Hi guys,
>>
>>I have a table with over 2million entries. In order to upload this table to
>>my providers db I use mysqladmin to export this table as txt file.
>>Unfortunatelly I get following errormsg:
>>
>><br>
>><b>Fatal error</b>:  Maximum execution time of 300 seconds exceeded in
>><b>e:\projects\globosapiens\07_production\actual\mysqladmin\tbl_dump.php</b>
>>on line <b>27</b><br>
>>
>>
>>Does anybody know how to get this huge table transfered to my providers
>>machine?
>>
>>Thanx in advance,
>>
>>Andy
>>
>>
>>
>>--
>>PHP Database Mailing List (http://www.php.net/)
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>-- 
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to