Title: Database import impossible using phpmyadmin Last modified: August 20, 2016 --- # Database import impossible using phpmyadmin * Resolved [su1](https://wordpress.org/support/users/su1/) * (@su1) * [14 years, 11 months ago](https://wordpress.org/support/topic/database-import-impossible-using-phpmyadmin/) * I am moving one of my wordpress blogs from a shared server to a dedicated server( both hosted at 1&1). * **I have a problem when trying to import my old database saved as a sql file in my new phpmyadmin.** I get this error message: * > #1064 – 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 ‘ =”1.0″ encoding=”utf-8″?> 1 * Both the shared server and the dedi run mysql 5. * I precise that I use weird characters in my database (french accents, etc…) so maybe the error come from here? * I don’t know what to do, if you need more information about my settings please let me know. * Thanks. Viewing 4 replies - 1 through 4 (of 4 total) * [fonglh](https://wordpress.org/support/users/fonglh/) * (@fonglh) * [14 years, 11 months ago](https://wordpress.org/support/topic/database-import-impossible-using-phpmyadmin/#post-2144823) * that doesn’t look like an sql file, how did you export your data? * Thread Starter [su1](https://wordpress.org/support/users/su1/) * (@su1) * [14 years, 11 months ago](https://wordpress.org/support/topic/database-import-impossible-using-phpmyadmin/#post-2144828) * I used phpmyadmin on my old server, under the “export” tab. * “SQL”-> for output format, Checked “Structure” Checked “Add AUTO_INCREMENT” value Checked “Enclose table and field name with backquotes”. Checked “DATA” checked use “hexadecimal for binary field” Export type set to “INSERT”. * [Michael Bishop](https://wordpress.org/support/users/miklb/) * (@miklb) * [14 years, 11 months ago](https://wordpress.org/support/topic/database-import-impossible-using-phpmyadmin/#post-2144838) * I concur, make sure you are selecting the sql file, and not the export file from the WordPress Tools->Export which would be XML. * Thread Starter [su1](https://wordpress.org/support/users/su1/) * (@su1) * [14 years, 11 months ago](https://wordpress.org/support/topic/database-import-impossible-using-phpmyadmin/#post-2144844) * Well somehow an html file was generated, I don’t know why. I exported my database one more time and it works now. thanks Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Database import impossible using phpmyadmin’ is closed to new replies. ## Tags * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 4 replies * 3 participants * Last reply from: [su1](https://wordpress.org/support/users/su1/) * Last activity: [14 years, 11 months ago](https://wordpress.org/support/topic/database-import-impossible-using-phpmyadmin/#post-2144844) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics