Jump to content
Sign in to follow this  
black cat

Ms Access To Mysql

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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 by borfast

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...