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
Last revision Both sides next revision
public:module:mariadb_database:overview [2021/02/01 18:25]
ronnie.chan
public:module:mariadb_database:overview [2021/02/02 15:25]
ronnie.chan
Line 19: Line 19:
 ===== Mysqldump Parameters ===== ===== Mysqldump Parameters =====
  
-Here is the mysqldump parameter list used for generating the spooled dump file:+Here is the mysqldump parameter list used for generating the spooled dump file: \\
 --databases \\ --databases \\
 --password \\ --password \\
Line 30: Line 30:
 --allow-keywords \\ --allow-keywords \\
 --triggersv --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}} |
 +
 +==== 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