MySql Help

[sithija.h]

මට පොඩි උදව්වක් ඕන එලකිරි එකේ ඉන්න යාලුවොන්ගෙන්,

මට ඕන වෙලා තියෙනවා Remote Host වෙන MySql Database කිහිපයකම Daily Backup එකක් ගන්න,
ඒහ් කිව්වෙ හැමදාම නියමිත වෙලාවකට අර Remote Host වෙන හැම ඩේටාබේස් එකක්ම Auto මගේ PC එකට බැකප් වෙන්න හදන්න ඕන,

මේක කරන්න මොනව හරි හොඳ සොෆ්ට්වෙයාර් කෑල්ලක් හොයල දෙන්නකො බං,
ලොකු උදව්වක්,

මම නෙට් එකේ හෙව්වා සෙට් වෙන එකක් හොයාගන්න බැරි වුණා,

උදව් කරන හැමෝටම 12++ සළකන්නම්.

එල!

 

[BLACKLIST_MEMBER]

IDM eke sync queue eka use karanna puluwan

FTP Link eka add karala thiyanna QUEUE ekata, Link ehema add nokara onenam IDM site grabber ekenuth puluwan.

Server eke mysqldump eka wadinna cron ekata daala thiyapan. daala ee dump eka IDM eken hamadama download wenna hadaganin

 

[Profile_01]

up......

 

[thilina91]

Scheduled script ekak run karapanko remote pc eke folder ekaka thiyana fbackup eka ape pc ekata copy wenna.

 

[sithija.h]

IDM eke sync queue eka use karanna puluwan

FTP Link eka add karala thiyanna QUEUE ekata, Link ehema add nokara onenam IDM site grabber ekenuth puluwan.

Server eke mysqldump eka wadinna cron ekata daala thiyapan. daala ee dump eka IDM eken hamadama download wenna hadaganin

Sirawatama unba oka kiyanakal mata mathak une na neh bn
Niyama idea eka, meita wada direct backup ganna method ekak nadda bn?
mehema karannath puluwan awlak na habai ekama awla FTP ekakuth hadanna wenawa neh bn,

Rep labuna gaman salakannam bn

thanks bn reply ekata,

up......

ela,
rep labuna gaman salakannam

 

[sithija.h]

Scheduled script ekak run karapanko remote pc eke folder ekaka thiyana fbackup eka ape pc ekata copy wenna.

Ow ekath honda idea ekak bn,
mehemai bn MySQL Workbench eke option ekak thiyanawa DB ekata log wela backup karanna, but eke schedule backup ganna kisima option ekak na,
anna eh wage clearly backup wena software ekak thiye nam thawa hondai,

mokada mata ona computer 12ka withara thiyana MySQL database daily backup ganna mage PC ekata bn,
wade practically easy wennath ona

Tnx bn reply ekata

rep labuna gaman salakannam bn

 

[BLACKLIST_MEMBER]

Sirawatama unba oka kiyanakal mata mathak une na neh bn
Niyama idea eka, meita wada direct backup ganna method ekak nadda bn?
mehema karannath puluwan awlak na habai ekama awla FTP ekakuth hadanna wenawa neh bn,

Rep labuna gaman salakannam bn

thanks bn reply ekata,


ela,
rep labuna gaman salakannam

ehemanam cron 2k gahapan.
palaweni cron eka dump eka wadila gzip wenna, file eka public_html folder eke uba witharak danna folder ekakai namakin gahapan.

