29 search results

Page 2 out of 3 Pages

• 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 ...
  
  
• Backup/Restore: Can I restore a backup on another server than where it was created?
  
  Answer: Yes, you can. But please first also read this FAQthat explains the basics about the backup functionalities in SQLyog. As long as the 'main' Server versions are identical ...
  
  
• Data Types and Storage Engines: Tables with Floating Point Datatypes Fail to Update
  
  Answer: Floating Point datatypes in MySQL are FLOAT, DOUBLE and (before MySQL 5.03) DECIMAL. Those datatypes are not stored as exact values inside computer architecture. What you ...
  
  
• Working with Views, Stored Procedures and Triggers: I have full privileges to a database but cannot ALTER a routine. Why?
  
  Answer: You experience that you have full privileges to a database (described in GRANT syntax like GRANT ALL PRIVILEGES ON some_database.* TO 'me'@'somehost') but cannot ALTER ...
  
  
• Installation and Configuration: Installation and upgrading
  
  Answer: SQLyog is distributed with an automatic installer script. Just save it to your desktop and doubleclick the installation file. You will have ...
  
  
• Importing external data: What kind of ODBC databases are supported by SQLyog Import External Data Tool?
  
  Answer:   Any! Simply. As long as they really are ODBC databases. But let us first define ODBC. We quote the Webopedia: ODBC ...
  
  
• Importing external data: What is and what is not imported by the SQLyog Import External Data Tool?
  
  Answer:   The SQLyog Import External Data Tool as of SQLyog 4.1 and later will importDATA and it will - of course - create the type definitions ...
  
  
• Using the GUI: Can I store 'long strings' in BLOBs with SQLyog?
  
  Answer: Yes, you can. But basically you should consider a better option! BLOB types are 'BINARY LONG' data. It is intended for storing binary data ...
  
  
• Working with Views, Stored Procedures and Triggers: I get Error Code: 1370 - alter routine command denied etc. when importing an SQL-file
  
  Answer:   To learn how to fix this privilege issue read this   ...
  
  
• Working with Views, Stored Procedures and Triggers: I get error 1044 "Access denied to user ..." when importing a SQL file
  
  Answer:   ... however data are imported OK. But Stored Procedures and Functions are not.   read here   ...
  
  

<<  previous  1  2  3  next  >>