how do I upload

I just bought some web space which has mysql capabilities..... I am using
SSH and have created a database and a table........ now I would like to
populate the table by using a text file which is stored on my home
computer......... could someone please give me the syntax for this because
the mysql book I am using "SQL Queries for Mere Mortals" by M. Hernandez
although very good for demonstrating SQL queries does not seem to indicate
just how to get the data uploaded into your table !

I do have ftp capabilities also which I am using to upload my .html files
to my web space area, but I guess I don't know how to access the database
area with ftp or even if that is the way to do it...... thanks for any
help.... if you know of a good book which explains this , that would be good
too.....

Re: how do I upload

don wrote:
> I just bought some web space which has mysql capabilities..... I am using
> SSH and have created a database and a table........ now I would like to
> populate the table by using a text file which is stored on my home
> computer......... could someone please give me the syntax for this because
> the mysql book I am using "SQL Queries for Mere Mortals" by M. Hernandez
> although very good for demonstrating SQL queries does not seem to indicate
> just how to get the data uploaded into your table !
>
> I do have ftp capabilities also which I am using to upload my .html files
> to my web space area, but I guess I don't know how to access the database
> area with ftp or even if that is the way to do it...... thanks for any
> help.... if you know of a good book which explains this , that would be good
> too.....

Does your webhosting have admin panel? Usually you can use phpmyadmin
at admin panel. From phpmyadmin you can easily import your data.

If there is no phpmyadmin you can upload your sql dump into your
server. And from ssh sell type this:

mysql -u username -p databasename < sqldata.sql

regards,

Lorento
--
http://blog.deshot.com
http://www.padbuilder.com
http://www.groupvita.com

Re: how do I upload

Thanks for the great syntax - if you know the exact spot where this is
demonstrated on the MYSQL site pease send me the link ..........
>
> If there is no phpmyadmin you can upload your sql dump into your
> server. And from ssh sell type this:
>
> mysql -u username -p databasename < sqldata.sql
>
> regards,
>
> Lorento
> --
> http://blog.deshot.com
> http://www.padbuilder.com
> http://www.groupvita.com
>