mySQL

Hi

I am developing a website locally, which will need hosting, but I have not yet used databases with web hosting.

I understand there are all sorts of HTML "easy" panels to control databases and such, but what I want to know is if I will be able to use MYSQL.EXE on the command line as I do on my PC ?

I want to be able to use mysql.exe and then SOURCE to run my SQL scripts to create tables, import or export data, or run querries on the database that would be on the host. Can I do that ?

[Stef]

You can connect to the mysql server from the commandline:
mysql -h <yourdomain> -u <db_username> -p<db_password>.

You can also use any 3th party mysql database manager (like MySQL Administrator).

Stef.

Thank you!

Just one more (unrelated) question..

Can I enter a "dummy" domain name during the ordering procedure ? I have not yet decided the exact domain name I want to use, and will buy one separately. However when I want to order it asks me for an existing domain name or it goes into the "will get a domain name for you" procedure.

What I want to do is just use the temporary address (some IP/~username I think) for a week or two while testing things and I'll get a domain name during that time.

[hotdog]

Do it the easy way, download a Apache/PHP/MySQL bundle, heaps around, firepages.com.au is a good one (pick the version of php closest to hostgators - about 4.something).
down and run, this way you have a server on your computer and you dont need to connect to the net, and if you mess the code up, worst thing you have to do is reboot your computer instead of being suspended for bringing the hosted server down.
Once you've finished your site (or any updates), just ftp the .php pages and make changes to database manually or save your database off your pc via phpmyadmin as a dump file and import the whole file into your hosted account.

If you are unsure of a domain name, wait until you are sure before you get hosting, nothing worse than picking a web name under pressure. hg arent going anywhere

I'd have to agree with everything hotdog said. As for the domain, here is what I would do. You will have add-on domains to use, so use them. Get a your-family-name.name or .us or .cc or whatever, and register the account with that. I never thought I would use one, but I love having a .us domain with my family name for e-mail accounts and small projects that don't need their own domain, but are more importent then a free page. Then you can register an add-on domain for your main site. It's an extra $9.00 a year at the most anyway.

Staren