WordPress version 2.7 has been released and can be upgraded easily using UNIX / Linux shell prompt. A few assumptions:
- WordPress database name: wptheosblog
- WordPress directory name: /var/www/html/theos.in
- WordPress domain name: theos.in
- Operating system: Linux
If you are not comfortable with UNIX shell prompt (IF YOU ARE new to a UNIX/Linux os), please follow traditional way of upgrading wordpress
and DO NOT use the three Steps described here.
[click to continue…] Sysadmin because even developers need heroes!!!
Using UNIX pipe concept one can dump database to another server securely using ssh protocol. All you need remote execution rights for the ‘dd’ command, over SSH. This allows you to run database dumps across an encrypted channel.
Dump Postgres Database using ssh
Use pg_dump command command:
pg_dump -U USERNAME YOUR-DATABASE-NAME | ssh email@example.com "dd of=/pgsql/$(date +'%d-%m-%y')"
Dump MySQL Database using ssh
Type the following command:
mysqldump -u USERnAME -p'PASSWORD' YOUR-DATABASE-NAME | ssh firstname.lastname@example.org "dd of=/mysql/$(date +'%d-%m-%y')"
Usually you run mysqldump to create a database copy and backups as follows:
[click to continue…]