Hey guys

A friend has recently bought his own RAQ4 server, he has enabled ASP and setup a DSN for my database. However I don't know what to do next. How to i build a DB on the new server and how do I ammend DB structure in the future.

I could really do with this info in Laymans terms as i've not done it before. :confused:

Once the DB has been created how do i then access this, when designing my DB application do i connect to the live DB or a copy on my own machine....

So many questions??? :confused:

Thanks in advance

Originally posted by p_moody
A friend has recently bought his own RAQ4 server, he has enabled ASP and setup a DSN for my database. However I don't know what to do next. How to i build a DB on the new server and how do I ammend DB structure in the future.

...

Once the DB has been created how do i then access this, when designing my DB application do i connect to the live DB or a copy on my own machine....
Ok, let's start at the beginning.

Ask your friend to install phpMyAdmin on the server (I presume that he did not disable PHP)? You'll then be able to use the phpMyAdmin web interface to create your mySQL tables. You can use the same to modify the structures and load data into the DB.

Connecting to the DB when developing can be done by connecting to the live DB or your local DB, but only do that when the site itself is not live yet. Best would be to install mySQL on your local PC.

You can find the phpMyadmin site here: http://www.phpwizard.net/projects/phpMyAdmin/

Another option would be to ask your friend to allow you to access the server via SSH. You can then log onto the server and use the command line mysql to connect to the database. You'll then use normal SQL statements to create the DB, etc. Or put your SQL commands in a script and execute that.

Hope this helps!

Importing data into MySQL can be tricky. So that I can better explain...find out what he's going to use to manage his MySQL DB's. Webmin and PHPmyAdmin are really the only two choices he'll want to use. If his server didn't already come with Webmin, then get PHPmyAdmin uploaded. It's FREE!!

Next I need you to find out what he wants imported. Will it be a Flat-File, Access File, MySQL dump, etc....

Let me know and I'll spell it out as easy as possible for ya. I was in that boat not too long ago.