Database import error phpmyadmin

  • Andyboyag

    (@andyboyag)


    13 years, 11 months ago

    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.