After too much time waiting for an email to have login-data (about an hour), i decide to buy a non-commercial version for upgrading the existent software. After installing it seems the things run a lot of smoother than before. Then i got errors while i want to transfer tables without a primary key. I can understand that things are somewhat harder to handle without a unique key, but while using a lot of tables from given scripts it is too much work for me to change all data-stuff for the needs of this program.
What i want is an easy tool to save my data from web without using a shell-script, download, import and so on. For this i really should possible to get the data from a table though it has no primary key. Im no professionell programer at all, but maybe this can be solved with a truncate and complete insert? Maybe with an option: truncate and completly insert when a table has no unique part.
Another thing i really dont like:
1. Choose a table
2. Set: Show all
3. Choose another table with about 100.000 data-sets
4. ... wait, wait, wait ...
For this there should be an option to set a limit.
Another thing is: How to reduce the cpu-power for the program to 50% for example. When downloading a table with about 50.000 lines the whole workstation slows down to death (and this machine is no slow one)
Full Version: Bad Joke?
Maybe it is possible to show some more info while transfering data; at the moment i wait till 10 minutes if something else will happen after this message:
`Table` 5982 5982 WARNING: No primary key found in table `CatLinks`. This might result in error.
Check C:\SQLyog\sja.log for complete error details.
BTW: Dont u use a compression if available like others do? With Mywitch for example it is possible to choose if i want to use compression or not; the same i can choose if i want to have a decryption for the send data ... with mywitch my whole db is downloaded in some few minutes (saved as flat), with sl it takes me more than 15 minutes and im still waiting.
`Table` 5982 5982 WARNING: No primary key found in table `CatLinks`. This might result in error.
Check C:\SQLyog\sja.log for complete error details.
BTW: Dont u use a compression if available like others do? With Mywitch for example it is possible to choose if i want to use compression or not; the same i can choose if i want to have a decryption for the send data ... with mywitch my whole db is downloaded in some few minutes (saved as flat), with sl it takes me more than 15 minutes and im still waiting.
"After too much time waiting ..". If the mail does not arrive for some reason, you can always go to http://www.webyog.com/CustomerArea . If you are not registered there an error has occured with our purchase processor. Please create a ticket then and we will sort things out.
"Then i got errors while i want to transfer tables without a primary key. I can understand that things are somewhat harder to handle without a unique key" A primary key and a unique key is two different things. Please read http://webyog.com/faq/28_70_en.html
"For this i really should possible to get the data from a table though it has no primary key." You can always export and iimport, for instance. For syncronisation every row of data will have to be uniquely identified. If you like you can read the dicsussion here: http://webyog.com/en/whitepapers/Using_SQL...L_Databases.pdf
"at the moment i wait till 10 minutes ... ". If you run SJA from inside the GUI you will get lot of messages about what is happening. Don't you? Or do you still use the old version?
"Dont u use a compression if available like others do?" We do not use compression. Could you explain what sort of compression you would expect with MySQL? To my knowledge there is no one supported by MySQL. With HTTP-tunnelling there is the gzip option, but our experience that it des not make any
difference whether it is used or not if only you have a 128 kbs connection or faster. It is not transmission of data that is the bottleneck, but the server(s
' response time.
Encrytion (SSL) howvever will be included in 5.23 beta 1 to be released in less than a week. This is supported natively with MySQL. And encrypted HTTP (HTTPS) is there allready.
"Another thing i really dont like:
1. Choose a table
2. Set: Show all
3. Choose another table with about 100.000 data-sets
4. ... wait, wait, wait ... "
What is the program version you are using? With recent versions selecting the DATA tab wil only load the number of rows specified in the LIMIT setting. Please study the programs' 'preferences'! What is your LIMIT setting (not your PERSONAL, but that of your program!)?
No, we only tell GOOD jokes here ....
"Then i got errors while i want to transfer tables without a primary key. I can understand that things are somewhat harder to handle without a unique key" A primary key and a unique key is two different things. Please read http://webyog.com/faq/28_70_en.html
"For this i really should possible to get the data from a table though it has no primary key." You can always export and iimport, for instance. For syncronisation every row of data will have to be uniquely identified. If you like you can read the dicsussion here: http://webyog.com/en/whitepapers/Using_SQL...L_Databases.pdf
"at the moment i wait till 10 minutes ... ". If you run SJA from inside the GUI you will get lot of messages about what is happening. Don't you? Or do you still use the old version?
"Dont u use a compression if available like others do?" We do not use compression. Could you explain what sort of compression you would expect with MySQL? To my knowledge there is no one supported by MySQL. With HTTP-tunnelling there is the gzip option, but our experience that it des not make any
difference whether it is used or not if only you have a 128 kbs connection or faster. It is not transmission of data that is the bottleneck, but the server(s
' response time.
Encrytion (SSL) howvever will be included in 5.23 beta 1 to be released in less than a week. This is supported natively with MySQL. And encrypted HTTP (HTTPS) is there allready.
"Another thing i really dont like:
1. Choose a table
2. Set: Show all
3. Choose another table with about 100.000 data-sets
4. ... wait, wait, wait ... "
What is the program version you are using? With recent versions selecting the DATA tab wil only load the number of rows specified in the LIMIT setting. Please study the programs' 'preferences'! What is your LIMIT setting (not your PERSONAL, but that of your program!)?
No, we only tell GOOD jokes here ....
Most simple solution is to add an autoincrement PK to every table that does not have a PK, if that will not break your applications.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.