Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Luzern, Switzerland
    Posts
    62

    PHPmyAdmin DB restoration

    Hello,

    I am trying to restore my backup.sql.gz back up in phpmyadmin.
    Everytime i tried this method it works perfect, except for this time.
    This time i get an error saying that execution limit has been reached something like 300 seconds.

    I read somewhere thats its possible to edit the read_dump.php file and add the set_time_limit(3600) directive to allow myself more time to execute the script.

    Thanks

  2. #2
    Join Date
    Feb 2002
    Location
    Vestal, NY
    Posts
    1,378
    There is a maximum_execution_time variable in php.ini. You will need root access to modify the file. Otherwise, you may want to check into using SSH to dump your SQL into your database. See:

    http://dev.mysql.com/doc/mysql/en/mysqldump.html

    for info on how to restore from your dump file.
    H4Y Technologies LLC Check out our new website!
    "Smarter, Cheaper, Faster" - SMB, Reseller, VDS, Dedicated, Colo hosting done right.

    ZERO PACKETLOSS, ZERO DOWNTIME Dedicated and Colo - USA: IA, CA, NC, OR, NV
    **http://h4y.us**
    Voice: (866)435-5642. *** Email: askus at host4yourself d0t com

  3. #3
    Join Date
    Jul 2003
    Posts
    168
    You can also try extracting the gz to .sql file and use :

    mysql -uUSERNAME -pPASSWORD newmysql < /path/to/mysql.sql

    This will dump the mysql file to the mysql database.

    Regards,

    Rubal
    Rubal Jain // E-Mail - Rubal [at] Rubal.Net
    Helm Control Panel Setup, Installation, Configuration, Troubleshooting
    Helm Server Move, Service Migrations, Restorations, IP Renumbering
    Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening

Posting Permissions

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