delete all database and restore

I got an old mysql server with outdated databases

I want to delete all the databases and import a new set from a dump file.


I have like ten databases currently on there. What do i do to import my
current data on this server?

I basically want to replace all the databases from one dump file I have. How
do I restore the databases from one dump file?
"nobody" <nobody@nobody.com> wrote in message
news:fgtkig$i7a$2@news.Stanford.EDU...
>I got an old mysql server with outdated databases
>
> I want to delete all the databases and import a new set from a dump file.
>
>
> I have like ten databases currently on there. What do i do to import my
> current data on this server?
>

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

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.

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

>
> Didja look at line 24?
>
> Are you sure you have a database called "admin" and not "Admin"?
>
> Please don't top post thanks.

Yes there is a database called admin.

I am doing a restore from a mysql 5.x to a mysql 3.x server.

is that a problem?

"nobody" <nobody@nobody.com> wrote in news:fh26pb$db5$2@news.Stanford.EDU:

>>
>> Didja look at line 24?
>>
>> Are you sure you have a database called "admin" and not "Admin"?
>>
>> Please don't top post thanks.
>
> Yes there is a database called admin.
>
> I am doing a restore from a mysql 5.x to a mysql 3.x server.
>
> is that a problem?

why are you going backwards? 3.x is practically ancient.