We help IT Professionals succeed at work.
Get Started
old mysql machine - migration, best practices, and other questions
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 '?'
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 '?'
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