Error importing in v3.6 RC5

[Hughes]

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.

[Shadow]

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)…

[Hughes]

Yes, I meant to say CSV file, not a batch file.

Based upon your comment, are you acknowledging the bug?

[Ritesh]

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.

[Ritesh]

Quote:

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

[Hughes]

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.

[Ritesh]

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 file

Are you giving the same ESCAPE SEQUENCES… in both the versions?

[Shadow]

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!

[Ritesh]

Any suggestions?

[Hughes]

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.

[Shadow]

I confirm Hughes' report and absolutely agree with his solution!

[Ritesh]

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

[Hughes]

Ritesh…I have confirmed this is working now. Thanks!

[Ritesh]

Thanks 🙂

I can be assured that CSV Import/Export are working perfectly.

Have your tried the Data Synchronization Tool?

[Hughes]

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.

[Ritesh]

Waiting for your comments…..

[Hughes]

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. 😉

[Ritesh]

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.

[Ritesh]

It will be even better if you could attach SQL Scripts of both the databases 🙂

[Ritesh]

BTW, are you sure that the order of COLUMN in the PRIMARY KEY definition are same?

[Hughes]

I'll get to it tonight.

What about the other bug I documented?

[Ritesh]

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 😀

[Shadow]

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?

[Shadow]

I meant bad news, not new…

[Hughes]

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.

[Hughes]

Ritesh 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.

[Hughes]

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.

[Ritesh]

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

[Hughes]

I'm feeling the pressure now. 🙂

I'll get you the other half tonight. BTW, what am I getting paid for my testing services? 😉

[Hughes]

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.

[Ritesh]

Can you cut/paste your output here?

A video file will be even better?

[Ritesh]

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        0

Total time taken – 0 sec(s)

[Hughes]

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.

[Ritesh]

Quote:

Should it detect the difference between the two tables?

Yes 🙂

Can you cut/paste the messages out here? What does sja.log says?

[Hughes]

I'd love to. Unfortunately, I cannot locate the sja.log file. Its not in the SQLYog folder.

[Ritesh]

Can you upload a video capture of the steps you are following?

[Hughes]

For your viewing pleasure.

Also, can you please give me a heads up on the truncating problem?

[Ritesh]

Quote:

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.

[Hughes]

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:

[Ritesh]

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?

[Hughes]

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?

[Ritesh]

Quote:

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.

[Hughes]

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?

[Shadow]

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.

[Ritesh]

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.

[Shadow]

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!

[Ritesh]

I will work on it.

[Hughes]

I concur with Shadow. My sja.log file is stored to my Desktop. I have the shortcut to SQLYog stored there.

[Ritesh]

GOTCHA !!!!

I will release RC8 sometime tomorrow, that will have this bug fixed.

THANK YOU !!!

[Ritesh]

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….

[Hughes]

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: \

[Hughes]

Here is a screen grab to demonstrate what I'm talking about:

[Ritesh]

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

[Author]

Posts