Restore Mysql

Discussion in 'MySQL' started by rakesh kumar, Aug 13, 2011.

0
  1. #1
    I have taken backup of my website using phpmyadmin and the size of mysql database is 100MB in size. My i want to restore the same on my local system but when ever i try to restore phpmyadmin show size error message. Kindly advice me.
     
    rakesh kumar, Aug 13, 2011 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    You can use command line to restore the backup with the following command
    mysql -umysql_username -p db_name < backup.sql
    Code (markup):
    or increase upload file limit in PHP.
     
    mwasif, Aug 15, 2011 IP