On 15/8/2016 (happy birthday!), we are trying to put the FS standabye servers in production as a test.
Linux Mysql DB
Get the mysql databases of the Linux server from the replica ({{backup3.bluelightav.org}} (around 5 minutes):
| Code Block |
|---|
root@backup3.bluelightav:~# mysqldump --defaults-file=/root/.my.cnf.d/mysqld2.cnf --all-databases | gzip > /tmp/fs.2016.0908.15.sql.gzip -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. |
...
| Code Block |
|---|
phil@phil-mbp:~$ scp root@backup3.bluelightav.org:/tmp/fs.2016.0908.15.sql.gzip /Volumes/MULTISYSTEM/tmp |
On the spare Linux server, get the dump file (from the USB stick). Adapt accordingly, eg the device name.
| Code Block |
|---|
# Mount the USB drive
mkdir -p /mnt/usb ; mount /dev/sdb1 /mnt/usb
# Copy the file in the filesystem
cp /mnt/usb/tmp/fs.2016.08.15.sql.gzip /tmp
# Unzip it
cd /tmp
gunzip fs.2016.08.15.sql.gzip
# Import
mysql < fs.2016.08.15.sql |