Difference between revisions of "Talk:UpgradeDisk"
| Line 20: | Line 20: | ||
Restart the mysqld service: | Restart the mysqld service: | ||
service mysqld start | service mysqld start | ||
| + | ---- | ||
| + | Looks like you are trying to recover your mysql database in the situation that you were not able to run pre-backup. Perhaps you would like to add a section within this wiki identifying the situation in which this is relevant. It obviously should not be the general case for this procedure; only if you are in a recovery situation where pre-backup is not option. --[[User:Christian|Christian]] 15:01, 25 December 2008 (UTC) | ||
Revision as of 16:01, 25 December 2008
This HOWTO really saved me. The only notes I have to add is concerning the mysql db's.
The mysql db's are kept in: /var/lib/mysql
Stop the mysql service:
service mysqld stop
Change directories to the old mysql:
cd /mnt/old/var/lib/
Copy the mysql db's to the new install:
cp -R ./mysql /var/lib/
Change directories to the new mysql:
cd /var/lib/
Change the ownership on the new install mysql directory:
chown -R mysql:mysql ./mysql
Restart the mysqld service:
service mysqld start
Looks like you are trying to recover your mysql database in the situation that you were not able to run pre-backup. Perhaps you would like to add a section within this wiki identifying the situation in which this is relevant. It obviously should not be the general case for this procedure; only if you are in a recovery situation where pre-backup is not option. --Christian 15:01, 25 December 2008 (UTC)
