Forum Replies Created
-
AuthorPosts
-
RiteshMember
Thanks for your help.
RiteshMemberAs of now, MySQL client does not supports connecting through a Proxy
RiteshMemberCan you upload a screenshot of the window when the problem is occurring?
RiteshMemberQuote: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.
RiteshMemberHope the configuration shown in the image below will help you.
RiteshMemberIt will be very helpful if you could attach a screenshot of SQLyog when the above happens.
RiteshMemberInnoDB wont be creating multiple files as MyISAM table handler. All the table will only be in one file i.e. the innodb tablespace.
RiteshMemberPlease provide an empty DB structure that fails to synchronize. That would be very helpful in reproducing the bug.
RiteshMemberMake 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.
RiteshMemberCan you give me more information about how the fields are terminated/enclosed etc.
RiteshMemberCan 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 🙂
RiteshMemberWhich 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.
RiteshMemberSorry 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.
RiteshMemberThis 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.
RiteshMemberThe 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