Mailinglist Archive: opensuse (2700 mails)
| < Previous | Next > |
Re: [SLE] Moving MySQL, Backing up MySQL ??
- From: Frank Bax <fbax@xxxxxxxxxxxx>
- Date: Thu, 07 Jul 2005 15:19:22 -0400
- Message-id: <5.2.1.1.0.20050707151203.056a04a0@xxxxxxxxxxxxxxxxx>
At 03:00 PM 7/7/05, John N. Alegre wrote:
You don't want to copy the MySQL files directly (so it doesn't matter where they are).
http://dev.mysql.com/doc/mysql/en/backup.html
Use "mysqldump" to dump contents of database into a text file. gzip the file, send it to your redhat system. The file contains SQL statements to populate your databse, so simply pipe it into "mysql" command. That was so easy! You might find the --add-drop-table option of mysqldump useful if you repeat the process.
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)?
You don't want to copy the MySQL files directly (so it doesn't matter where they are).
http://dev.mysql.com/doc/mysql/en/backup.html
Use "mysqldump" to dump contents of database into a text file. gzip the file, send it to your redhat system. The file contains SQL statements to populate your databse, so simply pipe it into "mysql" command. That was so easy! You might find the --add-drop-table option of mysqldump useful if you repeat the process.
| < Previous | Next > |