Anyone know anything about sql db?

Discussion in 'Application Software' started by Canadian-Wolverine, Feb 18, 2011.

  1. Canadian-Wolverine

    Canadian-Wolverine MDL Junior Member

    Feb 14, 2011
    58
    0
    0
    Hi guys.
    Firstly, if this is in the wrong section, mods, i apologise and please move it to where you see fit. just couldnt find a db section.

    OK, so, i am moving my website from an old host to godaddy.
    I am trying to copy the database useing php myadmin.
    I did as it asked, used the sql button, saved it as a csv file.

    On my new host i have created a database and have tried to import the csv file exactly how it said to do it.
    I am getting this error.

    #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 '"1"' at line 1

    Does this mean anything to anyone and how would i fix it?

    Many thanks in advance guys.

    CW
     
  2. Reign_Of_Freedom

    Reign_Of_Freedom MDL Expert

    Aug 1, 2009
    1,263
    447
    60
    Copy and paste the exact line that is throwing the error
     
  3. Canadian-Wolverine

    Canadian-Wolverine MDL Junior Member

    Feb 14, 2011
    58
    0
    0
    Sorry, i know nothing of sql.
    How do i do that?

    what am i looking for?

    Thanks

    CW
     
  4. Reign_Of_Freedom

    Reign_Of_Freedom MDL Expert

    Aug 1, 2009
    1,263
    447
    60
    OK, #1064 corresponds to the line number where the error is. So if you have something like Notepad++ you can open the sql file in Notepad and go to the # it's saying the error is at. For Instance, it might start with something like:

    ALTER TABLE nuke_users ADD user_birthday int(8) DEFAULT '0' NOT NULL;
    or
    INSERT INTO nuke_bbconfig (config_name, config_value) VALUES ('bday_show',1);
    or
    Create_Table blah blah blah

    If you still have issues just upload the sql db and i'll take a look at it.
     
  5. Canadian-Wolverine

    Canadian-Wolverine MDL Junior Member

    Feb 14, 2011
    58
    0
    0
    Hi
    So, line 1064 is this

    417;"1";"AllUsers";"All Huru Users"

    line 1 looks different as the error refers to line 1 too, its the only line with no gaps in letters/numbers

    1;"Default Backup Profile";"[global]


    the db is quiet small (325k) where can i upload it?

    Thanks

    CW
     
  6. Reign_Of_Freedom

    Reign_Of_Freedom MDL Expert

    Aug 1, 2009
    1,263
    447
    60
    #6 Reign_Of_Freedom, Feb 19, 2011
    Last edited: Feb 20, 2011
    Upload it to any File Hosting site and PM me the link.

    @ C-W check your PM box and get back to me.
     
  7. andyxl987

    andyxl987 MDL Novice

    Aug 30, 2009
    5
    0
    0
    #1064 is the MySQL error code - the error is at or near line 1 as you correctly pointed out. There appears to be a missing end quote at the end of the line:
    1;"Default Backup Profile";"[global]"