help import database using phpmyadmin

I want to impot a database to mysql using phpmyadmin...

I have a file that has the database data , the data looks like this

id name type number code

3158 West Yorkshire hjd 237 dc

358 te Yorkshire fc 35 re

How do i import this using the phpmyadmin ?

I tried:

Columns separated with: \t

Columns enclosed with:

Columns escaped with: \

Lines terminated with: \n

and marked v on "The first line of the file contains the table column names"

When i do this i get this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

i need someone to help me import the data

Taidot: MySQL, PHP

Näytä lisää: using re, 3158, help & manual, import database, get sql help, php sql syntax error, 1064 php, mysql help table, sql syntax error, php mysql 1064, import sql database mysql, mysql sql syntax, phpmyadmin error, mysql data import, phpmyadmin mysql, sql syntax, error 1064, help manual, yorkshire, mysql error 1064

Tietoa työnantajasta:
( 22 arvostelua ) rome, Israel

Projektin tunnus: #6255733

Myönnetty käyttäjälle:


Hi mate.. Its simple one.. Can finish in 20 mints. U need solutions / ideas now or myself to fix this.. If myself, please provide me the database access now.. I will export data and let you know.. Thank Lisää

$25 USD 1 päivässä
(118 Arvostelua)

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


A proposal has not yet been provided

$210 USD 1 päivässä
(405 arvostelua)

Hi, I'm a PHP and MySL expert and would gladly help you import your database into your phpmyadmin. I'll be correcting any error that I can find on your curent file. Looking forward to getting some feedback from y Lisää

$30 USD 1 päivässä
(212 arvostelua)

as discussed as discussed as discussed as discussed as discussed as discussed as discussed as discussed

$138 USD 0 päivässä
(80 arvostelua)

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat by replying..

$37 USD 1 päivässä
(45 arvostelua)

Hi, I will import it instantly. you first need to store it in proper csv file or needs to write it in csv using tab separated. i can do it using php script, i have that script. I am joomla, virtuemart expert having Lisää

$25 USD 1 päivässä
(120 arvostelua)

9 years old web development company working with Finland base [login to view URL] we want to grow our company more so started searching new businesses from Freelancing sites. please check our portfolio [login to view URL] Lisää

$29 USD 1 päivässä
(14 arvostelua)

A proposal has not yet been provided

$25 USD 1 päivässä
(32 arvostelua)

6+ years of web development experience, here. I look forward to talking to you more about this project Thanks, Ryan

$30 USD 0 päivässä
(12 arvostelua)

Hello I assure you that i can do your job perfectly in time . I have overall 9 years experience Regards

$25 USD 1 päivässä
(8 arvostelua)

Hello Sir, How are you?. I am able to do this [login to view URL] you send me the sql file then i can show you to imported successfully. Ready to start right now. Thank you. Regards, Keval Thacker

$15 USD 0 päivässä
(25 arvostelua)

please let me know if you need help. .

$35 USD 3 päivässä
(14 arvostelua)

Hi, I'm Ing. of systems With over 10 years of experience developing large-scale applications and providing web technology solutions for freelancers , small, medium and large businesses. experience working with the p Lisää

$30 USD 3 päivässä
(4 arvostelua)

A proposal has not yet been provided

$20 USD 0 päivässä
(9 arvostelua)

Hi,I am expert php programmer and Mysql query writer.I debugged these kind of DB import problems many [login to view URL] forward to your reply.

$20 USD 1 päivässä
(5 arvostelua)

Hi, I need access of phpmyadmin to import database Please provide extra details Waiting for your positive response Thank you, Vipul

$15 USD 1 päivässä
(9 arvostelua)

Hey, I am a core MySQL DBA and Performance optimization expert. I am a tech speaker and a blogger too ([login to view URL]). I can import the txt/csv file to your MySQL server without a data loss.

$20 USD 1 päivässä
(2 arvostelua)

Hi sir. Thank you for your post. I am a manager of website development team that has 3 developers, and they have gained enough experiences in MYSQL and PHP. I am very interesting in your task. Our team can satisfy Lisää

$20 USD 1 päivässä
(1 arvostelu)

I have already done this kind of job and i have good expertise over mysql , i can complete your task within few hours . And also further we can have talk on PM .

$20 USD 1 päivässä
(1 arvostelu)

We have a great experience in [login to view URL] a qualified team for shopping cart. We can make this project with in $450. my Skype contact is [login to view URL],if you want to contact with me directly then please cal Lisää

$30 USD 3 päivässä
(0 arvostelua)

Hi, I can help you with this. please share the import command you are using as well as file file is required to find out column delimiters used in the file. error suggest that there is an extra parenthesis reg Lisää

$30 USD 1 päivässä
(0 arvostelua)