Web and MySQL

Latest post 06-06-2009 7:57 AM by gdarter. 7 replies.

Web and MySQL

03-01-2009 7:58 AM

I have made a ata base with Access it is loaded onsite using MySQL.  I would like it to work online but all it will do is load to my pc.  What else do i need to acomplish this?

 

Thank you

Tammy

Re: Web and MySQL

03-01-2009 1:24 PM

Hi Tammy,

Can you clarify this please? - You made a database with Microsoft Access, ported it to MySQL and have now uploaded the database to a web host (is this correct?). Now you cannot access or work on the online database, however you can work on the database on your computer...

How are you trying to access the online database? (is MySQL properly configured on your web server?) - how are you parsing the SQL strings to MySQL? (imbedded in a web page or some other way?

I'm sure with a bit more information we can help sort this out for you.

Re: Web and MySQL

03-01-2009 7:32 PM

Well i guess i am not sure how the MySQL is configured.  I was told if i made the data base and loaded it to MySQL it would run on site.  As of now i can use the link and it does download to my pc.  Which defeats the purpose.  It was meant so that we all could work on it from where ever we were at and not have to reload the database each time.

Let me take a further look at it and see what i can figure out.  I have never tried doing anything like this before but then again everything i have done is a new experience.  Jack of all trades master of none;o) 

They said if we posted we would get a responce so thank you for taking the time to answer so quick. 

Re: Web and MySQL

03-01-2009 8:03 PM

OK - Are you trying to run queries against your MySQL database? (the online copy) - If you are linking to the database and the link tries to download the whole database, it sounds like the web server might not be correctly configured...

Re: Web and MySQL

03-02-2009 3:39 PM

If you still need help you need to describe in detail what steps you are doing things.

If you uploaded the database, did you import it into SQL or use FTP to upload the database file? If you imported it into SQL, then what were the steps that you used to do that? :-)

Thanks,

Chris

Re: Web and MySQL

03-02-2009 6:28 PM

Sorry for such a late reply.  Unfortunately i just now got a brake. 

I went through my cpanel to mysql databases...they have an option to create a database...i used the link to upload it and it is located here http://usmwf.org/fpdb/ 

It is just the data base maybe i need to add a form.  but i wanted to see if this worked first and to be honest i like it better without the form.

I have no even tried to use mysql before so i am sure it is something i have not done.  all i can get it to do is file download..maybe something i need to do in the data base itself?  I really don't want to waste any more time loading info if it will not work or i don't have the brains to make it work.

thank you

Tammy

 

Re: Web and MySQL

03-04-2009 9:22 AM

What you have done is simply uploaded your Access database to your server. This will not accomplish what you are trying to do. All this means is that if someone clicks on the file, it will download the database to their local computer. Any changes, etc. that they make will only effect their local copy.

For what you are trying to accomplish, I would recommend trying to find someone local. What you will need to do, is to extract the information from your current Access database, create the same tables, etc. in MySQL on your server, import the information, and then, most critically, write custom web pages to access that information. Or, you can still have the Access database and then write custom web pages to access that information, bypassing the export, create table, and import steps.

The big point is still going to be having someone write custom web pages to get to this information that allows for reading, and updating the tables with some sort of security as to what users can do what. Then you also need the reports to get the data out of the database in some usable fashion.

An easier, and probably cheaper, solution for  you might be to store the Access database on your network (preferably on a server) and then have a computer or computers set up to allow  remote access. Then people anywhere with web access could log on to one of these remote computers and access the database the same as if  they were sitting in the office.

Yours is an all too common situation and most people really don't realize how much time and effort allowing remote/non-office access to critical business files can be.

Re: Web and MySQL

06-06-2009 7:57 AM

I suggest starting with the earlier articles on TechSoup regarding VPN (Virtual Private Networks).

Here is an Intro to VPN