I have a remote server that needs to access my mysql database a lot. So I figured instead of sending a bunch of remote mysql commands it would be more effecient to sync the database to the remote server. Is there a program that easily does this and that I can configure to only sync specified tables and possibly columns?
Asked
Active
Viewed 2,570 times
1 Answers
6
Mysql offers replication, which should do the trick.
Sven
- 97,248
- 13
- 177
- 225
-
Is there a nice frontend for configuring it? – Will Mar 23 '11 at 11:19
-
3yes - vi is very nice and runs on nearly every operating system (you didn't say which you are using) – symcbean Mar 23 '11 at 13:48