Re: changing from MS Access to mySQL
Friday, August 17, 2001 02:05 PM
There is a tool you can download at
There are others but this is the one I
got to work for me without data loss.
also you'll need a new JDBC driver.
mmySQL is free and very good. I'd
offer code to configure it but I don't
know what kind of machine your ISP is.
It is not hard to figure out.
This driver needs to be in the classpath. Also you will have to see how your ISP will host your DB and how you should connect to it.
mysql creates its own file. to create a connection with the mmsql drivers would look like the following (which was the only change I had to make to my servlet to make it work with mySQL)
Properties P = System.getProperties();
String url = "jdbc:mysql://yourservernamegoeshere/thenameofyourdatabasegoeshere";
Connection con = null;
con = DriverManager.getConnection(url, "user", "password");
I converted my database this week and the process really was not bad at all.
also a list of nice mySQL compatable browsers other than the one above can be found by linking to www.mysql.com