View Single Post

  #4 (permalink)  
Old 11-08-2007
nobody
 
Posts: n/a
Default 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.



Reply With Quote