Forum Replies Created
-
AuthorPosts
-
peterlaursen
Participant“I installed 6.03, but it doesn't let me connect to remote server”
I am sorry but there is no information we can use here!
Why not? How do you connect? What is the difference you experience between 5.19 and 6.03?
What happens – do you get some error message?
I cannot see any reason why 6.03 should behave otherwise than 5.19 in this respect! You must explain the problem so that we can understand what is happening!
ParticipantThen please try version 6.03!
There is no difference with CSV-import between COMMUNITY and ENTERPRISE. it does not matter which one you use. Also if you wnat to keep 5.19 you can install 6.03 to another folder. Now if this is already fixed between 5.19 and 6.03 there really is nothing else we can do!
We cannot reproduce this with 6.03!
Participantse this bug report
Participantthis is definitely a MySQL bug in my opinion!
However with MySQL 4.0 everything seems to be OK!
Participantthis is the situation with MySQL 5.0.41:
select version();
/*
version()
5.0.41-community-nt
*/
show variables like 'lower_case_table_names';
/*
Variable_name Value
lower_case_table_names 2
*/
show tables like 'Parenttable';
/*
Tables_in_t4 (Parenttable)
Parenttable
*/
show create table childtable;
/*
CREATE TABLE `childtable` (
`id` bigint(20) NOT NULL,
`keyrow` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FK_Childtable` (`keyrow`), CONSTRAINT `FK_Childtable`
FOREIGN KEY (`keyrow`) REFERENCES `parenttable` (`id`) )
ENGINE=InnoDB DEFAULT CHARSET=latin1
*/
and alternatively using LOWERCASE with 'Show Tables' still returns the table in UPERCASE.
show tables like 'parenttable';
/*
Tables_in_t4 (Parenttable)
Parenttable
*/
Participant“The precise problem is that all names have the correct case ..except”
If so it is a MySQL bug that should not be accepted but reported and fixed (if it is not allready in 5.0.41)
ParticipantIs it 'messages' tab only? what about 'objects' and 'history' ?
I think you should try to install the Microsoft Core Fonts in Crossover.
Refer to this FAQ:
http://www.webyog.com/faq/31_71_en.html
we have not seen such issue with (the Open Souce) Wine on neither Fedora or SuSE, I believe. But we will check again!
Participantthe error is a server error! All 4-digit errors starting with '1' are. I can not explain at the moment why it works with 5.2.x but basically I think this error is an issue with the database itself.
Try a table repair or dump and reimport the affected table(s).
Can you explain the name 'instrbio.bak'. Do you have such table? And what is the MySQL version?
Participanthehe 😀
actually “0” in commonly used in configuration files meaning 'no limits', but not here!
Participantwe do not support XML import yet.
there also is not a single XML format for data – But we should be able to import at least what we ourselves have exported! This is recorded in our TODO.
BTW: moving this post to SQLyog category!
Participantwhat is the Linux 'dialect' that you are using?
if this Linux allows for .RPM installs from command line you will be able to install from a remote shell (telnet, SSH). You cannot install from a web browser! Installing requires shell access with sufficient user privileges!
ParticipantThe reason is that the curent Mysql server version has incorrectly been upgraded from a previous vesion!
When upgrading the MySQL server it is not sufficent to install the server binary 'on top of' the previous server version. You must also update the mysql system tables by executing the update script or program provided by MySQL AB ('mysql_fix_privileges_tables'-sql or 'mysql_update' (depending on the mysql version upgraded to) for instance).
Please refer to the mysql documentation for details (or ask here …)!
ParticipantYou can always zip files before attaching. Please do!
ParticipantWe cannot reproduce (no matter the charset/collation of data) this on Fedora6. MySQL 4.1.21
Personally I think it is a bug with the MySQL version that you use. But I cannot totally exclude the possibility of an issue related to this Wine version on Ubuntu.
ParticipantSome additional remarks and considerations:
The random nature of this problem ('it happens most of the time with most connections') indicates to me that it is not a SQLyog issue. Such issue would not be random like this, it would either work or it would not!
If phpMyAdmin works on that host, then please try SQLyog with HTTP tunnelling. This should be the same a phpMyAdmin in this respect: connection to MySQL from 'localhost' and transfer of data to SQLyog using HTTP.
Also please note that when no data occurs in SQLyog after a ” SELECT * …” does the 'execute' icon in the program display a 'green arrow' or a 'red cross' ? If the latter is the case, this means that SQLyog is still waiting for data to be transferred.
-
AuthorPosts
