Stooney Posted February 17, 2009 Share Posted February 17, 2009 I'm looking into syncing a few different computers I develop on with the same development data automatically. Syncing the files themselves isn't a problem (using SugarSync). My question is whether or not there's a file(s) stored in the mysql folder (or anywhere) that actually contains the databases/data that I could sync across multiple computers so that I have the same databases/changes across all computers. I know I could just use mysql dumps, but I'm going for an automatic solution. Quote Link to comment https://forums.phpfreaks.com/topic/145599-where-is-the-database-stored/ Share on other sites More sharing options...
Mchl Posted February 17, 2009 Share Posted February 17, 2009 All contents of /data directory in mysql folder. Servers must not be running. Also have in mind, that it will only work, when all computers have same version of MySQL server and at least some of the options in config file. There also might be problems if there are different operating systems. Alternatively you might try to set up replication. Quote Link to comment https://forums.phpfreaks.com/topic/145599-where-is-the-database-stored/#findComment-764392 Share on other sites More sharing options...
Stooney Posted February 17, 2009 Author Share Posted February 17, 2009 Ty sir. Replication looks like it would be the better way to go, but I am dealing with dynamic IPs. So I'd have to change the address to the master server for each slave when my IP changes. Although I could just put my dev database server on my web host account, in which case it's address wouldn't change. Consider this a conversation with myself. Ty again. Quote Link to comment https://forums.phpfreaks.com/topic/145599-where-is-the-database-stored/#findComment-764406 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.