In article <Xn****************************@211.29.133.50>,
ree <re*@hotmail.coom> wrote:
I have a tables for a database that I have entried data in to. I have used
the table on my local comp. and used apache & mySql to test it out.
Now I need to upload the table to the site. But not sure how to do it. I
don't want to enter the details all again.
Can someone point me to a link that explains how to upload these tables.
Also the the webhost is using Cpanel.
I believe CPanel lets you import MySQL dump files. You want to do a
mysqldump to file, upload the dumpfile to your server, then import it to
your database. man mysqldump, or check mysql.com for documentation on
mysqldump.
If your webhost lets you use mysql from the command line, here is a
general example, assuming your database is named 'foo':
//On your local server
mysqldump -u user -p foo > dumpfile.sql
[enter password]
//On the remote server
[create a database named 'foo']
[upload dumpfile.sql]
mysql -u user -p foo < dumpfile.sql
[enter password]
You'll need the first part to generate the dumpfile whether you use
CPanel or not.
hth
--
Bulworth :
fu***@fung.arg | My email address is ROT13 encoded, decode to mail
--------------------------|--------------------------------------------------
<http://www.phplabs.com/> | PHP scripts and thousands of webmaster resources!