Importing data in an access DB to a mysql DB

[bullet]

Hi I am new here. I am just getting my Domain up and running. One thing I would like to ask is if you can check and see if I am able to get to my domain. I call yesterday at bluehost and they told me I can not get to my Domain, but I am able to go into my mysql and make a DB table. I try to import my access DB to My mysql and no luck. I am using ODBC 3.5 to transfer. Can someone help!!!!!!!!!

[bullet]

I forgot you will need this www.bedandbreakfastregistry.com

[bullet]

How do you put you put your Databases up?? I think access is alot easier than putting it straight into mysql

[charlesp]

You can convert your Access database to MySQL but I don't remember how. Try Google or mysql.com

[felgall]

The only time I ever used Acess I used the SQL interface to do things because using the standard approach that works with all the different relational databases is way easier than messing about with a custom interface that only the one program understands.

As for how to convert from Access to MySQL there are lots of tutorials on how to do it and products to do it with at http://www.google.com/search?hl=en&q=convert+access+mysql&btnG=Google+Search

[bullet]

I would like to make a registry of business across USA. I would like this to search by state and city. I heard a database with php is the best way to perform this. What would be the best software to use to perform these task. I have built many sites with html and it is just now I am getting my feet wet with php. I have been ask to build this site. I don't think I can build it with html. Well I could but I think it would take me longer than learning php.

I would be thankful for any input you may have. I am not sure of the progams I need and If there is a wysiwyg for php that would be nice.
I don't have to be free. I will make money on the site so I can afford some software. Thanks

[felgall]

You would still use HTML for the final web page. The PHP would just act as a programming layer between the HTML and the database. There is no WYSIWYG for PHP because PHP is processing and not display.

[bullet]

Thanks Fegal
What about phprunner what is that program.

[felgall]

I haven't come across it before. It looks like it probably contains a lot of the basic functionality required to link your HTML and mySQL together without having to write all the PHP yourself. Presumably you feed it information that links a number of its precoded functions together to perform basic tasks. It may be suitable for creating simple web sites that run off a database. They have a try bbefore you buy option so that you can try it and see.

It probably isn't all that different from the various content management systems that you can install that have all the PHP written for you and just need you to choose a theme and configure a few options. Many of these systems are free for anyone to use.

[TheHerk]

Awesome move. Headfirst is always the way to go. PHP is an amazingly powerful language, but I would urge you to look into many languages if you plan to learn one well and stick to it. There are some pros and cons that may sell you a different result than PHP. You might check into PHP, Ruby, Python, Perl, and Java. There are a ton of others, but you may find one that looks more appealing to your taste than PHP. If you do go with PHP, phpbuilder.com is an awesome community.

Regarding the db, this should not be to much of an issue depending on the complexity of the db. It is just a matter of getting it into a universal format, like text file where all the values are delineated by commas. This is called a .csv. I'm not certain, but you should be able to export a .csv from Access and import the same .csv in MySql assuming you have the table schema in place already.

[bullet]

I guess I don't understand the cms. I was told joomla is good. I didn't know they can help you write the code. I can't get a learning guide of joomla. would you think this would be good for my project. I would like to make a database of states and cities. The user would put the state they would like to go to and then the cities for that state would come up and show the hotels in that city. Would I be able to use joomla to do this project f I learn it. Thanks for the help. You have been a great help already.

[TheHerk]

Joomla is not a programming language and offers no features, as far as I know, that would help you with your cause. However, it is a good CMS I hear, so you could make your project a nice and easily maintainable site. However, even with Joomla you'd be writing in PHP and using MySQL as your database.

The script to do what you are talking about, needs to be written in some scripting language. If you are using Joomla as your CMS, I'd suggest writing your script in PHP as well, since Joomla is PHP. Otherwise check out scripting languages until you find the one you like, and just start writing until your fingers hurt. After a few days you'll figure out which direction you ought to head and which questions need to be answered first.

[bullet]

Hi the jeck
Like the user name it is great. Wish I would have thought of it. I would like to get a site running and making a little money so I can do programing full time. I know java and html. If there anything to learn in html. I it made easy with the wysiwyg programs. I am sure you read what I would like my first project to be. I is a paying job. Do you think Joomla can help me make a nice beginners site to grow on as I learn more. Thanks

[bullet]

I understand it is not a script. It will help me in this case and I will be learning php. I have books on perl and ruby. What other scripts should I try. My next site will be bigger and much more profitable. Both of the sites will be residual income. That is a good thing. Build the main page once and more money more money.LOL
This is a little project for a freind and is in a hurry to get it up. The next one will be one for me.:)

[2notch]

It sounds like your application could be done with something as simple as a link directory script.

The first page has a set of links for each state. A state link would go to a page with all the cities for that state. Each city link would open a page with all the hotels on it. About as simple as it gets.

There must be hundreds of "link directory scripts" out there. There are some good ones that are free too. Here's one now...
http://www.dataspheric.com/services/software/ls/

Most of the scripts will have a lot of features you probably won't need but they could give you some ideas for monetization. You could strip out the unwanted features and make a lean mean script.

Here's a very simple link directory script I found at sourceforge:
http://sauddirectory.sourceforge.net/
Go through the code on this one and see how it's done.

[bullet]

Thanks notch2
Can I upgrade joomla 1 that is installed on the bluehost site to joomla 1.5?

[felgall]

Thanks notch2
Can I upgrade joomla 1 that is installed on the bluehost site to joomla 1.5?

See http://docs.joomla.org/Migrating_from_1.0.x_to_1.5_Stable for the instructions on how to migrate from version 1.0 to 1.5.

[bullet]

Thanks felgall

Now I have found a program that I think will do what I would like to do. It is called SOBI2.
It will search catagories and subcatagories and catagories under that. This is what I want. I don't see have to install the It is all in one zip file.
http://www.sigsiu.net/download/plugins/

This is a link if you can help me out. Thanks Ron:(

[bullet]

Now I am sure if I what SOI2 .
Thanks

[jbladeus]

In reply to the query in the thread title, here are a couple of links to software which convert access data to mysql.

http://www.bullzip.com/products/a2m/info.php
http://www.convert-in.com/acc2sql.htm
http://www.softgalaxy.net/access-mysql/index.html