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]
