On Tue, 2005-06-07 at 00:43 +0800, Ronald Wiplinger wrote:
My machine with the database is broken. I need to transfer the data to another machine.
How do I do that? Copy all the files of the data/ to the new machine, but how to be able to access them again?
Before I had host localhost database abc user user1 password secret
now the database in on host db .....
bye
Ronald
Use mysqldump to save one or all databases Use mysqlrestore to restore them. Also check the docs at /usr/share/doc/packages/mysql and also at /usr/share/doc/packages/mysql-administrator But then you knew to look in the .../doc/packages for help didn't you? It is a good first place to look for info. -- Ken Schneider UNIX since 1989, linux since 1994, SuSE since 1998 "The day Microsoft makes something that doesn't suck is probably the day they start making vacuum cleaners." -Ernst Jan Plugge