Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL database replication

Status
Not open for further replies.
enventuri

enventuri

Programmer
Feb 4, 2003
1
IT
Hello colleagues,
I want to replicate a MySQL database from an active machien to a standby one; I don't like to use the incremental replication ; I'd like to remote copy all the relevant database files, but I knew that the database must be closed (MySQL processes not active) to avoid inconsistencies; is it true? How can I do to freeze the DB files and to replicate them?
regards
Enrico
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
225
EdZzy
E
soushi01
  • Locked
  • Question
MySQL replication slave server re-sync issue
Replies
0
Views
233
soushi01
soushi01
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
441
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
399
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
332
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top