User Tools

Site Tools


public:module:mariadb_database:overview

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
public:module:mariadb_database:overview [2021/02/01 18:24]
ronnie.chan
public:module:mariadb_database:overview [2021/02/02 15:25] (current)
ronnie.chan
Line 18: Line 18:
  
 ===== Mysqldump Parameters ===== ===== Mysqldump Parameters =====
 +
 +Here is the mysqldump parameter list used for generating the spooled dump file: \\
 +--databases \\
 +--password \\
 +--result-file \\
 +--port \\
 +--user \\
 +--host \\
 +--opt \\
 +--quote-names \\
 +--allow-keywords \\
 +--triggersv
 +
 +Example: \\
 +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
 +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?​950}} |
 +
 +==== Process A). ====
 +
 +| {{public:​module:​mariadb_database:​image077.png?​950}} |
 +
 +==== Process B). ====
 +
 +| {{public:​module:​mariadb_database:​image079.png?​950}} |
 +
 +==== Process C). ====
 +
 +| {{public:​module:​mariadb_database:​image081.png?​950}} |
 +
 +
  
public/module/mariadb_database/overview.1612175060.txt.gz · Last modified: 2021/02/01 18:24 by ronnie.chan