restore mysql database

Question

I recieved a mysql backup without .dump as a extension from hosting provider. How do I restore that database somewhere else.

I am using linux box with mysql version 5.0 .

I have tried steps posted at How do I restore a dump file from mysqldump? but couldn't get through.

Thanks in advance.

If the database backup does not have a .dump extension, then what format is it on? Can you run it through "file" and find out what kind of file is it? — codehead
– codehead, Commented Oct 6, 2009 at 10:30
I got this from webhost4life admin control panel, when I did the backup of this database. — ANIL MANE
– ANIL MANE, Commented Oct 6, 2009 at 10:43

arno · Accepted Answer · 2009-10-06 10:39:10Z

2

You can do it via command line very simple:

mysql -u USERNAME -p < DUMP_FILENAME

answered Oct 6, 2009 at 10:39

arno

3572 silver badges7 bronze badges

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

Comments

dotty · Accepted Answer · 2009-10-06 10:29:55Z

1

If you use phpmyadmin as a backend tool, use the 'import' feature. This is located in a popup box. To activate this popup click the 'SQL terminal' looking icon on the left hand plane and in the window which pops up head over to the 'import files' tab and upload the dump there.

answered Oct 6, 2009 at 10:29

dotty

41.7k67 gold badges155 silver badges197 bronze badges

Collectives™ on Stack Overflow

restore mysql database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related