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 ?
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
24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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..
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
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.
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 .