forums › forums › SQLyog › SQLyog Comments › Error importing in v3.6 RC5
- This topic is empty.
-
AuthorPosts
-
-
October 6, 2003 at 11:32 am #8198HughesMember
When exporting as a batch file in v3.6 RC5, the resulting file does not include any delimiters. I exported using all of the default settings and the file it creates is one continuous string.
Also, I would recommend changing the font for the columns in the search result list back to its predecessor. The headers in v3.6 RC5 do not look good, even after turning off truncating. I have included the following graphic to show you the difference in what I'm talking about. The top graphic is v3.52 and the bottom graphic is v3.6. I think you'll agree that the top one looks better.
-
October 6, 2003 at 1:27 pm #15022ShadowMember
Exporting data as batch file does not result in a file with delimiters. Most likely you meant exporting data as CSV file. Exporting data as batch file feature works as expected for me!
But exporting data as CSV with the default settings does not produce usable output. If I try to import the data exported with the default settings, then the import fails with err. no 1064 (syntax error)…
-
October 6, 2003 at 3:19 pm #15023HughesMember
Yes, I meant to say CSV file, not a batch file.
Based upon your comment, are you acknowledging the bug?
-
October 6, 2003 at 4:19 pm #15024RiteshMember
Greetings
You can change the FONT for ResultWindow using Tools -> Preferences… Change the font for Data/Display Editor Font.
Can you tell me the delimeters you are using to Export data as CSV. A screenshot of the Escape Character will be quite helpful? It will be very nice if you can attach a sample CSV file that was generated using SQLyog.
-
October 6, 2003 at 5:38 pm #15025RiteshMemberQuote:When exporting as a batch file in v3.6 RC5, the resulting file does not include any delimiters. I exported using all of the default settings and the file it creates is one continuous string.
This is because by default SQLyog uses 'n' for LINE TERMINATION. Windows based editors like Notpad require 'rn' for LINE TERMINATION.
Change the LINE TERMINATED BY…. value to 'rn' and everything will be OK.
HTH
-
October 6, 2003 at 7:33 pm #15026HughesMember
Ritesh…there's definitely a bug here. A default export to CSV and then a corresponding import results in an error (detailed in Shadow's response).
I'll double-check the error that I saw when I get home tonight. The one thing I know for certain is that the CSV file generated in v3.52 looks different than the file in v3.6 RC5 when opened in Edit Plus (a notepad hybrid).
*By the way, thanks for the UI tip. I've got everything looking like the prior version now.
-
October 7, 2003 at 4:07 am #15027RiteshMember
You can download SQLyog 3.6 RC6 at http://www.webyog.com/sqlyog/SQLyog36.exe
Make sure that you are giving the correct ESCAPE SEQUENCES…. while importing and exporting data.
Quote:that the CSV file generated in v3.52 looks different than the fileAre you giving the same ESCAPE SEQUENCES… in both the versions?
-
October 7, 2003 at 6:48 am #15028ShadowMember
The problem is that the DEFAULT settings of the CSV export are not OK, they produce such an output which cannot be re-imported by MySql's LOAD DATA INFILE command. The default export parameters (and the imports' as well…) should be changed to a valid format!
-
October 7, 2003 at 9:54 am #15029RiteshMember
Any suggestions?
-
October 7, 2003 at 11:19 am #15030HughesMember
The “Terminated By” for fields value, by default, is set to NONE, Terminated By for Lines is set to NONE, and the ESCAPED by value is set to NONE. The default settings should be set up as it was in its predecessor:
- Terminated By (fields): t
- Terminated By (lines): n
- Escaped by: \
Currently, by default, import and export is broken. I have confirmed this continues to be a defect in RC6.
-
October 7, 2003 at 11:37 am #15031ShadowMember
I confirm Hughes' report and absolutely agree with his solution!
-
October 7, 2003 at 1:45 pm #15032RiteshMember
The default settings were changed in RC6.
It is not being reproduced in your machine because the values in sqlyog.ini has been changed to
, , . Please remove the [CSVESCAPING] section from sqlyog.ini in the SQLyog installation directory. When you execute SQLyog again, it will revert back to default values. Persistence of last values is a new feature in SQLyog 3.6, therefore it is reading from sqlyog.ini which has the incorrect value.
Otherwise, you can change the settings once and the values will be maintained 🙂
HTH
-
October 7, 2003 at 2:39 pm #15033HughesMember
Ritesh…I have confirmed this is working now. Thanks!
-
October 7, 2003 at 3:11 pm #15034RiteshMember
Thanks 🙂
I can be assured that CSV Import/Export are working perfectly.
Have your tried the Data Synchronization Tool?
-
October 7, 2003 at 5:43 pm #15035HughesMember
I haven't tried it yet. However, I do have a pair of DBs that need synching. I'll take it for a test drive tonight and post my thoughts later.
-
October 7, 2003 at 6:51 pm #15036RiteshMember
Waiting for your comments…..
-
October 8, 2003 at 12:15 am #15037HughesMember
Bad news. Found some more bugs:
1. If you enter a value in Export to File field on the Export Data window, the value persists after you have closed the window. This parameter should be cleared out (as it was in prior versions) since you don't want people accidentally overwriting a prior export file.
2. The DB synch does not appear to be working. I created an exact copy of a table in my current DB and then created a new DB that contained that table. I then updated a single record in the current DB. When I went to synch the two DBs, it issued an error msg stating that no differences between the tables could be found. Shadow…can you back me up on this one?
The ball is back in your court. Happy bug hunting. 😉
-
October 8, 2003 at 4:47 am #15038RiteshMember
Can you copy/paste the CREATE TABLE… stmt for both the table?
SQLyog logs all the errors in sja.log, that can be found in the installation directory of SQLyog. Can you paste the contents of the file here.
-
October 8, 2003 at 5:53 am #15039RiteshMember
It will be even better if you could attach SQL Scripts of both the databases 🙂
-
October 8, 2003 at 5:53 am #15040RiteshMember
BTW, are you sure that the order of COLUMN in the PRIMARY KEY definition are same?
-
October 8, 2003 at 2:27 pm #15041HughesMember
I'll get to it tonight.
What about the other bug I documented?
-
October 8, 2003 at 2:27 pm #15042RiteshMember
The Export Dialog.. will ask for confirmation before overwriting any file 🙂 ( Thats not a bug actually, it was by design )
Waiting for the SQL scripts 😀
-
October 9, 2003 at 6:59 am #15043ShadowMember
Well, Hughes, bad new for you, the data sync tool works perfectly for me… Even if only a few records have been changed in the source db.
Ritesh, could you enlarge the textbox that displays the result of the synchronization session?
-
October 9, 2003 at 6:59 am #15044ShadowMember
I meant bad news, not new…
-
October 9, 2003 at 11:38 am #15045HughesMember
Another bug:
1. I have “Truncate columns to max data size” preference unchecked. However, when I execute my query, the column widths are not adjusting to the size of the column name (as it did in previous versions). See graphic below for details.
-
October 9, 2003 at 11:41 am #15046HughesMemberRitesh wrote on Oct 8 2003, 01:53 AM:BTW, are you sure that the order of COLUMN in the PRIMARY KEY definition are same?
Yes, the PK value is the same.
Attached is the create table script. Please let me know when you have it so I can remove it.
Also, if you need a video on this one, let me know.
-
October 9, 2003 at 11:41 am #15047HughesMember
I'm going reply-crazy this morning! 😉
Another bug:
If I perform an export table as batch script and then perform a second export, the file is overwritten. I am not prompted to rename the file as was stated earlier in the post.
-
October 9, 2003 at 5:17 pm #15048RiteshMember
The SQL file lists only the structures of one database. Can you send me the backup script of the both the databases as it is in your server. We can restore it on our server and run a sync on both the databases.
Quote:If I perform an export table as batch script and then perform a second export, the file is overwritten. I am not prompted to rename the file as was stated earlier in the post.The RC that has this feature has not been released. We are waiting for your Sync bug report before we release our next RC.
HTH
-
October 9, 2003 at 5:18 pm #15049HughesMember
I'm feeling the pressure now. 🙂
I'll get you the other half tonight. BTW, what am I getting paid for my testing services? 😉
-
October 9, 2003 at 11:46 pm #15050HughesMember
Attached is a single script that contains the CREATE statements for both tables. I trust this is what you're looking for in your previous request.
-
October 10, 2003 at 1:09 am #15052RiteshMember
Can you cut/paste your output here?
A video file will be even better?
-
October 10, 2003 at 1:12 am #15051RiteshMember
Greetings
I restored the given database in my server and ran the sync tool. Everything seems to be fine. Here is the output –
Code:SQLyog Job Agent Version 1.0
Copyright (c) Webyog. All Rights Reserved.Sync started at Fri Oct 10 06:36:07 2003
Table            SrcRows  TgtRows  Inserted  Updated  Deleted
========================= Â ======= Â ======= Â ======== Â ======= Â =======
`points_allowed` Â Â Â Â Â Â Â Â 0 Â Â Â Â 0 Â Â Â Â 0 Â Â Â Â 0 Â Â Â Â 0Total time taken – 0 sec(s)
-
October 10, 2003 at 11:16 am #15053HughesMember
Maybe I'm using it improperly. In my test, I changed a single value in a column, committed it, and then ran the sync tool. Should it detect the difference between the two tables?
Also, what's the word on the column truncate problem. The check box does not work.
-
October 10, 2003 at 11:40 am #15054RiteshMemberQuote:Should it detect the difference between the two tables?
Yes 🙂
Can you cut/paste the messages out here? What does sja.log says?
-
October 10, 2003 at 11:51 am #15055HughesMember
I'd love to. Unfortunately, I cannot locate the sja.log file. Its not in the SQLYog folder.
-
October 10, 2003 at 1:17 pm #15056RiteshMember
Can you upload a video capture of the steps you are following?
-
October 10, 2003 at 1:34 pm #15057HughesMember
For your viewing pleasure.
Also, can you please give me a heads up on the truncating problem?
-
October 10, 2003 at 1:49 pm #15058RiteshMemberQuote:Also, can you please give me a heads up on the truncating problem?
The reason remains the same. We have still not released the RC that has this problem fixed. It was reported by your earlier and we have fixed it in the next upcoming release.
BTW, sja.log is created in the installation directory. I am attaching a snapshot of my SQLyog directory. Your directory should have the files shown in the image.
-
October 10, 2003 at 2:03 pm #15059HughesMember
Sorry about the truncating thing…its been a long week for me.
At any rate, no log file is created. Worth noting is that I still have previous versions of the software on my PC (but installed in a different directory). Here is my screen capture:
-
October 10, 2003 at 2:05 pm #15060RiteshMember
Went thru the video. Even the .sql file given by you tells that the structure are same.
Running, SJA on the tables results in correct output as shown above. I belive there should not be any problem.
Can you cut/paste the information that is given by Sync Wizard at the last page. I am attaching a snapshot of my last page after I ran the sync tool on the tables provided by you.
BTW, if the data is not very sensitive can you send me a backup of the data so that I can try out the sync tool on it?
-
October 10, 2003 at 2:13 pm #15061HughesMember
When I run it using the wizard, everything works! But that leaves me with a question: What is the purpose of that screen I showed in the video? Should it result in the same results?
-
October 10, 2003 at 2:34 pm #15062RiteshMemberQuote:What is the purpose of that screen I showed in the video? Should it result in the same results?
The option that is shown in video brings STRUCTURES of two databases in SYNC with each other and not DATA. The Tools menu specifies them as –
- Database Synchronization Wizard
- Schema Synchronization Tool
respectively.
-
October 10, 2003 at 2:39 pm #15063HughesMember
Sorry about that. I'm new to the sync features. However, now that I've used it, I love it!
Do you have an ETA for the next RC release?
-
October 13, 2003 at 7:18 am #15064ShadowMember
SQLyog does not create the sja.log file in the install directory. The sja.log is created in the folder that was last used for saving anything (jobs, data exports…) to HD or to load anything from HD. If that folder is the install folder (default), then SQLyog creates it there, otherwise no.
-
October 13, 2003 at 8:00 am #15065RiteshMember
sja.log is created in the current directory of sja.exe ( if you are running Sync tool thru SQLyog, it will be in the same directory ).
sja.log is nowhere related to the last used directory.
Delete sja.log from the Installation directory of SQLyog and run the Sync tool. You will see that sja.log was created in the same directory.
-
October 13, 2003 at 8:36 am #15066ShadowMember
I'm sorry Ritesh, but SQLyog always creates the sja.log file in the last used folder for me! I just made SQLyog to place one in MS's Visual Studio's root folder… It's got nothing to do with the location of sja.exe!
-
October 13, 2003 at 2:15 pm #15067RiteshMember
I will work on it.
-
October 13, 2003 at 6:10 pm #15068HughesMember
I concur with Shadow. My sja.log file is stored to my Desktop. I have the shortcut to SQLYog stored there.
-
October 13, 2003 at 6:11 pm #15069RiteshMember
GOTCHA !!!!
I will release RC8 sometime tomorrow, that will have this bug fixed.
THANK YOU !!!
-
October 15, 2003 at 5:44 pm #15070RiteshMember
SQLyog RC8 has been released that has all the bugs regarding column width, sja.log etc fixed. Try it out at http://www.webyog.com/sqlyog/SQLyog36.exe
HAPPY YOGGing….
-
October 17, 2003 at 11:35 am #15071HughesMember
RC8 is very nice. The updated icons look GREAT. I did find one bug that was previously fixed:
The default settings for exporting have been reset to NONE. It should be:
- Terminated By (fields): t
- Terminated By (lines): n
- Escaped by: \
-
October 17, 2003 at 11:37 am #15072HughesMember
Here is a screen grab to demonstrate what I'm talking about:
-
October 17, 2003 at 2:27 pm #15073RiteshMember
It is happening because those values are present in SQLyog.ini ( as there was a bug in the previous version ).
Just delete SQLyog.ini from the installation directory and restart SQLyog. SQLyog will take up the default values.
HTH
-
-
AuthorPosts
- You must be logged in to reply to this topic.