Sql backup import issues.

Discussion in 'MySQL' started by Demon fox, Nov 12, 2009.

0
  1. #1
    I'm trying to import 2 datatbases using bigdump.php and get my old site that was working on another host ages ago up again. There are 2 database backups which both get errors in.

    My old server version was Server version 5.0.81-community
    The current server version is 5.1.30

    I need help to get these working.

    I get the following error from the wordpress sql backup:
    
Error at the line 1018: DELIMITER ;;

Query: --
--
DELIMITER ;;

MySQL: 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 'DELIMITER' at line 3
    Code (markup):
    My vbulletin sql backup which I try to import gets the following error:

    
Error at the line 3008: /*!40101 SET character_set_client = @saved_cs_client */;

Query: /*!40101 SET character_set_client = @saved_cs_client */;

MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
    Code (markup):
     
    Demon fox, Nov 12, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Did you try with a single semicolon?

    delimiter ;

    You can't set a delimiter using the current delimiter.
     
    jestep, Nov 12, 2009 IP
  3. Demon fox

    Demon fox Active Member

    Messages:
    703
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    78
    #3
    Ok after getting rid of the extra semi colon I now get this error

    
Error at the line 7: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

Query: -- MySQL dump 10.11
--
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL: 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 '-- MySQL dump 10.11 -- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET' at line 1
    Code (markup):
     
    Demon fox, Nov 13, 2009 IP