ehemamath naththan http basic authentication (https://en.wikipedia.org/wiki/Basic_access_authentication)
use karala ee folder eka protect karapan.

eetapasse IDM eka schedule karapan dump eka wadinna welaawa arala download wenna.

eetapasse aapahu payakata withara passe or e process eka complete wenna kaale arala eelanga cron ekedi server eke backup folder eka clean wenna gahapan (security purpose)


IDM ekata username password deela sync karapan folder eka.

ethakota FTP daanna one naha.

 

[thilina91]

Ow ekath honda idea ekak bn,
mehemai bn MySQL Workbench eke option ekak thiyanawa DB ekata log wela backup karanna, but eke schedule backup ganna kisima option ekak na,
anna eh wage clearly backup wena software ekak thiye nam thawa hondai,

mokada mata ona computer 12ka withara thiyana MySQL database daily backup ganna mage PC ekata bn,
wade practically easy wennath ona

Tnx bn reply ekata

rep labuna gaman salakannam bn

Ubata one de implement karanna nam widi godak athi.
Ekama network eke thiyanawa nam patta lesii. Shared folders + scheduled task + script walin puluwan.
Naththan ube pc eke FTP server ekak run karala iwara ara db thiyana pc wala indan ftp walin ube ekata transfer karanna puluwan. No point in running 12 ftp servers.

 

[sithija.h]

ehemanam cron 2k gahapan.
palaweni cron eka dump eka wadila gzip wenna, file eka public_html folder eke uba witharak danna folder ekakai namakin gahapan.

ehemamath naththan http basic authentication (https://en.wikipedia.org/wiki/Basic_access_authentication)
use karala ee folder eka protect karapan.

eetapasse IDM eka schedule karapan dump eka wadinna welaawa arala download wenna.

eetapasse aapahu payakata withara passe or e process eka complete wenna kaale arala eelanga cron ekedi server eke backup folder eka clean wenna gahapan (security purpose)


IDM ekata username password deela sync karapan folder eka.

ethakota FTP daanna one naha.

ow bn eh method ekath hariyatama hari
sira bn unba loku udawwak kale

thanks bn

 

[KingCM]

bu,pm

 

[sithija.h]

Ubata one de implement karanna nam widi godak athi.
Ekama network eke thiyanawa nam patta lesii. Shared folders + scheduled task + script walin puluwan.
Naththan ube pc eke FTP server ekak run karala iwara ara db thiyana pc wala indan ftp walin ube ekata transfer karanna puluwan. No point in running 12 ftp servers.

Ela bn thanks
mama meh sathiye wade try karanawa bn
result eka unbalatath kiyannamko

 

[BLACKLIST_MEMBER]

Ow ekath honda idea ekak bn,
mehemai bn MySQL Workbench eke option ekak thiyanawa DB ekata log wela backup karanna, but eke schedule backup ganna kisima option ekak na,
anna eh wage clearly backup wena software ekak thiye nam thawa hondai,

mokada mata ona computer 12ka withara thiyana MySQL database daily backup ganna mage PC ekata bn,
wade practically easy wennath ona

Tnx bn reply ekata

rep labuna gaman salakannam bn

Puppet walin karanna puluwan puppet agents oya computers 12 ma run karala
main eka machine ekaka puppet master run karala main machine ekata dumps tika araganna. habai ekata puppet language eka danaganna ona. nattan liyapu manifests download karala test karanakota kela unoth debug karaganna therenne nane.

Lan ekaka nam ehema karana eka prashnayak naha,
mysql software eka ube machine eke indan thiyaagena dump gahanakota data godak transfer wenawa db lokui nam. compress karala adinna
podi ewanan aulak na.
eth SQL files transfer karanakota corrupt wenawa. eka hash calculate karala ganna script ekak liyana eka thamai hondama de.
md5sum file ekakuth calculate wenna script eka liyanna.
eetapasse IDM eken download complete unaama hash verify karana tool eka run wenna daana.

Edit: local mysqldumper run karaddi remote machine okkogema mysql port eka open karala thiyanna wenawa.

ehenam hariyata firewall config karala thiyanna ona. nattan exploit awama hack karanawane

 

[thilina91]

Ela bn thanks
mama meh sathiye wade try karanawa bn
result eka unbalatath kiyannamko

Meka try karala balapan. Man hithanne lesii.

https://stackoverflow.com/questions...-machine-from-remote-server-connected-via-ssh

 

[kavindagk]

Me Article 2kin 1k balanne

https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication

https://tecadmin.net/how-to-set-up-mysql-master-master-replication/

 

[sithija.h]

Puppet walin karanna puluwan puppet agents oya computers 12 ma run karala
main eka machine ekaka puppet master run karala main machine ekata dumps tika araganna. habai ekata puppet language eka danaganna ona. nattan liyapu manifests download karala test karanakota kela unoth debug karaganna therenne nane.

Lan ekaka nam ehema karana eka prashnayak naha,
mysql software eka ube machine eke indan thiyaagena dump gahanakota data godak transfer wenawa db lokui nam. compress karala adinna
podi ewanan aulak na.
eth SQL files transfer karanakota corrupt wenawa. eka hash calculate karala ganna script ekak liyana eka thamai hondama de.
md5sum file ekakuth calculate wenna script eka liyanna.
eetapasse IDM eken download complete unaama hash verify karana tool eka run wenna daana.

Edit: local mysqldumper run karaddi remote machine okkogema mysql port eka open karala thiyanna wenawa.

ehenam hariyata firewall config karala thiyanna ona. nattan exploit awama hack karanawane

meka karana widiya nam danne na bn, eth poddak try karala balannam, oya machine 12ma MySQL Port open karala thiyenne bn,
Tnx bn help ekata, rep labuna gaman salaknnam
ela

Meka try karala balapan. Man hithanne lesii.

https://stackoverflow.com/questions...-machine-from-remote-server-connected-via-ssh

Ela bn, mama try karala result eka kiyannamko,

Me Article 2kin 1k balanne

https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication

https://tecadmin.net/how-to-set-up-mysql-master-master-replication/

oka mama dawasak try kala bn but prashnekata thiyenne backup karana machine ekath 24hours on karala thiyanna wenawa oya wade karanna nam, mokada database eka replicate wenawa neh, anith PC eka offline nam wade awl yanawa neda bn oya method eka use kaloth?
Tnx bn reply ekata rep labuna gaman salakannam

 

[charith84]

මමනම් කරන්නෙහ් කුකුලොහ් ක්රොන් දාලා බැකප් කරලා ජිඩ්‍රයිව් ඖටො බැකප් කරනහ් එකහ්
ක්රොන් එකෙන් බැශ් ස්‍රිප්ට් එකහ් කොල් කරනවා
ඩම්ප් එකයි ගුගල් ඩ්‍රයිව් අප් වෙනහ් එකයි කරන්නෙහ් බැශ් එකෙන්
ගුගල් ඩ්‍රයිව් එකහ් පිසි එකෙහ් ඉන්ස්ටොල් කරලා තියෙන්නෙහ්
අප් වෙච්ච ගමන් සින්ක් වෙනවාහ්

 

[whiteskull]

up up

 

[sithija.h]

මමනම් කරන්නෙහ් කුකුලොහ් ක්රොන් දාලා බැකප් කරලා ජිඩ්‍රයිව් ඖටො බැකප් කරනහ් එකහ්
ක්රොන් එකෙන් බැශ් ස්‍රිප්ට් එකහ් කොල් කරනවා
ඩම්ප් එකයි ගුගල් ඩ්‍රයිව් අප් වෙනහ් එකයි කරන්නෙහ් බැශ් එකෙන්
ගුගල් ඩ්‍රයිව් එකහ් පිසි එකෙහ් ඉන්ස්ටොල් කරලා තියෙන්නෙහ්
අප් වෙච්ච ගමන් සින්ක් වෙනවාහ්

Eka karana widiya hariyatama unbata kiyanna puluwanda bn?

Thanks bn help ekata
rep labuna gaman dennam bn

ela

 

[sithija.h]

Bp

Tnx mcn

 

[ja2k17ja]

DB servers වල use කරන්නෙ Linux ද? Host servers ටික තියෙන්නෙ මොන Data Center එකේද? DB size එක GB වලින් කියාද? ඔයාගෙ PC එකේ තියෙන්නෙත් Linux ද ?