stephenk/Issue_KD
1
0
Code Issues 15 Packages Projects Wiki

Menambah Replikasi Table Regional Ke Cabang #7

New Issue
Open
opened 2025-12-10 14:17:39 +07:00 by stephenk · 0 comments
stephenk commented 2025-12-10 14:17:39 +07:00
Owner
Copy Link
  1. Table yang dibuat di Regional Di Restore di All Cabang (Create Table dan Isi -isinya)
  2. Buka Terminal (Putty) Cabang
  3. Jalankan sudo su
  4. pergi ke mysql cd /etc/mysql/
  5. edit my.cnf nano my.cnf
  6. Tambahkan bagian replicate-do-table = lalu isi dengan table barunya dari db lokal apa
    contoh:
replicate-do-table = one.nat_normalvalueprefix 
replicate-do-table = one.nat_normalvalueprefixlang
replicate-do-table = one.m_advice_nonlab
replicate-do-table = one.nat_advice_nonlab
replicate-do-table = one.nat_advice_nonlab_detail
replicate-do-table = one.mcu_statusresult
replicate-do-table = one.mcu_statusresult_detail
replicate-do-table = one.mcu_statusresult_value
  1. Save Setelah Edit (ctrl+x , Y, Enter)
  2. Restart mysql dengan sudo systemctl restart mariadb
1. Table yang dibuat di Regional Di Restore di All Cabang (Create Table dan Isi -isinya) 2. Buka Terminal (Putty) Cabang 3. Jalankan ``` sudo su ``` 4. pergi ke mysql ``` cd /etc/mysql/ ``` 5. edit my.cnf ``` nano my.cnf ``` 6. Tambahkan bagian replicate-do-table = lalu isi dengan table barunya dari db lokal apa contoh: ``` replicate-do-table = one.nat_normalvalueprefix replicate-do-table = one.nat_normalvalueprefixlang replicate-do-table = one.m_advice_nonlab replicate-do-table = one.nat_advice_nonlab replicate-do-table = one.nat_advice_nonlab_detail replicate-do-table = one.mcu_statusresult replicate-do-table = one.mcu_statusresult_detail replicate-do-table = one.mcu_statusresult_value ``` 7. Save Setelah Edit (ctrl+x , Y, Enter) 8. Restart mysql dengan ``` sudo systemctl restart mariadb ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
stephenk
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: stephenk/Issue_KD#7
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?