Linux Shell script that migrates FTP & DB from DEMO to LIVE

We are losing time with the manual work of moving demo environments to live environments, we need to have this optimized in an automated way. FYI : the websites are based on WordPress CMS (FTP files + DB) There should be a settings file named [login to view URL] which consists of following variables: - DemoFTPURL (example [login to view URL]) - DemoFTPUsername (example demoftpuser) - DemoFTPPassword (example GryD641!h) - DemoHTTPUrl (example [login to view URL]) - DemoDBHost (example [login to view URL]) - DemoDBName (example mydemodb) - DemoDBUsername (example demodbuser) - DemoDBPassword (example demodbpass) - LiveFTPURL (example [login to view URL]) - LiveFTPUsername (example liveftpuser) - LiveFTPPassword (example liveftppassword) - LiveDBHost (example [login to view URL]) - LiveDBName (example mylivedb) - LiveDBUsername (example livebduser) - LiveDBPassword (example livedbpass) - STRING1DEMO (example /data/sites/web/xxxx/subsites/yyyy) - STRING1LIVE (example /data/sites/web/yyyy/www) - STRING2DEMO (example [login to view URL]) - STRING2LIVE (example [login to view URL]) Bear in mind that passwords might include special characters. The script should be bash (linux) based and working on Debian-based systems. The script should be called in the following format and should be able to run in a screen (linux command) so that it is possible to run parallel jobs: ./[login to view URL] --settings=example1 (which automatically searches for [login to view URL]) and imports the variables to be used) 1. Connect to DemoFTPURL, browse to DEMOPATH and download all files (including hidden) & directories to a local directory named as DemoHTTPUrl (DEMOPATH should be constructed by looking at the STRING1DEMO, and only taking the part after the "xxxx/" so in this case that would be subsites/yyyy) 2. Go into the DemoHTTPUrl directory, open [login to view URL] and change the DB_NAME, DB_USER, DB_PASSWORD, DB_HOST fields to be the ones of the LiveDB-credentials 3. Use linux app named mysqldump to connect to DEMO-dbhost/dbname/dbuser&pass in order to export the .sql (example : mysqldump -h DemoDBHost -u DemoDBUser -pDemoDBPass DemoDBName --no-tablespaces > [login to view URL]) 4. In the [login to view URL], replace STRING1DEMO with STRING1LIVE, replace STRING2DEMO with STRING2LIVE) 5. Use linux app named mysql to connect to LIVE-dbhost/dbname/dbuser&pass in order to import the .sql (example : mysql -h LiveDBHost -u LiveDBUser -pLiveDBPass LiveDBame < [login to view URL] 6. Connect to FTP of LiveFTPURL, browse to /www, and upload all files (including hidden) & directories from FTPURL On every step of the way it should show the progress in the bash shell and log it in a seperate file named DEMOHTTPUrl) You can definitely do suggestions if you have a better set-up for this, but above should be the basis.