Database Restore Issue: Character/Syntax error
-
This is a restore of a fully backed up database. I am moving to a new host. The error messege is as follows:
blockquote
—-BEGIN RAW—-ERROR: C1 C2 LEN: 1 2 387
STR: »CVS: $Id: sqlparser.lib.php,v 1.1.1.1 2005/12/15 21:43:01 jhaslup Exp $
MySQL: 4.0.27-max-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.7.0-pl2
PHP VER,OS: 4.3.2 Linux
LANG: en-iso-8859-15
SQL: – phpMyAdmin SQL Dump
— version 2.6.4-pl2
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: May 30, 2006 at 11:50 PM
— Server version: 4.1.18
— PHP Version: 4.3.11
—
— Database:skylerb_wordpress
—— ——————————————————–
—
— Table structure for tablewp_categories
—DROP TABLE IF EXISTS
wp_categories;—-END RAW—-
SQL query:
– phpMyAdmin SQL Dump — version 2.6.4-pl2 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: May 30, 2006 at 11:50 PM — Server version: 4.1.18 — PHP Version: 4.3.11 — — Database:
skylerb_wordpress— — ——————————————————– — — Table structure for tablewp_categories— DROP TABLE IF EXISTSwp_categories;MySQL said: Documentation
#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 ‘DROP TABLE IF EXISTS
wp_categories‘ at line 1
blockquoteNOW, it seems as though we have a syntax error, but a search in the .sql file doesn’t return the problem characters. What can I do?
The topic ‘Database Restore Issue: Character/Syntax error’ is closed to new replies.