Need to restore databases!
The other day I decided to reinstall everything on my server. Not knowing there was an alternative (mysqldump), I started by backing up the entire databases directory (/var/lib/mysql). Now I have that databases directory on a CD, but when I copy all of the files from a database to a new database with root, only the root mysql user has write permissions. How can I give the correct owner read and write access to their database?
|