InMotion Hosting Support Center

Mac characters showing up weird when importing to sql

Category: Databases

2012-10-06 11:06 am EST

Hits: 474
I'm working with a database in MySql on local server via MAMP, and i'm on a mac, when i export the database to import it onto the live server, some characters come out with a black diamond ?.... i have a bunch of items to put in with these characters... quote marks, apostrophes, etc. i'm exporting and importing as UTF-8 or what ever its called, am i doing this wrong? dosen't the .sql file exist somewhere where it can be just copied over? Can i just export the database as CSV, work in excel, and import it back in? Help I'm lost! :(

You must login before you can ask a follow up question.

You must login before you can submit an answer.



43,761 Points
2012-10-08 9:33 am EST
Hello diannesz,

The database collation for the database adn the tables you are importing into will also need to be set for utf-8. Also, you can import either CSV or .sql files into the phpmyadmin. If you are still having issues, please ensure the file you want to import is uploaded to your account and contact our support department at with the specific details of what is showing up incorrectly. Be sure to validate your account with either the last 4 digits of the credit card on file, or the current Account Management Panel (AMP) password.

Best Regards,
Scott M

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Need more Help?


Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!