changing from MS Access to mySQL
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Stephen_Fu
Posted On:   Friday, August 17, 2001 08:02 AM

I have developed my servlet using MS Access connectivity but the host i have signed up for requires me to use mySQL instead



I was wondering if anyone had any advice in the following areas:

1. Is there an easy way to convert the Access database to mySQL so i don't have to create it in mySQL from scratch (as i have no experience of mySQl)

2. What kind of file does mySQL create, as i will have to register the database.


Any help is appreciated, thanks!


Re: changing from MS Access to mySQL

Posted By:   Anonymous  
Posted On:   Friday, August 17, 2001 02:05 PM

There is a tool you can download at


http://dbtools.vila.bol.com.br/



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)



Class.forName("org.gjt.mm.mysql.Driver").newInstance();

Properties P = System.getProperties();

P.put("jdbc.drivers", "org.gjt.mm.mysql.Driver");

System.setProperties(P);


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
About | Sitemap | Contact