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:15] ronnie.chan |
public:module:mariadb_database:restore [2021/02/02 15:21] ronnie.chan |
||
---|---|---|---|
Line 170: | Line 170: | ||
| {{public:module:mariadb_database:image142.png?800}} | | | {{public:module:mariadb_database:image142.png?800}} | | ||
- | |||
- | <WRAP indent> | ||
- | 9. Recovering MariaDB Databases ==== | + | |
+ | 9. Recovering MariaDB Databases | ||
+ | |||
+ | <WRAP indent> | ||
9.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. | ||
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. |