please help...restore 180 mb backup

Discussion in 'Programming/Scripts' started by gary1974, Nov 14, 2006.

  1. gary1974

    gary1974 New Member

    i have my back up of mysql. i want to restore it. how can i restore that using myphpadmin. is there another way to restore my backup? please advice

    gary..
     
  2. falko

    falko Super Moderator Howtoforge Staff

  3. sridhar

    sridhar New Member

  4. zcworld

    zcworld New Member

    when i gotta restore backups of anything from 20 to 40 mb
    i always TGZ them down
    and copy over the the box
    make sure my sql server can handle XXX filesize on imports than import via command line
    i find its easier
    than to do so from mysql or web phpmyadmin interface

    mysqld < filename.sql -u name -p
    walk away and comes back in 5 mins job done

    but
    its comes do :
    do you have access to mod the mysql settings on the filesize it can handle
    if so than upload the sql file mod the mysql server setting , restart mysql .. than import via that command up there
     

Share This Page