please help...restore 180 mb backup

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..

 

180MB are too much for phpMyAdmin. But you can do it on the command line: http://www.howtoforge.com/faq/6_4_en.html

 

or, much easier: use BigDump.

 

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