zillabuggs

Thankyou. I have now managed to import my database. Your help is very much appreciated.

Hi again. I downloaded notepad++ and tried saving and importing the database again. Still getting the same error. Can I ask a stupid question though. To return this error, should these characters actually appear in the database somewhere, as I cannot see them anywhere?

Hi. The save as options I have are: ANSI, Unicode, Unicode big endian and UTF-8. I tried saving it again with the UTF-8 and importing again, but am getting the same message.

I'm very new to this and getting the following error when trying to import database. Below is the content of the message. Any help would be appreciated. MySQL said: #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 SQL query: -- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (i486) -- -- Host: justcatchatcom.fatcowmysql.com Database: wrd_heo6cg7l32 -- ------------------------------------------------------ -- Server version 5.1.53-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

My SQL version is 5.0.91-log.

I am very new to this sort of thing and hope someone can help me out as my site has now been down for 3 days. I have upgraded my wordpress installation to version 3.3.2 I am having a problem uploading my database. I keep getting an error message as follows: ERROR: Unknown Punctuation String @ 1 STR: <? SQL: <?xml version="1.0" encoding="UTF-8" ?> <!-- This is a WordPress eXtended RSS file generated by WordPress as an export of your site. --> <!-- It contains information about your site's posts, pages, comments, categories, and other content. --> <!-- You may use this file to transfer that content from one site to another. --> <!-- This file is not intended to serve as a complete backup of your site. --> MySQL said: #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 '<?xml version="1.0" encoding="UTF-8" ?> <!<!<!<! <!<!<!<!<!<!<!<!<!<!<! <!<rss v' at line 1 This is what the manual says for error 1064 •Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near '%s' at line %d What does this mean and how do I rectify it? Thanks in advance