78 search results

Page 5 out of 8 Pages

• Foreign Keys/relationships: How can SQLyog handle import of DUMPs with tables using Foreign Keys with HTTP tunnel?
  
  Answer:   This question has been asked sometimes by people having noticed that SQLyog (just like the 'mysqldump' program for instance) generates a SQL-DUMP like SET @old_FOREIGN_KEY_CHECKS = ...
  
  
• Database Schema Synchronization: Problem with string default '' (empty string) and Schema Synchronisation
  
  Answer:   You experience that Schema Sync finds no difference for a string type declared NOT NULL default '' (empty string) and NOT NULL (with no default). This ...
  
  
• Data Types and Storage Engines: Does SQLyog support spatial datatypes?
  
  Answer:   Well .. both yes and no! 'spatial' (or 'geometrical'/'geodetical'/'geographical') datatypes are special datatypes used in conjunction with specific types of programs like GIS ('Geograhical Information Systems') ...
  
  
• How does SQLyog connect to MySQL?: Do I need PHP to use SQLyog with MySQL?
  
  Answer:   No!   You won't need PHP or any PHP-based tool like phpMyAdmin. All you need is MySQL and SQLyog. But of course if you want to use your ...
  
  
• Connection problems: Error no. 1045: "Connection denied..."
  
  Answer:   The error message   Error No. 1045: Connection denied for 'someuser@somehost' (using password: YES/NO)   is a user authentication error. The user details specified do not "match" the ...
  
  
• 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 ...
  
  
• Purchasing and Licensing: Will I need a SQLyog license for each MySQL server that I need to access?
  
  Answer:   No, the licensing policy for SQLyog is client-based, not server-based. That means that you require one license for each PC that will have SQLyog ...
  
  
• Data Types and Storage Engines: Why are my BIT datatypes displayed as squares?
  
  Answer: You experience that BIT datatypes that previously displayed as "0" or "1" (and maybe even any numerical value between "-128" and "127") in SQLyog ...
  
  
• Manipulating data.: Can I change my database name(s)
  
  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 ...
  
  
• Manipulating data.: I have problems with importing CSV data
  
  Answer:   Problems with importing CSV-files frequently occur at the Webyog Forums. We will here outline the basics.1) What is CSV?CSV stands for 'Comma Separated Values'. ...
  
  

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