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


How to import mysql databases from text files?





Philip
How to import mysql databases from text files?
i try to using this code
Code:

LOAD DATA LOCAL INFILE 'c:\\kp.txt'
INTO TABLE datakp
FIELDS TERMINATED BY '<TAB>'
LINES TERMINATED BY '\n'


now i am confused because my phpmyadmin only import 88 rows from 4296 rows, is there something wrong in my mysql ? or what ?? --"

and i am using this code because is local, but when using it on mysql how can i uses this code for webserver mysql ? i mean how to call this code so execute import my data ??
hexkid
Philip wrote:
How to import mysql databases from text files?
i try to using this code
Code:

LOAD DATA LOCAL INFILE 'c:\\kp.txt'
INTO TABLE datakp
FIELDS TERMINATED BY '<TAB>'
LINES TERMINATED BY '\n'


Hmmm ... shouldn't this be
Code:
LOAD DATA LOCAL INFILE 'c:\\kp.txt'
INTO TABLE datakp
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'


Other than that I have no ideas? Did you receive an error message?
Philip
no there;s no error messages,
but i already founded why can that be ,

i have nim primary key coloumn,
and there's a 2 value in nim's row --"
haha what su...

btw thanks for your help, i am very2x stressed lately.
Related topics
Free Hosting-Availability
PHP without mySQL
Help me to Import mysql databases from web into home pc !
The noob needs help/Plz
Need help with database, can anyone help?
protecting mysql databases from sql injection attacks
MySql Databases
Visual Basic Tutorial - File I/O in VB: Text Files
Export and Import Mysql Table
Can't create or alter name of MySQL databases
mysql databases
vBulletin installation: Files upload, Database setup
PHP.ini and MYSQL databases
NotepadTabs Work With Multiple Text Files
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.