78 search results

Page 6 out of 8 Pages

• General Use: What kind of databases does SQLyog support?
  
  Answer: SQLyog is a Frontend / a GUI tool (or whatever you may call it!) for administering MySQL databases, and MySQL databases ...
  
  
• Manipulating data.: Can I rename a database?
  
  Answer:   NO... and yes! Directly changing database names is not possible! It is not a restriction with SQLyog, but with MySQL itself. The reason is that ...
  
  
• Data Types and Storage Engines: How does SQLyog handle TIMESTAMPS defined as '... on UPDATE CURRENT_TIMESTAMP' ?
  
  Answer:   You can read about SQLyog 'smart' KEYWORD handling introduced with SQLyog 5.1 here.   When updating any TIMESTAMP defined with '... on UPDATE ...
  
  
• MySQL bugs that affect SQLyog: Nothing happens when clicking the + sign left to a database
  
  Answer:   You experience that nothing happens when you are clicking the + sign left to a Database Icon in the SQLyog Object Browser when connected to ...
  
  
• Backup/Restore: How should I use the various options of the SQLyog backup 'powertool'?
  
  Answer:   We cannot decide that on your behalf! We have provided the most flexible options available including:* An option to backup a complete database or only ...
  
  
• Character Set and Localization Issues: My special characters display as 'noisy' Latin characters in SQLyog!
  
  Answer: Most likely the reason for this is that the install script of the application that is used with the data did not explicitly create databases ...
  
  
• Importing external data: Migration of columns defaults from MS Access fails with SQLyog Import External Data Tool.
  
  Answer: You experience that when importing data from Microsoft Access migration of columns defaults fail. This is a confirmed issue and we believe it is a problem ...
  
  
• MySQL DATA synchronization: Data Sync fails with string columns defined DEFAULT '' (empty string)
  
  Answer:   This will happen if servers are different versions and if one is from before and the other after a specific point in time.  The 'specific point ...
  
  
• Using the GUI: I connect as a user who has GRANT option but User Management fails.
  
  Answer:   To illustrate this we create such userGRANT ALL ON ´somedatabase´.* TO 'oneuser'@'localhost' WITH GRANT OPTION;As this user has ALL privileges to a specific database and ...
  
  
• How does SQLyog connect to MySQL?: SQLyog gives you the most options for connecting to MySQL
  
  Answer:   SQLyog connects to MySQL using the native C-API from MySQL - the fastest and most effective way to manage MySQL. This API is compiled ...
  
  

<<  previous  1  2  3  4  5  6  7  8  next  >>