I have recently created a database using Microsoft Access 2010. I tried to import this website compatible database to the WordPress using XAMPP for Windows. The WordPress is hosted at http://localhost/wordpress/wp-admin which has been successfully setup in my computer.
Everything in the WordPress is fine except that it is not allowed to import my said database into the WordPress. The WordPress has the functionality to import databases from outside. And it has MySQL embedded.
From XAMPP Control Panel ->phpMyAdmin->Database->Import ?€??€?->Choose ->theDatabase->GO, it should import the database correctly.
However, when I tried to import the said database, there is an error message saying: ?€?You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ?€? ?€? at line 1?€?. The strange signs as appeared here are also questions: what are they and how do they come and why not they are solved in the first place?
The MySQL server version I am using is: 5.5.8. My computer operating system is Windows 7 Home Premium.
After failure of attempts to find the right solution to the problem, I have to report and publish this issue, hoping that this problem can be solved as soon as possible.
I wonder if this is a bug or something that is beyond understanding right now. Would you please offer solutions and guidance. Thanks.
The blog I need help with is lajiwangba.wordpress.com.