![](https://seccdn.libravatar.org/avatar/d51df9dcd1fdfb27a1d4565ba24f90ef.jpg?s=120&d=mm&r=g)
At 03:00 PM 7/7/05, John N. Alegre wrote:
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.