I’ve been a long time Mac hater. Recently, though, I broke down and bought a Mac laptop.<\/p>\n
Being a geek on many levels, I immediately had to set it up as a development server environment. I won’t go into the full story, but suffice it to say, that after dabbling with MAMP, I decided to go back to the discrete installs. I mean, most of it is done already, anyway, and then you don’t have to deal with paying for MAMP Pro to get around starting your server on port 80. If you know what I mean, then I’ll assume you’ve been there.<\/p>\n
Although I originally wanted to put the database itself under revision control, talking to the guys in the IT department (and my boss), and doing research on the internet, I decided to go with something like How to Sync A Local & Remote WordPress Blog Using Version Control<\/a>.<\/p>\n Okay, the general layout:<\/p>\n The concept in a nutshell:<\/p>\n This post assumes you have access and control of your systems, such that you can write, execute, and read where necessary. I will gloss over that stuff, if I touch it at all. Also, this is not a secure method. Use at your own risk.<\/strong> There are ways to get around the password in plain text issue, but that (among other things) is beyond the scope of this post.<\/p>\n PC script: Let’s dissect this: I saved the script in the dbExchange folder as export.bat (which makes it executable). I then sent a link to the desktop. That’s all there is to the PC script.<\/p>\n Mac script: Dissection reveals: I saved the script in the dbExchange folder as import.command (which makes it executable). I then made an alias to the command file and copied it to the desktop. That’s all there is to the Mac script.<\/p>\n Use:<\/strong> Double-click on the Windows desktop shortcut. Go to your Mac and make sure you are connected via network to the folder where the SQL file was dumped. Double-click on the alias file on the Mac desktop. It’s done! Note: The different processes, Git, mysqldump, mysql, may take time to finish. How much can vary and depends on database size, your computers, network speed, etc. Either way, be patient, it’ll be over before you know it!<\/p>\n =)<\/p>\n","protected":false},"excerpt":{"rendered":" I’ve been a long time Mac hater. Recently, though, I broke down and bought a Mac laptop. Being a geek on many levels, I immediately had to set it up as a development server environment. I won’t go into the … Continue reading \n
\n
\n
\nmysqldump -u USER -pPASSWORD DBNAME > \"C:\\Program Files (x86)\\Apache Software Foundation\\Apache2.2\\htdocs\\dBExchange\\DBNAME.sql\"
\n\"C:\\Program Files (x86)\\Git\\cmd\\git\" add \"C:\\Program Files (x86)\\Apache Software Foundation\\Apache2.2\\htdocs\\dBExchange\\DBNAME.sql\"
\ngit commit \"C:\\Program Files (x86)\\Apache Software Foundation\\Apache2.2\\htdocs\\dBExchange\\DBNAME.sql\" -m \"auto commit\"
\n<\/code><\/p>\n
\nmysqldump -u USER -pPASSWORD DBNAME > \"C:\\Program Files (x86)\\Apache Software Foundation\\Apache2.2\\htdocs\\dBExchange\\DBNAME.sql\"<\/code><\/p>\n\n
\"C:\\Program Files (x86)\\Git\\cmd\\git\" add \"C:\\Program Files (x86)\\Apache Software Foundation\\Apache2.2\\htdocs\\dBExchange\\DBNAME.sql\"<\/code><\/p>\n\n
git commit \"C:\\Program Files (x86)\\Apache Software Foundation\\Apache2.2\\htdocs\\dBExchange\\DBNAME.sql\" -m \"auto commit\"<\/code><\/p>\n\n
\n
\n#!\/bin\/bash
\ncd \/Library\/WebServer\/Documents\/dBExchange
\ngit pull origin
\nmysql -u USER -pPASSWORD DBNAME < \/Library\/WebServer\/Documents\/dBExchange\/DBNAME.sql
\n<\/code><\/p>\n
\n#!\/bin\/bash<\/code><\/p>\n\n
cd \/Library\/WebServer\/Documents\/dBExchange<\/code><\/p>\n\n
git pull origin<\/code><\/p>\n\n
mysql -u USER -pPASSWORD DBNAME < \/Library\/WebServer\/Documents\/dBExchange\/DBNAME.sql<\/code><\/p>\n\n