Data Insert lines dumped incorrectly.
Brought to you by:
askgopal
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
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
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
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).