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.