SEO

#1 (**permalink**) 02-28-2008, 10:29 AM

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?

#2 (**permalink**) 02-28-2008, 10:29 AM

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

#3 (**permalink**) 02-28-2008, 10:29 AM

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

#4 (**permalink**) 02-28-2008, 10:29 AM

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.

#5 (**permalink**) 02-28-2008, 10:29 AM

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

#6 (**permalink**) 02-28-2008, 10:29 AM

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

#7 (**permalink**) 02-28-2008, 10:29 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

delete all database and restore