Topic: restore database from backup

[Rob Wellesley]

Ok -

I can mysqldump database_name > database_name.backup

but how do I load it back in?

Any help would be appreciated - I am trying to put the same database on multiple machines

TIA..    ..Rob

[Des Dougan]

Rob,

mysql database_name < database_name.backup

The MySQL site has pretty good searchable documentation:

http://www.mysql.com/documentation/

Des Dougan

[Rob]

Des Dougan said:

> The MySQL site has pretty good searchable documentation:
>
> http://www.mysql.com/documentation/
>

thanks once again Des

I have perused the docs at mysql in the past and there is clear and easy to find info on backing up but I haven't found alot on restoring

I assume then, in an instance where i am trying to recover a corrupted database
that i will have to drop the original first?

thanks again

rob

[Sergio Korlowsky]

I have almost the same question and just about the same problem..
but what I need to do is 'restore' the database back from
mysql.dump   (generated by e-smith) to backup all records.

Once it worked when I restered the whole thing after a fresh install
well, this time I have everything back in place except the database, so
I need the command to restore the whole mysql.dump back.

Thanks for your help.

[Des Dougan]

The second message in this very thread has the command you want.

Des Dougan