Newbie needs some help

[lucy2u]

I'm a complete newbie to MySQL and PHP. I have a database in MySQL on my local PC. I have already part of my website on-line (the part without PHP).

My questions are:
1. How do I create my database on-line? So far I have done it manualy, but I wonder if there isn't a way to generate scripts and execute them on the server.
2. Once I have that database, how do I get the data in that database? I assume there is a way to import and export data.
3. The ID's of my tables are generated with autoincrement, but how can I get the foreign keys in my others correct so that everything is linked correctly.

Like I said I am a complete newbie.

[Amelia]

Hi,

Before I come on to the questions, it would be nice to know if your website is hosted somewhere? Generally a control panel makes things easier.

[BodShane]

Originally Posted by lucy2u

I'm a complete newbie to MySQL and PHP. I have a database in MySQL on my local PC. I have already part of my website on-line (the part without PHP).

My questions are:
1. How do I create my database on-line? So far I have done it manualy, but I wonder if there isn't a way to generate scripts and execute them on the server.
2. Once I have that database, how do I get the data in that database? I assume there is a way to import and export data.
3. The ID's of my tables are generated with autoincrement, but how can I get the foreign keys in my others correct so that everything is linked correctly.

Like I said I am a complete newbie.

In respect with your questions, i have answered them as follows :

1. How do I create my database on-line? So far I have done it manualy, but I wonder if there isn't a way to generate scripts and execute them on the server.
Ans. You can creae databases via a control panel and in order to generate scripts and execute them you will require SSH access.

2. Once I have that database, how do I get the data in that database? I assume there is a way to import and export data.
Ans. Once you have a database, you can create a .SQL file on your local machine and restore the file in your database.

3. The ID's of my tables are generated with autoincrement, but how can I get the foreign keys in my others correct so that everything is linked correctly.
Ans. Following is an example which will give you a better idea :

emp_tbl
emp_id Primary Key
emp_number Foreign Key
emp_name
emp_add

salary_tbl
sal_id Primary Key
emp_id Foreign Key
sal_amt

Regards,

Shane Phillips