Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Question Unanswered: MySQL Heavy Uploads

    Hi All,

    Does anybody know how to upload heavy data (sql queries) to MySql database.
    Heavy like more than 100mb?

    PhpMyAdmin allows some particular amount like 30mb or so.

    What is any good solution?

    Pls help.


  2. #2
    Join Date
    Aug 2005
    If you have command line access to your server you can use:

    To take backup:-
    shell> mysqldump --quick db_name | gzip > db_name.gz

    To Restore:-
    shell> mysqladmin create db_name
    shell> gunzip < db_name.gz | mysql db_name

    This process is very fast otherwise you will have to modify php.ini file on server to increase value of parameters "max_upload_size" & "max_execution_time", also you may have to edit configuration file of phpmyadmin.

Posting Permissions

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