public:module:mariadb_database:overview
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
public:module:mariadb_database:overview [2021/02/01 18:26] ronnie.chan |
public:module:mariadb_database:overview [2021/02/02 15:25] ronnie.chan |
||
|---|---|---|---|
| Line 31: | Line 31: | ||
| --triggersv | --triggersv | ||
| - | <strong>Example:</strong> \\ | + | Example: \\ |
| For the spooling of the “nation” database to D:\Temp folder, the following parameters will be used: | For the spooling of the “nation” database to D:\Temp folder, the following parameters will be used: | ||
| Mysqldump --databases nation --user=user1 --password=qwerty --host=localhost --port=3306 --opt --quote-names --allow-keywords --triggers --result-file=D:\Temp\nation.sql | Mysqldump --databases nation --user=user1 --password=qwerty --host=localhost --port=3306 --opt --quote-names --allow-keywords --triggers --result-file=D:\Temp\nation.sql | ||
| For details on mysqldump parameters please refer to https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html | For details on mysqldump parameters please refer to https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html | ||
| + | |||
| + | ===== Backup Process ===== | ||
| + | |||
| + | The following steps are performed during a MariaDB Database backup job. | ||
| + | |||
| + | | {{public:module:mariadb_database:image075.png}} | | ||
| + | |||
| + | ==== Process A). ==== | ||
| + | |||
| + | | {{public:module:mariadb_database:image077.png}} | | ||
| + | |||
| + | ==== Process B). ==== | ||
| + | |||
| + | | {{public:module:mariadb_database:image079.png}} | | ||
| + | |||
| + | ==== Process C). ==== | ||
| + | |||
| + | | {{public:module:mariadb_database:image081.png}} | | ||
| + | |||
public/module/mariadb_database/overview.txt · Last modified: 2021/02/02 15:25 by ronnie.chan
Page Tools
