Oh, and the ssh command ssh server is working because I've created an alias in a local. Obviously I'm a little new to this, and I think I've got a lot of unnecessary redundancy in there. So far I have this: ssh server 'mysqldump -u root -p'mypassword' -single-transaction wordpress_database > wordpress_database.sql' & scp /Users/me/Downloads/wordpress_database.sql & /Applications/MAMP/Library/bin/mysql -u root -p'mylocalpassword' wordpress_database < /Users/me/Downloads/wordpress_database.sql The idea is to create a local version of my current online site to do development on. Replace my local Mamp Pro mysql database.Download the backup file to my local harddrive.Ill backup these DBs using mysqldump -h HOST -u USER -p > backup.sql. Create a mysqldump backup of my Wordpress database Download the data dump using a BitTorrent client (torrenting has many benefits and reduces server load, saving bandwidth costs). Download files and run: This project uses mysql.Then I realized I could use it both as a development server, as well as a backup for my web server.I'm creating a snippet to be used in my Mac OS X terminal (bash) which will allow me to do the following in one step: SOURCEDIR='/public_html/db-backup' login to remote server ftp -n -i $SERVER < mysqldump download

Hello all, hopefully this is the right section to post this in.

Mysqldump download