black cat Posted January 30, 2006 Share Posted January 30, 2006 Hi Folks, Wondering if anyone has used this conversion program from BullZIP.com to convert an Access Database to MySQL : I'm new at MySQL, is it as good as it sounds? I am thinking of trying it and I am wondering if anyone knows what to enter in the "host" and "port#" fields for the destination database. Thanks! Quote Link to comment Share on other sites More sharing options...
cajunman4life Posted January 30, 2006 Share Posted January 30, 2006 It would almost be easier to use the "create dump file" option, gzip that (using 7zip or another zip program that does ".gz" extensions (not sure if Winzip does or not haven't used it in years)), and then in cpanel you can restore a mysql db in the "backup" section, just select the gzip file you created and click upload. Quote Link to comment Share on other sites More sharing options...
stevevan Posted January 30, 2006 Share Posted January 30, 2006 While I personally have not tried it, I usually take to heart the old saying "...if it's too good to be true, it usually is." Having said that, if you try this app, post something back here and let everyone know how it works out! Quote Link to comment Share on other sites More sharing options...
borfast Posted January 30, 2006 Share Posted January 30, 2006 Steve and black cat, guys, I think you're asking and replying to different things. I believe black cat was referring to MySQL when he (she? argh! the internet communication's biggest problem ) asked if it is as good as it sounds and Steve I think you replied about the BullZIP.com application, right? Well, I don't know about the BullZIP.com stuff but I know about MySQL and it's a great database engine but it is not the same thing as MS Access. MS Access is more than a database engine, it is a database user interface, which allows you to do lots of stuff, including using other database engines. For instance, you can <a href="http://www.nusphere.com/products/library/devshed_mysql_odbc.htm">configure MS Access to use a MySQL database</a>, if you want. That gives you the power of MySQL and all the ease of use + functionalities of MS Access. Quote Link to comment Share on other sites More sharing options...
stevevan Posted January 31, 2006 Share Posted January 31, 2006 You're right Raul. Of course, my personal take on this is...Access is made by who? Enough said right there. Blackcat...I think you'll be happier with MySQL instead of Access. There are many resources available out there to help you understand it. Quote Link to comment Share on other sites More sharing options...
borfast Posted January 31, 2006 Share Posted January 31, 2006 (edited) You're right Raul. Of course, my personal take on this is...Access is made by who? Enough said right there. LOL You have a point there, Steve I must be out of my mind to talk about MS Access and not mention OpenOffice.org 2.0 - it has a new database application called Base, which can use a lot of different standard database backends, including MySQL. Edited January 31, 2006 by borfast Quote Link to comment Share on other sites More sharing options...
black cat Posted January 31, 2006 Author Share Posted January 31, 2006 Thanks for the replys everyone! I am all for switching to MySQL. My client has an Access database that I want to convert. In the conversion tool from BullZip there is a field to enter the host address where the MySQL database will reside. Does anyone know what the path would be? Also, the port number?? Thanks much for any tips or tutorials you can point me to. Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted January 31, 2006 Share Posted January 31, 2006 My guess would be your domain name for the host. The port looks right 3306. You will have to give access to your IP number in the MySQL Access Hosts section of cPanel. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.