problems importing a database into mysql

Discussion in 'Server Operation' started by Ovidiu, Jul 31, 2006.

  1. Ovidiu

    Ovidiu Active Member

    trying to export a db from one server and import on another. both servers are debian 3.1 and running MySQL version 4.0.24
     
    Ovidiu, Jul 31, 2006
    #1
  2. Ben

    Ben Active Member Moderator

    Could you show this last block from the dump (the last line ending with "NOT NULL")?
     
    Ben, Jul 31, 2006
    #2
  3. Ovidiu

    Ovidiu Active Member

    here is the sql dump right from the start:

    I just realized this part only concerns one plugin, which I could easily take out from my dump, I will try without that part.

     
    Ovidiu, Jul 31, 2006
    #3
  4. Ben

    Ben Active Member Moderator

    the old problem, when using reserved words in column names, and thei are not wrapped ind ` (backtick) as the normal mySQL Syntax is.... good example for that when germans design their tables is "alter"...

    So just change
    to

     
    Ben, Jul 31, 2006
    #4
  5. Ovidiu

    Ovidiu Active Member

    thx for analyzing the problem, I have no clue about mysql, this whole structure is wordpress (a plugin for it created that problem :)

    I seem to have succeeded by deleting that old plugin and its tables and all of its data that it created inside the DB.
     
    Ovidiu, Jul 31, 2006
    #5

Share This Page