just use the mysql console to dump out to a file (check manual for "OUTFILE" or something like that)
Advertising
/beau // -----Original Message----- // From: Nagasea [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 19 December 2001 10:11 AM // To: Thomas Lamy; [EMAIL PROTECTED] // Subject: [PHP-DB] Table to BIG to dump, how ? (PROBLEM AGAIN) // // // I forgot to mention that I'm using the PhpMyAdmin for // dumping the table. // Is there any way to make a php script to manually dump the table ? // Because It's not working if I'm using phpMyAdmin. // // -Naga // // --- Thomas Lamy <[EMAIL PROTECTED]> wrote: // >Hi, // > // >If it's a php script dumping the data, have a look at the // >"max_execution_time" config variable. IIRC the default is // 30 seconds, which // >you can override from within the running script with // >ini_set ("max_execution_time", 100000); // > // >Hope this helps. // > // >Thomas // > // >> -----Urspr=FCngliche Nachricht----- // >> Von: Nagasea [mailto:[EMAIL PROTECTED]] // >> Gesendet: Dienstag, 18. Dezember 2001 02:20 // >> An: Fred; [EMAIL PROTECTED] // >> Betreff: Re: [PHP-DB] Re: Table to BIG to dump, how ? // >>=20 // >>=20 // >> there are no error message, the browser is suddenly stop=20 // >> (like no connection) // >>=20 // >> --- "Fred" <[EMAIL PROTECTED]> wrote: // >> >Where is the error msg? // >> > // >> >Fred // >> > // >> >Nagasea <[EMAIL PROTECTED]> wrote in message // >> >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... // >> >> I always got this error message when I tried to dump my=20 // >> structure and data // >> >table to a file. // >> >> I think it's because the file table size it BIG (almost 10mb). // >> >> Is there anyway to dump that table to file without getting=20 // >> browser time // >> >out ? // >> >> // >> >> Please help me here.. // >> >> // >> >> -Naga // >> >> // >> >> _____________________________________________________________ // >> >> www.kaskus.com - Community Forum & Free Email service // >> > // >> > // >> > // >> >--=20 // >> >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:=20 // >> [EMAIL PROTECTED] // >>=20 // >> _____________________________________________________________ // >> www.kaskus.com - Community Forum & Free Email service // >>=20 // >> --=20 // >> 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:=20 // >> [EMAIL PROTECTED] // >>=20 // > // >-- // >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] // // _____________________________________________________________ // www.kaskus.com - Community Forum & Free Email service // // -- // 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]
