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