Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to upload ready MySQL table?

Status
Not open for further replies.

Mury

Programmer
Nov 15, 2002
3
BG
Hello,
I am new in database programing and still learning.
For the present moment I have one ready and fill with data table and now I wont to upload it to my Web server.
The problem is that I don't now how to this task.
I can create table trought the admin panel of my site, but what should I do next I do not know.
Tell me how to upload ready full table, thank you in advance.
Have a nice weekend
 
You can't upload an local MySql table to a remote server. I may be mistaken, and I hope I am, but I know that I can't do it with my ISP. You'll have to create a query to load the data onto your server. You'll probably have to convert your local table to a txt or csv file, upload that, then import it into the server table. There's always a better way...
 
well, you can upload the complete table, but must have access to the mysql datadir, both on local and remote server
on the remote server you'll probably need to restart the server afterwards
 
It's OK now.
Finally I've call to my server administrator and he done this task for seconds.
He ask me only to copy the 3 files of the table to into the server and then using his SSL connection he just copy and bast the table.
Now my first MySQL database is working :)))
Thanks for your help.
Take care.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top