//If you want to take backup from your main server//

1. mysqldump -u root -p streamcreed_db > backup.sql    if your mysql service has password

or

2. mysqldump -u root streamcreed_db > backup.sql    if your mysql does not have password


//If you want to restore a  StreamCreed backup from your main server//  

Please put your backup in /root/ 
And run
mysql -u root -p streamcreed_db < /root/backup.sql