Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: max_execution time problem
01-07-2008, 11:56 PM #1
- Join Date
- Jan 2008
- Thanked 9 Times in 9 Posts
max_execution time problem
i want to export my 300GB data
i have no access to php.ini , no sheel access
when i want to export using phpmyadmin after exporting 80GB it says max_execution time exceeds
Is there any way to do this
01-08-2008, 02:01 AM #2
- Join Date
- Sep 2002
- Saskatoon, Saskatchewan
- Thanked 2,662 Times in 2,631 Posts
Few options there.
Execution time can be manipulated on a PHP_INI_ALL directive, so you can control it directly from a script. Best to do would be to cron tab partials and pull out the data in chunks - 300GB is a lot of data, and unless you can physically mirror it, your server may not be too pleased if you transfer all that information.
If you have access through a shell or remote connection to the server, you can also perform a dump directly from a command line console. Perl can also help you transfer directly to a remote computer, if you have sufficient privileges on the server to run socket programs.
I'd go with the partials through cron jobs, 20GB at a time with appropriate logging could generate a script to do this for you over the course of a day.
Been gone for a few months, and haven't programmed in that long of a time. Meh, I'll wing it ;)PHP Code:
header('HTTP/1.1 420 Enhance Your Calm');