![]() Creating the remote database Creating the local database OK, so now what? Deciding on fields Deciding on an index Creating the table Insert some data Querying the database Scripted querying Uploading onto the server |
Creating a database on the remote web serverIn order to create a database on the remote web server you need to be on-line, and go to your website but with an addition of "/cgi-bin/plusmail", so if your web site is called "mysqltest.com" then the address you need to go to is "mysqltest.com/cgi-bin/plusmail". Once this has been achieved you will be presented with a login name and password prompt, you should know these details. Once your login name and password have been entered you will be presented with a screen of menu options where you can do many different things, you should click on the button labeled as "Add Features". When this button has been clicked on you will be presented with a control-panel with many different features and options. Find the option called "Add mysql", underneath which there should text boxes where a password and database name should be entered, in the password option text space you should enter the password that we decided on earlier, and the database name should be something relating to the database that you are making. The other thing that you need to do is create a database on the local MySQL server with the same name as the one on the remote web server and with the same username and password access privileges, by doing this it makes uploading and access to the database easier. |