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 Chriss Miller 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
Joined
Feb 4, 2003
Messages
1
Location
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 Question
MySQL calculator tools
Replies
0
Views
662
EdZzy
E
soushi01
  • Locked
  • Question Question
MySQL replication slave server re-sync issue
Replies
0
Views
440
soushi01
soushi01
lupidol
  • Locked
  • Question Question
Cannot create new table in mySQL
Replies
6
Views
1K
lupidol
lupidol
lupidol
  • Locked
  • Question Question
mysql cannot add rows with "UNION"
Replies
5
Views
982
Chris Miller
Chris Miller
dylim
  • Locked
  • Question Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
831
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top