1,574
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 164:
Line 164: − + − − − − − − − −
Formatting only
{{Warning box| Only use this procedure where pre-backup cannot be run eg in the event of a corrupt filesystem and/or unbootbale server}}
{{Warning box| Only use this procedure where pre-backup cannot be run eg in the event of a corrupt filesystem and/or unbootbale server}}
This addresses the situation where the pre-backup was unable to be run eg a sudden power outage that has caused a corrupt filesystem and unbootable server, it concerns the recovery of your mysql db's . It should not be the general case for the procedure of Upgrading a Disk, only if you are in a recovery situation where pre-backup is not an option.
This addresses the situation where the pre-backup was unable to be run eg a sudden power outage that has caused a corrupt filesystem and unbootable server, it concerns the recovery of your mysql db's . It should not be the general case for the procedure of Upgrading a Disk, only if you are in a recovery situation where pre-backup is not an option. The mysql db's are kept in: /var/lib/mysql.
The mysql db's are kept in: /var/lib/mysql
Stop the mysql service:
Stop the mysql service:
service mysqld stop
service mysqld stop
Change directories to the old mysql:
Change directories to the old mysql:
cd /mnt/old/var/lib/
cd /mnt/old/var/lib/
Copy the mysql db's to the new install:
Copy the mysql db's to the new install:
cp -R ./mysql /var/lib/
cp -R ./mysql /var/lib/
Change directories to the new mysql:
Change directories to the new mysql:
cd /var/lib/
cd /var/lib/
Change the ownership on the new install mysql directory:
Change the ownership on the new install mysql directory:
chown -R mysql:mysql ./mysql
chown -R mysql:mysql ./mysql
Restart the mysqld service:
Restart the mysqld service:
service mysqld start
service mysqld start
----
----
[[Category:Howto]]
[[Category:Howto]]
[[Category:Administration:Storage]]
[[Category:Administration:Storage]]
