Changes between Version 9 and Version 10 of faq/setup-development-workstation

Timestamp:

Mar 21, 2008, 2:25:39 PM (17 years ago)

Author:

Jamie McClelland

Comment:

--

faq/setup-development-workstation

@@ -10 +10 @@
 == Installing and configuring critical helper packages ==
 
-Being able to send and receive email often part of the web application development process. 
+Being able to send and receive email is often part of the web application development process. 
 
 {{{
@@ -137 +137 @@
 
 Now you are ready to begin. You can start placing files in your project's web directory and access your project at the URL: !http://mfpl.fidel/
+
+== Keeping files in sync ==
+
+If you are working on a database driven project (like Drupal) it can be difficult to keep your database and (in the case of Drupal) your files directory in sync.
+
+A bash script like the following one can help - by providing an easy way to synchronize your development platform with the live site:
+
+{{{
+#!/bin/bash
+echo "Synchronizing database."
+ssh <user>@<server> "mysqldump -u <remote-db-user> -p<remote-db-pass> <remote-db-name>" | mysql -u <local-db-user> -p<local-db-pass> <local-db-name>
+
+echo "Synchronizing files."
+rsync -av <user>@<server>:<remote-path-to-files-directory> <local-path-to-files-director>
+}}}