Results 1 to 9 of 9
  1. #1

    * Getting error while restoring database.

    SQL query:

    /*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;

    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 ';
    UNLOCK TABLES;

    --
    -- Table structure for table `qhvbmailer_campaigns`
    --

    DRO' at line 1

    Can any one please help me.

  2. #2
    the error speaks by itself

    you have a syntax error and it says where
    Server Surgeon George
    http://www.serversurgeon.com
    Linux, BSD and Windows Administration Services
    Toll Free US 877-378-7436 International +1-213-291-9191

  3. #3
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Quote Originally Posted by kingofdevils View Post

    --

    --

    DRO' at line 1

    Can any one please help me.[/B]
    Are you trying to restore a database backup file taken from a higher mysql version on a 4.0 server?
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  4. #4
    plz explain wht exactly is to be done.

    wht to edit in database.

    Kindly help me.

  5. #5
    Anyone plz help..

  6. #6
    Join Date
    Feb 2005
    Location
    Australia
    Posts
    5,842
    Open the sql file in a text editor (not Word / Wordpad etc.) and make sure there are no invisible special characters at the beginning.
    Chris

    "Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter

  7. #7
    Join Date
    May 2006
    Location
    India
    Posts
    661
    It seems like you are trying to restore the db on a newer version of mysql server. Please check whether the syntaxes of your sql backup server ( on which the backup file is generated ) and sql server ( on which you trying to restore ) are compatible.
    SparkSupport.Com - The Premier Tech Company
    Cloud Solutions|Email Infra setup|VOIP|Video Streaming|Software Development
    Email: [email protected] Phone : 1- 408-600-1449 | Skype : shijils

  8. #8
    Join Date
    Jun 2007
    Location
    Tokyo, Japan
    Posts
    333
    You would have to tell us:
    1) Version of your current MySQL Daemon
    2) Version of your previous MySQL Daemon
    Yudai Yamagishi

  9. #9
    Join Date
    Jan 2008
    Posts
    34
    You need to tell the default character set also.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •