Title: Database import error phpmyadmin
Last modified: August 20, 2016

---

# Database import error phpmyadmin

 *  [Andyboyag](https://wordpress.org/support/users/andyboyag/)
 * (@andyboyag)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/database-import-error-phpmyadmin/)
 * I have a current running site with no apparent database issues. I am moving to
   a new host and for that I am following the procedure for moving a wordpress installation.
   It has worked well for all my sites except 1. For this specific site when I use
   a plugin to backup the database and import it on the new host I get an error:
 * —-BEGYND KLIP—-
    eNpzDQryD7JScDZUcDZS8HH1s1IwUjBWMLfkCg4BCstzcflWBgf6WCmY6hnqmVjqGuvm5KdzhQYH
   KfgH6yg4urv6hegohLkClYZn5ikEO7o5BnkC1RromRqbcgX4OlopGOuZ6Bka6BlyBXgEgFTq+AeD 
   TDPSM1PwycwrreDycfRzt1JISeQC28PFJd/NwQAGzG/+RpffjpimlphbYN2lll5iXf6va+q5iZJl 
   Wzke1k001tukcrvox7RJMtPXnFjIwjmhhYOJJ0bj8tXQxXHf+F9s/H543fZ37Wfulh678fylWk6J 
   9ZGbz9ea/uq/om9ZfG4rwyQFj4kiqqf53JblZjJGXN/5bNbn6M+frAGiN1+g —-SLUT KLIP—- —-
   BEGYND RÅ—- ERROR: C1 C2 LEN: 2 3 79 STR:
 * MySQL: 5.1.49-3-log
    USR OS, AGENT, VER: Win SAFARI 5.0.535 PMA: 3.4.10.1 PHP
   VER,OS: 5.2.6 Linux LANG: da SQL:
 * ���[w�X�&�>w���Αv��~�3.�$�r�����ȡ �� \(��U�^����î�����u����<����5���/9sε� H�%
   �F�miX׹���[��;
    —-SLUT RÅ—-
 * SQL-forespørgsel:
 * ���[w�X�&�>w���Αv��~�3.�$�r�����ȡ �� \(��U�^����î�����u����<����5���/9sε� H�%
   �F�miX׹���[��;
 * MySQL returnerede:
 * #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 ‘‹’ at line 1
 * If I try to manually export the database from phpmyadmin on the old host without
   the plugin I get another error when importing through the phpmyadmin interface
   on the new host – that is:
 * CREATE DATABASE `name_of_database_on_old_server` DEFAULT CHARACTER SET latin1
   COLLATE latin1_swedish_ci;
 * MySQL returnerede:
 * #1044 – Access denied for user
 * What can I do?

The topic ‘Database import error phpmyadmin’ is closed to new replies.

## Tags

 * [database import error](https://wordpress.org/support/topic-tag/database-import-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Andyboyag](https://wordpress.org/support/users/andyboyag/)
 * Last activity: [14 years, 1 month ago](https://wordpress.org/support/topic/database-import-error-phpmyadmin/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics