Re: [PHP-DB] Backup of huge DB fails because of max execusion time

2001-12-26 Thread gaouzief
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 test

Re: [PHP-DB] Backup of huge DB fails because of max execusion time

2001-12-26 Thread Miles Thompson
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