Mac characters showing up weird when importing to sql
Category: Databases
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! :(
OTHER ANSWERS
|
0
|
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 |
Like this Question?
Tweet
Latest Questions
If you need some help, submit your question to our Community!
We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)
Recent Questions
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 |