Possible to install on MS SQL / Windows instead of MySQL

[Vincent Huckle]

I'm wondering if there is an install package or configuration document that would explain how to install and configure this on MS SQL and Windows server to allow for easy database backups.

[Vincent Huckle]

As a follow up and clarifying information to my question, we found ourselves in a situation with a corrupt index that has taken the database completely offline.  The only way we can bring the database online is to use the innodb_forced_recovery function, which gives us an empty database because the indices are bypassed.

Any help in rebuilding an index while the database is in an offline / stopped state would be MOST appreciated, in addition to the original question of the possibility of loading this on Windows / MS SQL for database backup purposes.  If Windows is not an option, is there a reliable AUTOMATED backup process for the MySQL database?  I have been unable to find anything with a good rating on the internet.

PS - we are NOT a Linux shop.  This is the only operational Linux box in our environment, and we are struggling to manage it properly.

Thanks in advance for any help / advice!

Vincent Huckle

Director of IT

[Luke Baker]

Vincent,

The All Our Ideas software does not support MS SQL or Windows server.

I think the details of recovering from whatever corruption that you
experienced may be dependent on what was corrupted and how it was
corrupted. I'm not very familiar with rebuilding an index.

This is a solid backup tool for MySQL databases:
http://www.percona.com/software/percona-xtrabackup

Luke

> --
> You received this message because you are subscribed to the Google Groups
> "All Our Ideas" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to allourideas...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Vincent Huckle]

Thank you for the lead on the backup solution!!  That is good for future use.  Now if I can just get the database back online with all the data!

On Monday, July 29, 2013 4:29:06 PM UTC-4, Vincent Huckle wrote:

[Vincent Huckle]

Just to close the loop on this topic, we managed to get the index rebuilt and the database back online with no loss of data.

On Monday, July 29, 2013 4:29:06 PM UTC-4, Vincent Huckle wrote: