Menu

#2 Data Insert lines dumped incorrectly.

open
nobody
None
5
2003-01-29
2003-01-29
Anonymous
No

After SQL dump has dumped my database I am getting:

Insert into lasttableindb (field1, field2, field3, etc)
values (wrong1, wrong2, wrong3, wrong4, etc)

Basically what is happening is it's creating the insert
lines with the last table name in the DB & it's correct
fields. This obviously does not work. I'm wondering
if I am doing someting wrong since no one else has
posted anything about this.

I am using v3beta.

Matt

Discussion

  • Matt

    Matt - 2003-01-29

    Logged In: YES
    user_id=699592

    I post the inser line incorrectly. what is actually
    happening is the fields are incorrect & do not correspond to
    the database.

    insertinto table (wrongfield1, wrongfield2, wrong field3, etc)
    values (value1, value2, value3, value4, etc.)

    that is more like what is happening.

    Matt

     
  • Matt

    Matt - 2003-01-29

    Logged In: YES
    user_id=699592

    Problem does not seem to occur when done through the wizzard.

    Command line I am using:

    sqldump -h localhost -u sa -p canttellyou -D -F c:\mydb.sql
    testdbdump

    Matt

     
  • Paul Sokolovsky

    Paul Sokolovsky - 2005-02-05

    Logged In: YES
    user_id=11970

    Ok, I hit this too, and made a patch:
    http://sourceforge.net/tracker/index.php?
    func=detail&aid=1116842&group_id=45686&atid=443721 .
    Binary is attached also (at your own risk).

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.