Hi,
I have been looking at a lot of web hosting sites.  I have yet to find any decent information regarding how to create and manage tables, queries, reports... for MySql databases.  I am familiar with MS Access and currently manage a database on a SQL server.  I create tables in Access and then upsize to SQL and post on the server.  This is very easy.  I am wondering if I will have the same ease of use if I select a host (such as LunarPages) that uses MySql.  I keep reading and hearing that there is an easy web-based way to create tables, queries, reports... similar to using MS Access, but have yet to see an example or have someone really explain it.  I have been referred to and looked at "PHP MyAdmin".  Looking at that made me even more confused.  It appeared from that site that you just have to write the code!  It looks nothing like Access.
 
I'm Just wondering if anyone could help me understand how I would manage a MySql database if I chose to host my site with LunarPages.  I CANNOT AND HAVE NO DESIRE TO learn PHP and WRITE THE CODE!  Any information would be greatly appreciated.  Thanks.
   

Thanks.  Could you provide any more details as to how tables are created with PHP MyAdmin?  I am very new to this and there is absolutely no CLEAR info out there.  Do you click "Add Table" and then name the fields...????  What about queries and reports?

We do multimedia authoring and are starting up a small business.  My husband would like to set up his own database to test his programs and setup demos for customers.  Potentially, he would even host a program for a client.  Our databases are not terribly complicated.  We collect user information such as name, job title, ID number.  We send data such as test scores, educational compliance... from within our authoring program (Illuminatus Opus).  The queries and other database connections are created within the authoring program, which prevents us from having to write  scripts for everything.  Hence, we do not have this type of experience.    

We have learned the basics of using Access to build our tables and upload to a Sql server and are comfortable with this, but since the hosting plans for Linux/MySql are so much less expensive and comprehensive than Windows hosting plans, we want to learn more about how to do what we are currently doing with MySql. Our biggest concern is that it will be difficult to work with MySql without programming/scripting and/or extensive database experience.

You said that you can export Sql code from Access to post to a MySql database.  How would this work?  Could I simply upload a table as I do today to a Sql server?  Thank you so much for being willing to answer these questions.

First I will answer you, Laurie Perry.

You can upload tables easily with the web interface called "phpmyadmin" available in the Control Panel.

It should be fairly straightforward, as you have done it before.

vino_ny:

You can connect to your database from home, through the mysql software

You can use phpmyadmin from the Control Panel, which is the easiest option really.

What kind of links were you wanting? I don't have any relevant links for you. You could search www.google.com for mysql upload table

You could run your own mysql server as a mirror. You would have to export your database at home, then import it using phpmyadmin at lunarpages.

It doesn't work like ftp.

You can backup your whole database, to download it, using phpmyadmin or the backup tool in CPanel.

It is not necessary for you to have mySQL at home, unless you need it, obviously!

I would really recommend that you don't run it at home, because moving databases is a real pain!

Not exactly.

What I was saying is that you can export SQL queries from access, then run them on your lunarpages database.