Mailinglist Archive: opensuse (2700 mails)
| < Previous | Next > |
Re: [SLE] Moving MySQL, Backing up MySQL ??
- From: Kevin Donnelly <kevin@xxxxxxxxxx>
- Date: Thu, 7 Jul 2005 20:20:46 +0100
- Message-id: <200507072020.46381.kevin@xxxxxxxxxx>
On Thursday 07 Jul 2005 20:00, John N. Alegre wrote:
> 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.
/var/lib/mysql
You need to be root or mysql to access these.
> 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)?
In a console:
mysqldump -uusername -p db > saved_db
and enter the password for username (usually root). This will give a text
file. Transfer that to the target PC, and run:
mysqladmin -uusername -p create "newdb"
to create the database, and then:
mysql -uusername -p newdb < saved_db
to populate it with your transferred data.
--
Pob hwyl / Best wishes
Kevin Donnelly
> 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.
/var/lib/mysql
You need to be root or mysql to access these.
> 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)?
In a console:
mysqldump -uusername -p db > saved_db
and enter the password for username (usually root). This will give a text
file. Transfer that to the target PC, and run:
mysqladmin -uusername -p create "newdb"
to create the database, and then:
mysql -uusername -p newdb < saved_db
to populate it with your transferred data.
--
Pob hwyl / Best wishes
Kevin Donnelly
| < Previous | Next > |