Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberThanks for your help.
Ritesh
MemberAs of now, MySQL client does not supports connecting through a Proxy
Ritesh
MemberCan you upload a screenshot of the window when the problem is occurring?
Ritesh
MemberQuote:Mention is made of linux support at the next major release, with what sort of frequency have majors been released.When the product is rocksolid and very stable.
Ritesh
MemberHope the configuration shown in the image below will help you.
Ritesh
MemberIt will be very helpful if you could attach a screenshot of SQLyog when the above happens.
Ritesh
MemberInnoDB wont be creating multiple files as MyISAM table handler. All the table will only be in one file i.e. the innodb tablespace.
Ritesh
MemberPlease provide an empty DB structure that fails to synchronize. That would be very helpful in reproducing the bug.
Ritesh
MemberMake sure that a directory called idbata exist in the c:mysql, then add this line in the mysqld section
innodb_data_home_dir = c:/mysql/ibdata
Then start the mysql daemon with the following parameters –
mysqld-max-nt –basedir=c:/mysql –innodb_data_file_path=ibdata1:30M:autoextend –innodb_data_home_dir=c:/mysql/ibdata
I believe this will start the MySQL with proper information.
Ritesh
MemberCan you give me more information about how the fields are terminated/enclosed etc.
Ritesh
MemberCan you give us more information about your MySQL Server, OS and the complete command line options which you use to start the MySQL Server Daemon.
A post of your my.ini will also be helpful 🙂
Ritesh
MemberWhich version of MySQL you are using?
MySQL does not support sub-select which you are trying to use as of now. It is a planned feature for their future releases.
Ritesh
MemberSorry for the late reply :ph34r:
You probably have a permissions issue in your data or temp directory…Mysql is not able to create a temporary table when making the table alteration.
Ritesh
MemberThis is a permission error.
The host from which you are connecting to does not have proper permissions to log on to the MySQL server. Please change the MySQL/User table and create proper permission for the host.
Ritesh
MemberThe fastest way to execute a batch script in SQLyog is to use Tools->Execute Batch File… option ( Ctrl+Shift+Q ) and just provide the name of the SQL file.
Using this method you dont have to “open” the file in the editor window before executing it. This option has been optimized for VERY large batch scripts. It will also tell you the time take to execute the entire file. Pls. try it out and let us know your feedback.
-
AuthorPosts