Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder o0O0o.o0O0o's Avatar
    Join Date
    Jan 2008
    Location
    C:\Windows\System32
    Posts
    1,018
    Thanks
    19
    Thanked 9 Times in 9 Posts

    max_execution time problem

    hi

    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

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 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.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •