Importing HTML into a MySQL database.

Asked by:
BeeGee / 8 Points
Time:
2013-01-09 1:00 pm EST
Category:
Databases
Hits:
460
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.

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

JacobN
Staff
3,661 Points
2013-01-09 1:14 pm EST
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

To submit a comment on this answer, please first login.

Want to share this Question?

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.