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
Advertising
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]
