MySQL error #1064 on migration to new server
-
So I’ve been trying to change servers for a site and keep running into this problem when I try to import the old database using Phpmyadmin:
#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
Here is the beginning of the file:
-- phpMyAdmin SQL Dump -- version 4.0.5 -- https://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 03, 2014 at 01:01 AM -- Server version: 5.1.70-cll -- PHP Version: 5.3.17 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: 'sss_italianren' -- -- -------------------------------------------------------- -- -- Table structure for table 'STATRIX_TABLE' -- DROP TABLE IF EXISTS STATRIX_TABLE; CREATE TABLE IF NOT EXISTS STATRIX_TABLE ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, <code>timestamp</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, ip varchar(39) NOT NULL, request_uri text NOT NULL, agent text, referer text, os text, browser text, rss varchar(12) DEFAULT NULL, spider text, search_engine text, search_terms text, user_login varchar(60) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Thanks in advance for any help!
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘MySQL error #1064 on migration to new server’ is closed to new replies.