backup restore mysql sugar crm

backup:

mysqldump -u root -ppassw0rd sugarcrm > \
backup/sugarcrm_11-12-2008-01_dump.sql

mysqldump -u root -ppassw0rd sugarcrm > \ backup/sugarcrm_11-12-2008-02_dump.sql

mysqldump -u root -ppassw0rd --all-databases > \ backup/all-database_11-12-2008-01.sql

mysqldump -u root -ppassw0rd --all-databases > \ backup/all-database_11-12-2008-02.sql

Restore:

mysql -u root -peLaStIx.2oo7 sugarcrm < \ backup/sugarcrm_11-12-2008-02_dump.sql

Remote Access to Mysql

grant select on *.* to 'root'@192.168.100.54 identified by 'eLaStIx.2oo7';
grant update on *.* to 'root'@192.168.100.54 identified by 'eLaStIx.2oo7';
grant create on *.* to 'root'@192.168.100.54 identified by 'eLaStIx.2oo7';
flush privileges;