Mac characters showing up weird when importing to sql

Category: Databases

diannesz
Asked:
2012-10-06 11:06 am EST

Hits: 430
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.

OTHER ANSWERS

0

Scott
Staff
19,412 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 support@inmotionhosting.com 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?

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!
Ask a Question

Need more Help?

Search

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: support@InMotionHosting.com
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!