View Single Post

  #5 (permalink)  
Old 11-09-2007
Good Man
 
Posts: n/a
Default Re: delete all database and restore

"nobody" <nobody@nobody.com> wrote in
news:fh07qu$n4$2@news.Stanford.EDU:

> 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.

>
>
>


Didja look at line 24?

Are you sure you have a database called "admin" and not "Admin"?

Please don't top post thanks.
Reply With Quote