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

  2. falko

    falko Super Moderator

  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

    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