OK, now that we all know the basics, its time to connect to the server. If you have any
problems email support, they like answering these questions.
shell> mysql -h localhost -u joesauto -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 459 to server version: 3.22.20a-log
Type 'help' for help.
After successfully connecting to the server we need to access the database (joesauto)
that I got support to create for me. If you don't have a database yet now is the time to
create one. To see what databases are on this server type show databases; if your database
is there select it by typing use joesauto if you can't access the database contact
support. This tutorial could take days if your support is slow.
mysql> use joesauto
OK, after alot of reading
I figured out how to create a table for all the important data
(year, make, model, price and picture), the picture part took alot of time to figure
out, I found out that it was best to just store the picture filename in the database and
store the actual picture in a specified directory on my server. Below is what I used to
create the table. (I am sure there are other ways of creating this table but, this is
what worked for me.)
mysql> CREATE TABLE joesauto(
-> year INT(4),
-> make CHAR(20),
-> model CHAR(20),
-> price CHAR(15),
-> picture_name CHAR(25)