|
Q. What is SQLyog ?
A. SQLyog is a very fast,
compact and simple to use GUI tool to manage
your MySQL server. The software is primarily for the users who
work with MySQL during the development process.
 Like MySQL, SQLyog also follows the principle of
the 14th century philosopher monk Occam. We follow his rule
known as Occam’s razor: No complexity beyond what is
necessary.
Q. Which is the latest version of SQLyog
?
A. The latest version of SQLyog is 3.64,
released in February 2004. It contains so many new features
that it is a must upgrade for all from SQLyog 3.x.
Q. Where can I obtain
SQLyog ?
A. You can download a copy of SQLyog from the
SQLyog
Download Page. Just provide us with your name and e-mail
address so that we can inform you about future releases of
SQLyog.
Q. Where can I find a mailing
list/discussion board for SQLyog ?
A. We have a discussion board here. Ask
your question and one of our support team members will reply
back.
Q. I think I found a bug, whom should I tell
?
A. Make sure that you are using the latest
version of SQLyog by checking it at the SQLyog website. If you
are sure that you have the latest one then report the bug at
Bugs Section
at SQLyog forum . We will reply you back about the status
of the bug. If its a known bug then we will be able to reply
back with the solution or maybe you have to wait for the next
release.
Q. Do I need to read any
documentation to put SQLyog into use ?
A. Absolutely not. SQLyog has got an intuitive
interface, you will be up and running within moments. Special
care has been taken to provide a non-cluttered and extremely
simple interface.
Q. I am new to MySQL/SQL ? Can SQLyog
help me in learning MySQL ?
A. Yes! If you are new to MySQL or SQL then
SQLyog is the ideal tool to get you started. Apart from
providing templates of all SQL statements supported by MySQL,
queries generated by SQLyog to perform various tasks are also
logged. Click
here to see a screenshot of query profiler
Q. On what platform SQLyog has been
developed ?
A. SQLyog has been written using C/C++/Win32
APIs. It accesses MySQL using the native MySQL C API and does
not use any wrapper classes. This makes SQLyog probably the
fastest front end to MySQL in the market. Moreover the size of
SQLyog binary is one of the smallest.
Q. Do you have any plans to release a
Linux/Unix/Mac version of SQLyog ?
A. Yes. We may make SQLyog cross platform in
our next major release.
Q. I have started working with MySQL 4.1 which has
lot of new features. Can I use SQLyog to work with MySQL
4.1?
A. Yes! Starting with SQLyog 3.5,
SQLyog is completely MySQL 4.1 compatible. For that matter,
SQLyog 3.5 has been made backward compatible. If you have a
legacy MySQL database you can administer them using
SQLyog.
Q. I want to update a set of data which was
returned from a Query. Can I do it in SQLyog ?
A. Yes! Instead of executing the
query by pressing F5, execute the query using F8. A Grid will
come up with the result which you can update. This allows you
to edit a Resultset having a complex WHERE clause or
JOINS. SQLyog will generate the corresponding
Insert/Update script to commit the changes.
Q. I frequently
need to reorder columns and there is no single-query in MySQL
to do that. Can SQLyog help me ?
A. Definitely. Select the table for
which you want to reorder columns and press Ctrl+Alt+R or
select Reorder Columns from the popup menu. Reorder the
columns using Move Up/Move Down buttons and press Reorder. Click
here to see a screenshot of column reorder dialog
Q. After creating the database and tables in my
test server, I need to move the whole database with its data
to the production server. How can I do that ?
A. SQLyog allows you to copy data
between two databases located in different hosts. Choose the
database that you want to Copy in the Object Browser and
select Copy Database from the popup menu. SQLyog will give you
a list of all the hosts and databases that you are connected
to in the current session. Select the target database and
source tables. Click
here to see a screenshot of copy database dialog
Q. I want to bring table structures of two
database located in different hosts in Sync with each other.
How can I do it in SQLyog ?
A. SQLyog gives you the most easy and
elegant to bring two databases into complete sync i.e.
creating new tables, dropping tables, altering table structure
etc. with a single mouse click. Press Ctrl+Q or select
Tools->Structure Synchronization Tool to start the
Structure Synchronization Tool. Select the two database which
you want to bring in Sync and select one of the command
buttons in the bottom. Click
here to see a screenshot of database sync tool dialog
New!
Q. I
want to bring data of two database located in different hosts
in Sync with each other. How can I do it in SQLyog
?
A. SQLyog Job
Agent ( SJA ) is a high-performance, multithreaded, multi
platform application to automate and schedule Synchronization
of Data between two MySQL hosts. On
Windows, it is included with SQLyog 3.63 - the latest version
of the award winning MySQL Client. The Linux version of SJA is
FREE and can be downloaded from http://www.webyog.com/sqlyog/downsja.html.
In SQLyog, it can be accessed through Tools->Database
Synchronization Wizard.
SJA does not require any installation at hosts
running the MySQL server. You can use any host to run the SJA.
For example – you can use SJA to keep your production
databases ( probably hosted with an ISP ) in complete sync
with your test database located in your PC or LAN.
SJA uses an efficient algorithm to generate
checksums to find out the changes. Therefore, only those rows
that have been inserted, updated or deleted since the last
sync are transferred between the hosts.
Additionally, you can configure SJA to detect
changes only for specific rows and columns. For example – you
can exclude blob columns or include only those rows that
fulfill a WHERE clause. This makes is an ideal tool to sync
data even if there is limited bandwidth.
SJA is a command line tool that accepts a Job
Definition file encoded in XML as one of the parameters. You
can either create the Job Definition file manually or use one
of the wizards included with SQLyog. If you use SQLyog to
create your job files, you don’t need to have any knowledge
about XML or the Job Definition schema.
On Windows platforms, SQLyog uses the
Task Scheduler services to schedule your jobs. On other
platforms you can use the respective OS scheduling services,
e.g – on Linux, you can use cron to schedule
jobs.
Q. I have
a very big result and I would like to use the complete screen
area for viewing the result. How can I do that ?
A. SQLyog allows you to show/hide
Object Browser, Result Pane as well as the Query Window.
Therefore by hiding Query Window and Object Browser you can
use the complete space for viewing your resultset. You can
show/hide Object Browser by pressing Ctrl+1 and show/hide
Query Window by pressing Ctrl+3.
Q. I would like
to get my results in text form so that I can search for a
string or copy portions of resultset as text to the clipboard.
Is it possible ?
A. SQLyog allows you to view your
resultset in Grid as well as Text Mode. You can toggle between
the modes by pressing Ctrl+L. In the Text mode set your cursor
in the result pane and press Ctrl+F to search for a string. click
here to see a screenshot of result in text
Q. I have a very
big query and I would like to use the complete screen area for
editing. How can I do that ?
A. SQLyog allows you to show/hide
Object Browser, Result Pane as well as the Query Window.
Therefore by hiding Object Browser and the Result Pane you can
use the complete space in editing your query. You can
show/hide Object Browser by pressing Ctrl+1 and show/hide
Result Pane by pressing Ctrl+2.
Q. I have a huge
SQL batch file ( in gigabytes! ). How can I execute it using
SQLyog ?
A. SQLyog allows you to execute a
batch file of any size (yes....any size - limited by the OS).
Select Tools -> Execute Batch File (Ctrl+Shift+Q). Select
the file and press Execute. If SQLyog encounters an error it
stops further execution and logs the query as well as the
error message in sqlyog.err located in the SQLyog installation
folder. click
here to see a screenshot of execute batch file dialog
box
Q. I want to
export the resultset in a file on the client. The MySQL
command SELECT INTO OUTFILE... creates a file on the server
only. Can SQLyog create a file on the client ?
A. After you execute a query. Select
the tab of the particular resultset which you want to export
and right click on it ( Ctrl+Shift+E ) and select Export
Resultset. SQLyog allows you export the result set in XML,
HTML, CSV ( fixed length and variable length ). click
here to see a screenshot of export resultset dialog
box
Q. Can I export
data in fixed length format using SQLyog ?
A. Yes! Apart from the usual variable
length format SQLyog can export/import fixed width format
data. Select the table in the Object Browser for which you
want to export the data and select Table -> Export Table
Data As CSV ( Ctrl+Alt+C ). Select Fixed Length in the
escaping characters dialog box (you get this by pressing the
Change... button). click
here to see a screenshot of export table data in CSV
Q. I want to
create a documentation of my database ? Does SQLyog provide
any tool for creating a schema document ?
A. Yes! SQLyog allows you to build a
printer friendly schema document in HTML. You can either
select the entire database or specific tables. Select the
database -> right click -> Create Schema For The
Database in HTML (Ctrl+shift+S). click
here to see a screenshot of schema created by SQLyog
Q. I have
created a table and would like to insert sample data
quickly...Do I need to write insert statements ?
A. No! SQLyog provides you with an
Excel like Grid to Insert/Update data through which you can
insert data quickly. Moreover, you can use the tool to insert
blob data and it gives you a picklist for Enum/Set datatype to
speed up insertion.
Q. I have got a table that has blob fields
containing text/images...Can I view / modify BLOB fields
?
A. Yes! Select the table in the
Object Browser and select Table -> Insert / Update Data (
Ctrl+Enter ). You can insert/edit/save any type of BLOB data.
It automatically detects popular image formats like
JPG/GIF/PNG and displays them. Moreover you can save BLOB data
to a file or import contents from a file to a BLOB column. click
here to see a screenshot of Insert / Update data dialog
box
Q. I have a
resultset which has a BLOB column ? How can I view its data /
save it ?
A. All the BLOB columns will be shown
in the Resultset window with [BLOB] [DblClk To View It (size
of data in bytes)]. Double click on the column and a
modeless Blob Value dialog box will popup. You can save
the data in a file in your local machine by selecting Save
Data To A File option. Therefore, for example, you can even
retrieve a PDF data in a column and save it in your harddisk.
click
here to see a screenshot of blob value dialog box
Q. I have a table with lot of
columns and I want to generate an Insert statement for the
table. How can I do it ?
A. Select the table in the Object
Browser and select Table -> Insert Statement For The Table.
SQLyog will create a insert statement for the table and you
just need to fill in the appropriate values.
Q. Just like
other programmers, I like to do most of my work using keyboard
? Is SQLyog keyboard friendly.
A. SQLyog has been designed from
ground-up to be keyboard friendly. You can switch between the
various panes, multiple resultsets without ever needing the
mouse. Check out
the various keyboard shortcuts provided by SQLyog.
Q. I have
retrieved a resultset in SQLyog. Now, I want to quickly
sort/filter the data without changing and re-executing the SQL
query. How can I do that ?
A. If you are viewing the result in
Grid mode, you can click on a column header to sort the
resultset on that column. You can use the Right Click context
menu to filter data. Furthermore, you can combine sorting and
filtering. click
here to view a sorted column
A. SQLyog has probably the most powerful and
comprehensive ODBC Import functionality through which you can
import data from any ODBC compliant datasource. To import a
data just create a DSN to the database and select ODBC Import
Wizard by pressing Ctrl+Alt+O or Tools-> ODBC Import
Wizard. Select the correct options in the wizard and in a
flash all your data will be imported.
Q. I have started using InnoDB
Table Handler and will like to Manage Relationships with
SQLyog. Can I do that ?
A. Yes! SQLyog provides you with an easy
Relationship Manager. Just select the Key Table and press F10
or select Manage Relationships from the popup menu. You can
create a new relationship or delete an existing relationships
with just a few mouseclicks. Moreover all SQLyog
administrative options are InnoDB aware. click
here to see a screeshot of manage realtionships dialog
A. Yes! You will get a Excel like Grid to alter
your table structure. click
here to see a screeshot of alter table dialog
Q. Can I manage Indexes using
SQLyog ?
A. Yes! SQLyog provides you with an easy Index
Manager. You can manage multiple indexes, create indexes on
multiple columns, change the order of columns in the index,
etc. click
here to see a screeshot of manage indexes dialog
Q. I want to add users / change
passwords etc. ? How can I do that ?
A. Use Tools -> User Manager -> Add Users
( Ctrl+U ) and Tools -> User Manager -> Edit Users (
Ctrl+Alt+U ) to add and edit users global privileges. click
here to see a screeshot of edit user dialog
Q. I want to give a user
privileges only to particular columns in a table ? Can I do it
in SQLyog.
A. Yes! By using SQLyog's powerful and easy to
use Manage Permissions tool, you can give database, table
& column level privileges to any user. The Manage
Permissions option can be found at Tools -> User Manager
-> Manage Permissions (Ctrl+Shift+W). click
here to see a screenshot of manage permissions
Q. My MySQL Server is hosted with
an ISP. How can SQLyog help me in remote administration
?
A. SQLyog has been specially designed to work on
remote connections. It is very efficient on network bandwidth
giving you the best possible environment to work with MySQL
server on remote connections.
Q. I have a bunch of
administrative SQL scripts which I use frequently. I don't
want to save and load files every time ? How can SQLyog help
me in saving time ?
A. SQLyog allows you keep your frequently used
SQL scripts in a Personal Folder. To save a SQL query press
Ctrl+Shift+F and provide a name. When you want it back, press
Ctrl+Shift+P and select the query name from the popup menu.
SQLyog allows you to have 99 SQL queries in the personal
folder. click
here to view personal folder menu
Q. How do I diagnose/optimize
tables ?
A. Use Tools -> Table Diagnostics and select
the database and tables and click on the operation you want to
perform. SQLyog provides all types of diagnostics provided by
MySQL with a single click. click
here to see a screenshot of table diagnostics dialog
box
| 
