Crystal Server XI R2 - How can I restore the CMS database?

[SSSFisgard]

Hey guys,

I'm stuck. Our servers all went down and I now am re-installing Crystal Server XI R2. I have backups of the filestore and the CMS database, but I'm having a hell of a time restoring the MySql database. Any help in the process would really ber appreciated. Thanks

 

[Turkbear]

Hi,
What problems are you having?..
You should be able to configure the CMS to connect to the MySql database that was restored and, as long as the Servers point to the correct filestore locations,all should work as before.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SSSFisgard]

Hi Turk,

I'm stalled at the start really. I've got the backup .sql file sitting there, and trying to run a restore. thats where I'm getting stopped. I can't seem to be able to run a restore properly. to be honest, I'm the shits with MySql stuff so this could be part of it. haha. Could you step me through a restore of MySql?

Thanks

 

[Turkbear]

Hi,
Sorry, never used that database product,but these may help:

http://php.about.com/od/learnmysql/ss/mysql_backup_2.htm

http://www.webcheatsheet.com/SQL/mysql_backup_restore.php

http://www.techiecorner.com/31/how-to-restore-mysql-database-from-sql-dump-file/

To Paraphrase:"The Help you get is proportional to the Help you give.."