Community Q&A:
Importing HTML into a MySQL database.
Hi,
I've been trying to import a table from a csv file into a MySQL database online using phpMyAdmin. Some of the fields in the csv file contain html and when imported all the html special characters are converted to their equivalent character entities. For example, ' characters when importing to a MySQL database in cPanel? I have tried different types of file format and escape characters without success and have noticed the conversion does not happen when I perform the same import using the phpMyAdmin on my own computer. I also didn't (yet) find any reference to this conversion in the MySQL manual.
Thanks.
I've been trying to import a table from a csv file into a MySQL database online using phpMyAdmin. Some of the fields in the csv file contain html and when imported all the html special characters are converted to their equivalent character entities. For example, ' characters when importing to a MySQL database in cPanel? I have tried different types of file format and escape characters without success and have noticed the conversion does not happen when I perform the same import using the phpMyAdmin on my own computer. I also didn't (yet) find any reference to this conversion in the MySQL manual.
Thanks.
ANSWERS
|
0
|
Hello BeeGee, and thank you for your question. This could be a bit hard to troubleshoot without seeing the actual file itself to get a better understanding of exactly what's going on. As a first resort I might recommend trying to export your MySQL database in phpMyAdmin to a .sql file on your local machine, since it sounds like you're not having issues with importing the data as a CSV file there. Then on our server you can try to import your MySQL database in phpMyAdmin with that .sql file. If that doesn't do the trick for you, please send your database backups in to us at docs@webhostinghub.com as an attachment so that we can take a closer look at it for you. Please include the subject "Importing HTML into a MySQL database", and then respond back to this question once you've mailed it in so we know to go look for it. I hope the first option works for you, but if not we'll try to get things squared away for you. - Jacob |
Want to share this Question?
Tweet
Help Center Login
Related Articles
It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
