Forum Replies Created
-
AuthorPosts
-
tfg
MemberI am using XP.
I updated from the previous installation (which was the most recent until the current new version) and took defaults. It was my understanding that it installs over the old one. In the past it has always kept the previous settings I had.
I have looked in the Application Data/SQLyog directory and note that there are a number of SQLyog_Dump_xxx.dmp files in there. I have attached a directory listing.
Here is what my sqlyog.ini file looks like – it appear that all the information is gone.
[VSplitter]
Left=0
Right=0
Top=0
Bottom=0
ULeftOrTopPercent=0
[SQLYOG]
Number=0
File1=0
File2=0
File3=0
File4=0
File5=0
Host=localhost
Encoding=utf8
Left=0
Top=0
Right=600
Bottom=600
Maximize=0
[HSplitter]
Left=0
Right=0
Top=0
Bottom=0
ULeftOrTopPercent=35
[GENERALPREF]
UpgradeCheckedDate=0
Let me know if there is something I should do. What is causing the *.dmp files to be generated? After updating to the most recent release it did work a number of times before all the information disappeared.
MemberIn the process of responding to you, I figured out what the problem was.
The table had only 4 columns which were decimal or char data types. It did NOT have a primary key. When I noticed this I added a autoincrement bigint as a primary key. Once I had added the primary key the database synchronization wizard ran and completed successfully.
I know it doesn't make sense not to have a primary key. This is a very old table and I don't know why it didn't have one.
However, it seems the database synchronization wizard requires it!? Maybe you could add a check to warn the user if it is missing.
Thanks for your help – you have a great product!
MemberI am using version 7.12 Enterprise.
If there is feedback what is it?
This is cut/paste from the log to better explain what I am talking about:
Sync started at Thu Nov 06 09:35:30 2008
`cacampersurvey` 3 3 0 0 0
`cainstructorsurvey` 1 1 0 0 0
`castlenews` 3 3 0 0 0
`ce_initiate_master` 10 10 0 0 0
`ce_spiritual_growth` 13 13 0 0 0
`ce_surveyinfo` 4 4 0 0 0
`contactinfo` 13 13 0 0 0
`contacts` 12 12 0 0 0
`csm_wa_userlevels` 371 361 10 0 0
`csm_wa_users` 19 19 0 0 0
`dailyinputs` 20377 20377
The point where it “stops” and takes 20 mintes is after the “20377 20377” text is displayed. After the 20 minute period of time the remaining numbers on the line are displayed and it continues with the reminder of the tables.
MemberYes thanks, that works fine!!
MemberHow about using the following SQL statement to return the column names in order (try it with “table name” some valid table):
select column_name from information_schema.COLUMNS where table_name=”table name” order by column_name asc
I believe that information_schema is only available since version 5. Maybe this makes the use of the above unreasonable because your tool needs to be backwards compatible.
Server side sort/filter would be fine with me (it accomplished the desired goal just fine).
-
AuthorPosts
