I created a database and I need to import text data on a table. How can I do this?
I created a database and I need to import text data on a table. How can I do this?
Head to phpMyAdmin through cPanel and select the appropriate database.
Then click on the IMPORT tab and upload your text file.
Best regards,
Brian Yang - TechAirlines
How am I doing? Click thestar button at the bottom left to rate this post. Thanks.
Terms of Service | Account Portal | Wiki
This is the first thing I did but it doesn't work because the text file has not sql sentences, only text to insert into my table. Beside, using Import command I can't choose the table where the text must to go.
I also tried with "load data local infile ..." command from select window... and got another error message.
---------- Post added at 08:24 PM ---------- Previous post was at 06:42 PM ----------
Solved!!
I realized I must select the table first, and then import the text file.
Thanks a lot.
Solved
***Thread Closed***
█ Zubair Barkat | Level 2 Tech
█ 888-X10-9668 - zubair[@]x10hosting.com
█ x10Hosting - Giving Away Hosting Since 2004