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
     
  2. Ben

    Ben ISPConfig Developer ISPConfig Developer

    Could you show this last block from the dump (the last line ending with "NOT NULL")?
     
  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.

     
  4. Ben

    Ben ISPConfig Developer ISPConfig Developer

    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

     
  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.
     

Share This Page