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