select s.* from prod_drupal.system as s left join e_drupalp6.system as d on s.filename= d.filename where s.status<> d.status
Backup direct to other database
mysqldump --opt --user=root --password= prod_civicrm | mysql --user=root --password= dev_civicrm
Backup
mysqldump -u backup -p prod_civicrm > /home/db/prod_civicrm.sql
ou
mysql -u backup -p prod_civicrm1 tbname >> /home/db/prod_civicrm1.sql
Restore db
mysql -u backup -p prod_civicrm < /home/db/prod_civicrm-4.0.0.sql
Install new site
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON prod_drupal.* TO prod_drupal@localhost IDENTIFIED BY