mysql

Move Drupal site from one subdomain to another subdomain in multisite Drupal installation easy with manually updating files path in database.

UPDATE files SET filepath = REPLACE (filepath, 'old/path', 'new/path');

Backup

Simple backup

mysqldump --opt -u[user] -p[pass] [database] > [filename].sql

• [user] Your database username
• [pass] The password for your database (note there is no space between -p and the password)
• [database] The name of your database
• [filename].sql The filename for your database backup
• [--opt] The mysqldump option