We help IT Professionals succeed at work.
Get Started

old mysql machine - migration, best practices, and other questions

Mystical_Ice
Mystical_Ice asked
on
84 Views
Last Modified: 2015-09-23
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 '?'
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE