Hy, i want to upload my inovision posts datapase on news server ad i have difficulties. i used
LOAD DATA LOCAL INFILE "/home/hraweba/public_html/forum/backup/ib_posts.sql" REPLACE INTO TABLE ib_posts FIELDS TERMINATED BY ',';
but my fields have mixed.
I edited sql file in wordpad, so maybee i need to change fields terminated by?
Whith what?
This is one example of one line that i need to insert
INSERT INTO ib_posts VALUES ('',NULL,303,1,'Ivan Milisic','','1','195.29.32.235',1051480097,'',' Ovako, radi se o jednoj novoj zamisli zax-a i markusa.\r<br>Oni bi avartare kao sa hr-a.com, tj sa koolarts.co.uk znaci onakve slicice kakve markus ima sada\r<br>Ja bi da ostanemo na slikama, vise je personalizirano, bolje mi djeluje, vidis tocno kakav je auto itd.\r<br>Glasajte ','',49,2,NULL,NULL,NULL,NULL,'Avartari','',NULL);
INSERT INTO ib_posts VALUES ('',NULL,303,1,'Ivan Milisic','','1','195.29.32.235',1051480097,'',' Ovako, radi se o jednoj novoj zamisli zax-a i markusa.\r<br>Oni bi avartare kao sa hr-a.com, tj sa koolarts.co.uk znaci onakve slicice kakve markus ima sada\r<br>Ja bi da ostanemo na slikama, vise je personalizirano, bolje mi djeluje, vidis tocno kakav je auto itd.\r<br>Glasajte ','',49,2,NULL,NULL,NULL,NULL,'Avartari','',NULL);
Help please
