Hi,
Have a situation where a small company has an old desktop computer that's running Debian Linux, with a MySQL database that I believe a Microsoft Access front end is connecting to (I may be wrong on the Access part). I'm trying to implement a 'best practices' solution for them. This is not a case of moving to the cloud, or investing tens of thousands of $ - it's a small company, but they need some best practices implemented.
I have 0 experience with MySQL - all my experience is on the MS sql server side.
Was thinking - could they set up a (physical or virtual) windows 2008 or 2012 machine and run mysql on it? That way it could be included as part of their backup plans.
Is it possible to go from a Linux MySQL database to a windows MySQL database? What's the easiest method to create a daily backup of a MySQL database? Is there a script I can run to export it to a file share somewhere (perhaps with the date in the filename)?
Just looking for overall best practices to go from a 10 year old debian server running the MySQL database, to '?'
It's definitely a doable project but you may want to gather some more details before you try moving the data. Are they actually using Access and if so, what version and what version of the MySQL ODBC driver are they using? Are they using any programming languages like ASP, VBScript, or PHP to access the database?