|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
I recently suffered a hardware failure* but fortunately* I run nightly backups* so was able to restore. Unfortunately* I lost a couple of hundred messages. The server I'm running is Windows 2008 R2* MySQL 5.1.39. I'm in the process of building a second box* so if I have another issue* I can just point to it. My question is how can I keep the two databases in sync? I'm sure that MySQL has a method of replication* and before i dig into that* I wanted to get in touch with those who might have done it. Additionally* I have access to SQLyog* nad was messing around with that* it has a synchronization tool* but when I try to utilize that* I get "Server is not allowed to connect to this MySQL server." error. My questions. 1) How do you maintain close to realtime backup of your databases? 2) How can I get around the SQLyog error? I'm sure it's a setting somewhere* but I'll be darned if I can find it. I'm trying to allow 192.168.1.20 to access 192.168.1.25. Thanks for any guidance! __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum question bout database backups | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-14-2010 04:40 AM |
Managing database backups | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 11-15-2009 11:10 PM |
database backups etc | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 08-11-2009 04:20 AM |
Transfering database backups to another hosting account automatically | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-01-2009 01:40 AM |
Uploading Database Backups via Shell | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-10-2009 04:30 PM |