Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberBTW, are you sure that the order of COLUMN in the PRIMARY KEY definition are same?
Ritesh
MemberIt will be even better if you could attach SQL Scripts of both the databases 🙂
Ritesh
MemberCan 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
MemberWaiting for your comments…..
Ritesh
MemberThanks 🙂
I can be assured that CSV Import/Export are working perfectly.
Have your tried the Data Synchronization Tool?
Ritesh
MemberThe 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
Ritesh
MemberAny suggestions?
Ritesh
MemberYou 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?
Ritesh
MemberQuote: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
Ritesh
MemberGreetings
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
MemberThe above function is not possible with SQLyog's Insert/Update window as it updates each and every column for every update statement. Therefore, the automatic generation of TIMESTAMP from MySQL is not possible.
Updation of changed columns is planned for SQLyog Max
HTH
Ritesh
MemberThanks.
We have put it in the TO-DO list of SQLyog Max 🙂
Ritesh
MemberThanks for the video.
It helped us to fix the bug in 120 secs 🙂
We have released SQLyog 3.6 RC5, that has the above mentioned bug fixed. You can download it at http://www.webyog.com/sqlyog/SQLyog36.exe
HTH
Ritesh
MemberThis is not possible as of now 🙁
Ritesh
MemberCan you mail me a video recording of the BLOB column bug?
-
AuthorPosts