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?
