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
database:mysql [2019/04/02 17:53] – [Backup] tmadedatabase:mysql [2019/06/06 14:41] (current) – [Restore] 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 101: Line 101:
 ==== Restore ==== ==== Restore ====
  
-Ceate a file with following content and make it executable (chmod +x import_db.sh)+Create a file with following content and make it executable (chmod +x import_db.sh)
  
 <code> <code>
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