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