Mailinglist Archive: opensuse (2700 mails)
| < Previous | Next > |
Re: [SLE] Moving MySQL, Backing up MySQL ??
- From: Aldrik KLEBER <aldrik.kleber@xxxxxxxxxx>
- Date: Fri, 8 Jul 2005 09:44:14 +0200
- Message-id: <200507080944.20857.aldrik.kleber@xxxxxxxxxx>
Le Jeudi 07 Juillet 2005 21:00, John N. Alegre a écrit :
> In ways these are the same question.
>
> I have a standard SuSE Pro 9.1 installation. Where are the database files
> for MySQL? I want to back up only the db and relavent config files not any
> of the MySQL binaries.
>
> Also which files (the db files) do I move to migrate the entire database to
> a MySQL (same version) running under a different Linux distro (Red Hat)?
>
> Thanks in advance
> john
You can use mysqldump utility and mysql command line client
the details of parameters are available on mysql website, but to directly
migrate through network
mysqldump PARAMETERSFOROLDSERVER | mysql PARAMETERSFORDISTANTNEWSERVER
and in one command all is done, this is very fast.
I have done this and it is very fast.
When you dump the server, disable extended inserts
> In ways these are the same question.
>
> I have a standard SuSE Pro 9.1 installation. Where are the database files
> for MySQL? I want to back up only the db and relavent config files not any
> of the MySQL binaries.
>
> Also which files (the db files) do I move to migrate the entire database to
> a MySQL (same version) running under a different Linux distro (Red Hat)?
>
> Thanks in advance
> john
You can use mysqldump utility and mysql command line client
the details of parameters are available on mysql website, but to directly
migrate through network
mysqldump PARAMETERSFOROLDSERVER | mysql PARAMETERSFORDISTANTNEWSERVER
and in one command all is done, this is very fast.
I have done this and it is very fast.
When you dump the server, disable extended inserts
| < Previous | Next > |