MySql Backups

There appears to be a few different ways to do this. One of the most desirable ways appears to be via MySQL administrator but this appears to be only active for enterprise users.

There a few discussed on both the MySQL site and devshed. The most popular option seems to be to use command line with mysql dump.

I've adapted this shell comand to store a backup copy
"C:\Program Files\MySQL\MySQL Server 7.0\bin\mysqldump" -u root -p sugarcrm_dbo > "C:\Documents and Settings\SOME DIR\mysqlweekly.sql"
and
"C:\Program Files\MySQL\MySQL Server 7.0\bin\mysqldump" -u root -p sugarcrm_dbo > "C:\Documents and Settings\SOME DIR\mysqldaily.sql"

My reasoning for two files is that I think it pheasible that the DB could get corrupted during an update, killing both the DB and the backup.

Problem with doing this is you need to store the password in the bat file to fully automate and that is pretty insecure. Further investigating will need to be done before going ahead in this manor.

I then store these two bat files and then need only use windows scheduled tasks. To open Scheduled Tasks, click Start, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks. Then simply follow the add wizard.

For debug purposes of the bat file use: cmd.exe /k "the .bat file" so that the window stays open, allowing viewing of any errors.

UPDATE: I appear to be wrong, you can update using public MySQL administrator. You simply need to create the project 1st. Note, to run as scheduled tasks it needs to be done via a stored connection within the connections manager. Why this didn't come up in a search on google or be updated on the MySQL site is beyond me. Retweet this button on every post blogger

Installing MySQL

It's an easy enough install one point to note, don't run the install without adding a root user.

If you do you'll probabley need to un-install and re-install

This blog post maybe of help. Specifically, this command line:

To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line:

C:\>sc delete mysql
[SC] DeleteService SUCCESS

And this thread may help with adapting root level user if lost or forgotten.

There are couple of additional tools that can be installed, I've opted for Gui-Tools and Workbench Retweet this button on every post blogger

SugarCRM and SQL Server 2008

There is currently no support for SQL Server 2008 within the sugarCRM. This is quite frustrating as I've spent the best part of a weeks free time getting this going only to see it be v.buggy and unusable.

There was a blog post that it was available for the 5.5 beta version, and even had an update in the user documentation to the affect. However, the blog posts date was after the file update date, and when attempting the instal with this SQL server was not appearing as a database option. I always thought open source, not re-inventing the wheel was supposed to be quicker!

So, my plan is now to instal and run off of MySQL, which will be a new thing for me. Hopefully should work ok otherwise I'm in danger of becoming a right miserable git. Retweet this button on every post blogger