8

Restoring a backup manually in RunCloud is straightforward, but it requires some knowledge of database management. You can directly upload the web app files from the backup file using SFTP. RunCloud uses mysqldumper, which saves each database table as a separate compressed file. This guide will lead you through the process one step at a time.

Step 1: Download the Database Snapshot

Before starting the restoration process, you need to download the backup snapshot.

1. Go to RunCloud > Backups.
2. Locate the backup snapshot you want to restore.
3. Download the snapshot file to your local machine.

Step 2: Upload the Backup File to Your Server

To upload the backup file, you can use an FTP client like FileZilla.

1. Connect to your server using FileZilla.
2. Navigate to the appropriate directory where you want to upload the backup.
3. Upload the downloaded snapshot file to your server.

Step 3: Create a New Database

Once the backup file is uploaded, you need to create a new database before restoring the backup.

1. Log in to your RunCloud panel.
2. Navigate to Server > Databases.
3. Click Add New Database.
4. Provide a database name of your choice and create the database.

Step 4: Extract the Database Backup File

After uploading the backup file, access your server via SSH and extract the contents.

1. Move the uploaded backup to the /tmp directory:
           

             mv <snapshotname>.tar.gz /tmp

        2. Change to the /tmp directory:

            cd /tmp

         3. Extract the backup files:

tar -xzf <snapshotname>.tar.gz

Step 5: Restore the Database Using MyLoader

RunCloud provides mydumper-rc to restore backups efficiently. Use the following command to restore the extracted database files:

/RunCloud/Packages/mydumper-rc/bin/myloader –user root –overwrite-tables –database ‘databasename’ –directory ‘/tmp/database/’

Make sure to replace ‘databasename’ with the actual name of your database.

Conclusion

Manually restoring a RunCloud backup is simple if you follow these steps carefully. By leveraging mydumper-rc, you can efficiently restore your database while ensuring each table is imported correctly. Feel free to reach out for assistance if you encounter any issues during the process.