Getting #1064 Error In MyPhpAdmin

  • decentguy49

    (@decentguy49)


    12 years, 5 months ago

    I was using a wordpress plugin which makes the backup of your wordpress to your dropbox account, yesterday my wordpress blog gone away, then i try to put it back and try to import SQL back, but while import backup i am getting #1064 error it says :-
    #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 ‘114564’ at line 5
    here is my backup SQL :-
    — WordPress Backup to Dropbox SQL Dump
    — Version 0.9.1
    — http://www.mikeyd.com.au/wordpress-backup-to-dropbox/
    — Generation Time: November 13, 2011 at 01:00

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

    /*!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 */;

    —
    — Create and use the backed up database
    —

    CREATE DATABASE 114564;
    USE 114564;

    —
    — Table structure for table wpau_active_plugins_info
    —

    CREATE TABLE wpau_active_plugins_info (
    id int(4) NOT NULL AUTO_INCREMENT,
    plugin_name varchar(255) NOT NULL DEFAULT ”,
    plugin_status varchar(255) NOT NULL DEFAULT ”,
    plugin_deactive_response smallint(2) DEFAULT ‘0’,
    plugin_reactive_response smallint(2) DEFAULT ‘0’,
    fatal_plugin smallint(2) DEFAULT ‘0’,
    PRIMARY KEY (id)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    Can you plz tell me what is that erro and how to fix it

  • The topic ‘Getting #1064 Error In MyPhpAdmin’ is closed to new replies.

Tags