How to restore mysql databases from /var/lib/mysql/user_database/ files only?
as the title asks. I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
So how can I get these database files to fully work on a new server? Please any help would be greatly appreciated.
█ Deasoft.com Australia & USA Hosting - cPanel, WHM, VPS
█ Software - WHMreseller - WHMexec - KVZcloud
█ Host Repo - The Linux Web Host Knowledge Repository
█ hostsearch.com.au - Host Search Australia