database:mysql
 
Trace:

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
database:mysql [2019/04/02 17:53] – [Backup] tmadedatabase:mysql [2019/06/06 14:41] – tmade
Line 14: Line 14:
  
 ==== Backup ==== ==== Backup ====
-Example backupscript to backup each database as a singe file:+Example backupscript to backup each database as a single file:
 <code> <code>
 #!/bin/bash #!/bin/bash
Line 385: Line 385:
   CHANGE MASTER TO MASTER_HOST="IP-Replication-Master", MASTER_PORT=3306, MASTER_USER="replication", MASTER_PASSWORD="secret", MASTER_AUTO_POSITION=1   CHANGE MASTER TO MASTER_HOST="IP-Replication-Master", MASTER_PORT=3306, MASTER_USER="replication", MASTER_PASSWORD="secret", MASTER_AUTO_POSITION=1
  
-as master and creadentials isn´t know yet.+as master and credentials aren´t know yet. 
 + 
 +See also on: 
 + 
 +https://www.percona.com/blog/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/
  
 Activate/ deactivate "MASTER_AUTO_POSITION": Activate/ deactivate "MASTER_AUTO_POSITION":
database/mysql.txt · Last modified: 2019/06/06 14:41 by tmade
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki