CTED]>
Cc: "Eugénio Veiga" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 02:00
Subject: Re: Importing a complete database
Cal Evans wrote:
> If both are using mySql, just use mysqldump to dump to a file and then
> import it fro
Cal Evans wrote:
> If both are using mySql, just use mysqldump to dump to a file and then
> import it from the file.
>
> It might be fun, just for grins and giggles to:
> mysqldump mysql newDatabaseName
That should be:
mysqladmin create newDatabaseName
mysqldump --opt databasename | mysql ne
If both are using mySql, just use mysqldump to dump to a file and then
import it from the file.
It might be fun, just for grins and giggles to:
mysqldump mysql newDatabaseName
and see if that works.
Obligatory warning: if you do this and it trashes your server and wrecks
your car, I was just ki
mysqldump databasename | gzip > databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
> Hi
>
> Is it possible to import a complete database from a server to another
> one?
>
> Thanks
>
> Eugénio
--
