Re: delete all database and restore
I have like 10 databases all backup to a single sql file. how do i restore
this to all database?
when i do mysql -u -p < backup.sql
I get
ERROR 1049 at line 24: Unknown database '`admin`'
what does this mean? I have a database in there called admin
how do I import all of them
"Good Man" <heyho@letsgo.com> wrote in message
news:Xns99E1F345EAA3Esonicyouth@216.196.97.131...
> "nobody" <nobody@nobody.com> wrote in
> news:fgtkup$ilr$2@news.Stanford.EDU:
>
>> I basically want to replace all the databases from one dump file I
>> have. How do I restore the databases from one dump file?
>
> mysql -u <username> -p < 'path/to/dump/file.sql'
>
> i suppose that answer could've been found at the google though.
|