restore backup mysql

I have a backup of my database in mysql of 250MB !!

How开发者_如何学C can I restore it in a new database on another server ?

Or just use phpMyAdmin for restore porpoise.

You are providing no detail on what operating system you're on and what kind of backup you have, but the short answer is

mysql -u username -p -h hostname databasename < dumpfile.sql

where dumpfile.sql needs to be a file containing SQL statements, for example produced with mysqldump.

Using:

mysql -u USER -p -h HOST DATABASE < mysqldump.sql