Re: Backup of huge DB fails because of max execusion time

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 <milesthompson@ns.sympatico.ca> 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: php-db-unsubscribe@lists.php.net >>For additional commands, e-mail: php-db-help@lists.php.net >>To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >