Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Rob Wellesley on June 15, 2002, 10:08:37 AM

Title: restore database from backup
Post by: Rob Wellesley on June 15, 2002, 10:08:37 AM

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

Title: Re: restore database from backup
Post by: Des Dougan on June 15, 2002, 10:38:40 AM

Rob,

mysql database_name < database_name.backup

The MySQL site has pretty good searchable documentation:

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

Des Dougan

Title: Re: restore database from backup
Post by: Rob on June 15, 2002, 12:48:45 PM

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

Title: Re: restore database from backup
Post by: Sergio Korlowsky on June 25, 2002, 10:07:54 PM

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.

Title: Re: restore database from backup
Post by: Des Dougan on June 26, 2002, 11:01:27 AM

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

Des Dougan