restore backup mysql

Question

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

How can I restore it in a new database on another server ?

mosg · Accepted Answer · 2010-05-23 18:08:41Z

2

Or just use phpMyAdmin for restore porpoise.

answered May 23, 2010 at 18:08

mosg

12.4k13 gold badges68 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pekka · Accepted Answer · 2010-05-23 18:06:18Z

1

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.

answered May 23, 2010 at 18:06

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

cherouvim · Accepted Answer · 2010-05-23 18:06:14Z

1

Using:

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

answered May 23, 2010 at 18:06

cherouvim

32k15 gold badges107 silver badges158 bronze badges