public:module:mariadb_database:restore
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:module:mariadb_database:restore [2021/02/02 15:09] ronnie.chan |
public:module:mariadb_database:restore [2021/02/02 15:21] (current) ronnie.chan |
||
|---|---|---|---|
| Line 143: | Line 143: | ||
| 2. Select the backup set that you would like to restore the MariaDB Database from. | 2. Select the backup set that you would like to restore the MariaDB Database from. | ||
| - | | {{public:module:mariadb_database:image146.png?800}} | | + | | {{public:module:mariadb_database:image132.png?800}} | |
| 3. Select the storage destination that contains the MariaDB databases that you would like to restore from. | 3. Select the storage destination that contains the MariaDB databases that you would like to restore from. | ||
| - | | {{public:module:mariadb_database:image148.png?800}} | | + | | {{public:module:mariadb_database:image122.png?800}} | |
| 4. Select to restore the MariaDB database(s) from a specific backup job then select the files or folders that you would like to restore and select the **Restore raw file** option. Click **Next** to proceed. | 4. Select to restore the MariaDB database(s) from a specific backup job then select the files or folders that you would like to restore and select the **Restore raw file** option. Click **Next** to proceed. | ||
| - | | {{public:module:mariadb_database:image150.png?800}} | | + | | {{public:module:mariadb_database:image134.png?800}} | |
| 5. Select the location on the local machine you wish to restore the MariaDB database files to. Click **Next** to proceed. | 5. Select the location on the local machine you wish to restore the MariaDB database files to. Click **Next** to proceed. | ||
| - | | {{public:module:mariadb_database:image152.png?800}} | | + | | {{public:module:mariadb_database:image136.png?800}} | |
| 6. Confirm the temporary directory path is correct and then click **Restore** to proceed. | 6. Confirm the temporary directory path is correct and then click **Restore** to proceed. | ||
| - | | {{public:module:mariadb_database:image130.png?800}} | | + | | {{public:module:mariadb_database:image138.png?800}} | |
| 7. After the MariaDB database(s) has been restored. | 7. After the MariaDB database(s) has been restored. | ||
| - | | {{public:module:mariadb_database:image132.png?800}} | | + | | {{public:module:mariadb_database:image140.png?800}} | |
| 8. Check the location on the local machine to verify the MariaDB database files have been restored. | 8. Check the location on the local machine to verify the MariaDB database files have been restored. | ||
| Line 169: | Line 169: | ||
| Example: Using Windows File Explorer | Example: Using Windows File Explorer | ||
| - | | {{public:module:mariadb_database:image144.png?800}} | | + | | {{public:module:mariadb_database:image142.png?800}} | |
| - | + | ||
| - | <WRAP indent> | + | |
| - | ==== 2.1). Recovering MariaDB Databases ==== | + | 9. Recovering MariaDB Databases |
| + | |||
| + | <WRAP indent> | ||
| - | 2.1.1. Login to MariaDB Server using MariaDB Command Line Client and verify the database instance is running. | + | 9.1. Login to MariaDB Server using MariaDB Command Line Client and verify the database instance is running. |
| <code> | <code> | ||
| Enter password: ****** | Enter password: ****** | ||
| Line 199: | Line 200: | ||
| </code> | </code> | ||
| - | 2.1.2. Create the database names that need to be recovered. | + | 9.2. Create the database names that need to be recovered. |
| Example: chinook, nation, and sportdb. | Example: chinook, nation, and sportdb. | ||
| Line 214: | Line 215: | ||
| </code> | </code> | ||
| - | 2.1.3. Recover Databases | + | 9.3. Recover Databases |
| Repeat the following steps for all databases you wish to restore. | Repeat the following steps for all databases you wish to restore. | ||
| Line 245: | Line 246: | ||
| </code> | </code> | ||
| - | 4. Check the database status | + | 9.4. Check the database status |
| Example: Listing the tables in the database using **show tables** | Example: Listing the tables in the database using **show tables** | ||
| Line 559: | Line 560: | ||
| ===== 3). Automatic MariaDB Database Restore (Alternative Location) ===== | ===== 3). Automatic MariaDB Database Restore (Alternative Location) ===== | ||
| + | ---- | ||
| 1. Login to MariaDB Server using MariaDB Command Line Client and verify the database instance is running. | 1. Login to MariaDB Server using MariaDB Command Line Client and verify the database instance is running. | ||
| Line 594: | Line 596: | ||
| 2. In the CloudBacko Pro's main interface, click the Restore icon. | 2. In the CloudBacko Pro's main interface, click the Restore icon. | ||
| - | {{public:module:mariadb_database:image118.png}} | + | | {{public:module:mariadb_database:image118.png}} | |
| 3. Select the backup set that you would like to restore the MariaDB Database from. | 3. Select the backup set that you would like to restore the MariaDB Database from. | ||
| - | {{public:module:mariadb_database:image146.png?800}} | + | | {{public:module:mariadb_database:image146.png?800}} | |
| 4. Select the storage destination that contains the MariaDB databases that you would like to restore from. | 4. Select the storage destination that contains the MariaDB databases that you would like to restore from. | ||
| - | {{public:module:mariadb_database:image148.png?800}} | + | | {{public:module:mariadb_database:image148.png?800}} | |
| 5. Select to restore the MariaDB node from a specific backup job then select the files or folders that you would like to restore. Click **Next** to proceed. | 5. Select to restore the MariaDB node from a specific backup job then select the files or folders that you would like to restore. Click **Next** to proceed. | ||
| - | {{public:module:mariadb_database:image148.png?800}} | + | | {{public:module:mariadb_database:image150.png?800}} | |
| <WRAP info> | <WRAP info> | ||
| Line 614: | Line 616: | ||
| 6. Select to restore the MariaDB Databases to the alternate location and click **Next** to proceed. | 6. Select to restore the MariaDB Databases to the alternate location and click **Next** to proceed. | ||
| - | {{public:module:mariadb_database:image150.png?800}} | + | | {{public:module:mariadb_database:image152.png?800}} | |
| 7. Confirm the MariaDB database details such as Database name, Host, Port, Username, and Password. | 7. Confirm the MariaDB database details such as Database name, Host, Port, Username, and Password. | ||
| Line 620: | Line 622: | ||
| Example: To restore and clone a copy of the **chinook** database on the original server with new name **chinook_clone**. | Example: To restore and clone a copy of the **chinook** database on the original server with new name **chinook_clone**. | ||
| - | {{public:module:mariadb_database:image152.png?800}} | + | | {{public:module:mariadb_database:image154.png?800}} | |
| 8. Confirm the temporary directory path is correct and then click **Restore** to proceed. | 8. Confirm the temporary directory path is correct and then click **Restore** to proceed. | ||
| - | {{public:module:mariadb_database:image154.png?800}} | + | | {{public:module:mariadb_database:image156.png?800}} | |
| 9. After the MariaDB database(s) has been restored. | 9. After the MariaDB database(s) has been restored. | ||
| - | {{public:module:mariadb_database:image156.png?800}} | + | | {{public:module:mariadb_database:image140.png?800}} | |
| 10. Using MariaDB Command Line Client, you can list the restored databases and tables. | 10. Using MariaDB Command Line Client, you can list the restored databases and tables. | ||
public/module/mariadb_database/restore.1612249781.txt.gz · Last modified: 2021/02/02 15:09 by ronnie.chan
Page Tools
