• 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)
  • May be you have not downloaded database correctly or some database permission issue.

    Try to upload on other database server..

    Thread Starter phidippides

    (@phidippides)

    Thanks – I just tried to upload it to a new database on the same server as the original was on, and I got the same error #1064:

    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 '' at line 1

    I do recall a few months ago that my site went a bit haywire, and I think there was a problem with the database that had to be repaired. Would it benefit me to uninstall/delete as many plugins as I can and then more the database?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL error #1064 on migration to new server’ is closed to new replies.