On Monday 06 Jun 2005 17:43, Ronald Wiplinger wrote:
Copy all the files of the data/ to the new machine, but how to be able to access them again?
If you have access to the old machine, use mysqldump to dump the db. If you don't, install and mount the hard drive in the new machine. Install MySQL on the new machine, and set it up with passwords, etc. Stop the daemon, and move the db file in the old drive's /var/lib/mysql (assuming you didn't change the location from the default) to the new drive's /var/lib/mysql. You will need to be root, and then change the file ownership to mysql: chown mysql.mysql mydbfile Start MySQL again. Access the file via the MySQL console, and adjust db permissions as appropriate. I think this should cover it, unless I've omitted something :-) -- Pob hwyl / Best wishes Kevin Donnelly www.kyfieithu.co.uk - Meddalwedd Rhydd yn Gymraeg www.cymrux.org.uk - Linux Cymraeg ar un CD!