By default WordPress shortens two dashes or hyphens (–) to a single dash (-). Not very practical if you need to show a command that uses double-dash options such as the “–all-databases” in the previous post about mysqldump over ssh.
I found that this behavior could be altered by editing wp-includes/formatting.php and removing the third element of each of the arrays on line 73 and 74 ($static_characters and $static_replacements).
This looks to be a smooth guide for setting up a Ruby on Rails production environment on Ubuntu 12.04.
Running mysqldump over ssh is a simple way to copy or back up a mysql database from a remote system. Granted, it’s not suited for every scenario, but for a quick dump of the small database on my remote webserver, it’s just the thing.
Quick and dirty, got to love it 🙂
ssh -C webserver01 mysqldump -u root –password=mysecret –all-databases > mydumpfile.dmp
