FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


How to upload CSV and import to MySQL ?





Philip
Can someone teachme how can i upload a csv file to a web server place, and import it into mysql server ?

i ussually used it for local, but never try it yet on online server --".
ussually i used

Code:
LOAD DATA LOCAL INFILE 'c:\\kp.txt'
INTO TABLE datakp
FIELDS TERMINATED BY '<TAB>'
LINES TERMINATED BY '\n'
Philip
Bump this topic up,
does some one read my top messages ?? o.O'
orno
1) bumping is not allowed...
2) can be done through phpMyAdmin... simple enough to figure out how by yourself or google
Philip
wek,s not allowed --" *sorry*
i dont want to using phpmyadmin, because i need to created a panel that upload csv files for a user synchron the databases.

and i didn't found the way at google since, all teach is using phpmyadmin --"
Related topics
Build an online dictionary by PHP/MySQL
SLOW UPLOADING AN SQL FILE
Help me to Import mysql databases from web into home pc !
MYSQL dump
MYSQL import problems
mySql Upload
mySQL set-up on Frihost help please
Trying to restore my discussion board.
Mysql question!
How to import mysql databases from text files?
Export and Import Mysql Table
Help importing CSV file into MySQL database
MySQL Set-up Structure - Help!!!
Can we get Python module mysql.connector installed, please ?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.