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
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.
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
Op donderdag 7 juli 2005 21:00, schreef John N. Alegre:
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)?
http://susewiki.org/index.php?title=SUSE_FAQ#Howto_transfer_mysql_data_to_an... -- Richard Bos Without a home the journey is endless
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
participants (5)
-
Aldrik KLEBER
-
Frank Bax
-
John N. Alegre
-
Kevin Donnelly
-
Richard Bos