Hi Folks,<br /><br />Wondering if anyone has used this <a href="http://www.bullzip.com/products/msa2mys/info.php" target="_blank">conversion program</a> from BullZIP.com to convert an Access Database to MySQL :<br />I'm new at MySQL, is it as good as it sounds? <br /><br />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. <br /><br />Thanks!<!--content-->
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.<!--content-->
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!<!--content-->
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 <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" />) asked if it is as good as it sounds and Steve I think you replied about the BullZIP.com application, right?<br /><br />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.totalchoicehosting.com/forums/lofiversion/index.php/"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.<!--content-->
You're right Raul. Of course, my personal take on this is...Access is made by who? Enough said right there.<br /><br />Blackcat...I think you'll be happier with MySQL instead of Access. There are many resources available out there to help you understand it.<!--content-->
<!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->You're right Raul. Of course, my personal take on this is...Access is made by who? Enough said right there.<!--QuoteEnd--></div><!--QuoteEEnd--><br />LOL <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /><br />You have a point there, Steve <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br />I must be out of my mind to talk about MS Access and not mention <a href="http://www.openoffice.org/" target="_blank">OpenOffice.org 2.0</a> - it has a new database application called <a href="http://www.openoffice.org/product/base.html" target="_blank">Base</a>, which can use a lot of different standard database backends, including MySQL.<!--content-->
Thanks for the replys everyone! <br />I am all for switching to MySQL. My client has an Access database that I want to convert. <br />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?? <br /><br />Thanks much for any tips or tutorials you can point me to.<!--content-->
My guess would be your domain name for the host. The port looks right 3306.<br /><br />You will have to give access to your IP number in the MySQL Access Hosts section of cPanel.<!--content-->
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.<!--content-->
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!<!--content-->
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 <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" />) asked if it is as good as it sounds and Steve I think you replied about the BullZIP.com application, right?<br /><br />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.totalchoicehosting.com/forums/lofiversion/index.php/"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.<!--content-->You're right Raul. Of course, my personal take on this is...Access is made by who? Enough said right there.<br /><br />Blackcat...I think you'll be happier with MySQL instead of Access. There are many resources available out there to help you understand it.<!--content-->
<!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->You're right Raul. Of course, my personal take on this is...Access is made by who? Enough said right there.<!--QuoteEnd--></div><!--QuoteEEnd--><br />LOL <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /><br />You have a point there, Steve <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><br />I must be out of my mind to talk about MS Access and not mention <a href="http://www.openoffice.org/" target="_blank">OpenOffice.org 2.0</a> - it has a new database application called <a href="http://www.openoffice.org/product/base.html" target="_blank">Base</a>, which can use a lot of different standard database backends, including MySQL.<!--content-->Thanks for the replys everyone! <br />I am all for switching to MySQL. My client has an Access database that I want to convert. <br />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?? <br /><br />Thanks much for any tips or tutorials you can point me to.<!--content-->
My guess would be your domain name for the host. The port looks right 3306.<br /><br />You will have to give access to your IP number in the MySQL Access Hosts section of cPanel.<!--content-->