First time mysql

[SMCNYC]

Dear all,
I am trying to develop a web application.
I first subscribed to a web.
It has MySQl ver. 4.01 and phpMyAdmin ver 2.4
I am very very new to this stuff. Have no idea where to start. Read a lot, but could not go anywhere.
My questions are:

Can I work on Mysql which is on the web, or shall I install another version on my local and work accordingly. Do I need phpmyadmin, it is a pin in the ass (oops).
Can somebody help me. Thanks
Bascially I have some MS-Access tables and I want to export them to MySQL on the web. and I can not find a way. Thanks much

 

[QatQat]

If I remember correctly you can upload a dump file directly in the PHPmyAdmin interface.

Therefore I recommend to work on a local copy and at the end of your programming, upload a dump file and import it.


Bye

Qatqat

Life is what happens when you are making other plans.

 

[sleipnir214]

There are other MySQL management tools available. Whether you will be able to use one depends on your network setup.

You've said you've "subscribed to a web". From that I infer that you are using a hosting provider.

If that hosting provider has set up his firewall correctly, you will not be able to connect to MySQL other than by running the MySQL client your host provides.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rzs0502]

You should rather work on a local database for your development and deploy your changes on the live site and database when complete.
Instead of phpadmin, I think you'd find the MySQL Control Centre (from

http://www.mysql.com)

great to use for now.