How to use Backup database (mysqldump) in recovery environment?

Heya, @3a956ebeda09409f879334ecda13c0

What you can try is to copy the /var/lib/mysql data to your local machine instead of trying to install ‘mysql’ during recovery.

1. Identify the disk that contains your data:

lsblk

You should see something like:

vda     250G ├─vda1  250G  /

• If your data is on vda1, mount it:

mkdir /mnt/recovery mount /dev/vda1 /mnt/recovery

1. Navigate to the MySQL data directory:

ls /mnt/recovery/var/lib/mysql

You should see folders corresponding to your databases.

1. Create a backup folder in your recovery disk:

mkdir -p /mnt/recovery/root/mysql-backup

2. Copy the raw MySQL database files:

cp -r /mnt/recovery/var/lib/mysql /mnt/recovery/root/mysql-backup/

Now, you need to download the database backup before reinstalling the Droplet.

1. Enable SSH in Recovery Mode

• Set a password for root:

passwd root

• Start the SSH service:

service ssh start

• Get your Recovery Mode IP Address:

ip a

2. Download the Backup via SCP from your local machine:

scp -r root@<RECOVERY_IP>:/mnt/recovery/root/mysql-backup/ .

Once you have backed up your MySQL data, rebuild your Droplet and restore the database.

Hope that this helps!