We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …

We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …

Ever had this nightmare of your system crashing, or you accidentally closing SQLyog and losing all your open tabs and queries? Don’t worry, we have you covered!

Introducing Session Restore. You can now restore your previous session along with all queries and history tab the way you left it. Here’s a quick video:

Session Restore is available for all SQLyog users. Existing customers can download the latest build from Customer Portal. To evaluate SQLyog, please download a 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear your feedback.

Cheers,
Team SQLyog

Tweet

The post …

While coding, every second counts. And when the complexity of the database increases, you need to find new ways of speeding up your coding workflow. Let us admit it, we developers prefer to get all our work done using keyboard shortcuts, without having to switch to the mouse.

To streamline your entire coding experience and to speed up database navigation, here are a couple of useful keyboard shortcuts to make the most out of object browser filter in SQLyog.

Keyboard shortcuts:

1. Ctrl + B – sets focus on object browser for operations related to Object Browser.
2. Ctrl + [Up arrow] – brings focus to server/top-most element in Object Browser.
3. Ctrl + E – sets focus to Query Editor to write queries.
4. Ctrl + Shift + B – brings cursor focus on Object Browser filter.
5. Right Arrow – Expand treeview element
6. Left Arrow – Collapse treeview element
…

Hi,

64 bit SQLyog is here. It’s no secret that you can make the most out of your PC only when you have the right combination of software, operating system and hardware. You can now take full advantage of your 64 bit environment for your MySQL needs. We are proud to offer the first 64 bit GUI client for Windows.

Additionally, if you are using 64 bit Microsoft Office 2013, SQLyog 11 will work out of the box with the 64 bit drivers shipped with it. Importing from Access, Excel or Text/CSV has never been easier.

Please refer the following posts for detailed release notes:

• SQLyog 11.0 Beta 2 Released
• …

You had requested for a visual tool to compare two instances of a table to spot differences. We heard that. We are delighted to introduce Visual Data Compare (VDC) in SQLyog 10.5. It lets you do exactly that, and more. VDC allows you to compare two tables right next to each other making it easier to spot differences. It is a lot simpler than manually figuring it out all by yourselves.

VDC also doubles as an additional option for data sync. With VDC you will be able to compare differences visually and specify tables and rows that shall be synced as well as to decide in what direction to sync. It comes very handy when you want to copy lookup data from development databases to staging or production in cases where you for any reason don’t feel safe about having an automatic sync job running unattended in the background.

Visual Data Compare in action

What’s more in this release:

…

Fascinated by colors? Colors play a pivotal role in all our visual experiences because of its vibrational energy. Consciously or subconsciously we have a visual perception of how a perfect UI should be. This color theory has been applied by designers to create visually appealing modern user interfaces and contributing to the overall user experience. Having said that, color perception changes from one individual to another, some of us prefer subtle colors and few others like to spice it up a bit, and sometimes change can be good.

We’ve had users requesting for tweaks in our default SQLyog theme, and we had added this feature with the Twilight theme not long ago in SQLyog 10.0 with total control over the theming capabilities of SQLyog. …

We have released SQLyog MySQL GUI 10.4. The 2 major new features are:

* Autocomplete speed/performance is drastically increased. This is the 3rd time we do this actually since autocomplete was introduced in SQLyog 5+ years ago. Our autocomplete implementation is one of the highest appreciated features of SQLyog according to a survey we did among registered users recently. However some slugginess could occur with a very large number (tens of thousands) databases on the server or a similar number of  tables or other objects in a database. Also a number of small bugs in autocomplete were fixed.

* Also when having a lot of databases, tables or other objects, operating a GUI tool may be tedious to work with (you may need to do a lot of scrolling, for instance). In this release we have implemented a filter in the Object Browser. It works like this: Database objects, where the typed …

So, do you really need phpMyAdmin to access MySQL database on a shared hosting?

NO, you don’t need it, but popular hosting services like GoDaddy integrate phpMyAdmin to facilitate access to MySQL server. Of course phpMyAdmin is a nice tool, no offense, but what if you prefer a desktop application over phpMyAdmin, or you are a developer working on an application that needs to access the MySQL database on a shared hosting? That desktop application I’m referring to is SQLyog. So how does SQLyog access the MySQL database on a shared hosting? And how you can do the same with your own application?

The Problem

Shared hosting is your best option if you have a personal website, or you own a small business and wish to leverage your online presence to get it noticed. They are cheap, you don’t have to manually …

Developers and DBAs often compare and synchronize structures of their database objects (Tables, Views, Triggers, Functions, Events and Stored Procedures) from Development server to Production server and vice-versa. One can use a schema comparison / synchronization tool to synchronize database (DB) objects.

SQLyog’s Schema synchronization tool is simple and intuitive to use for comparing and synchronizing database objects. It comes with new looks and a Filter feature. Database objects’ comparison is now 100x faster.

Using SQLyog, schema synchronization can be usually done in three easy steps:

1. Choose the databases
2. Pressing Compare will show differences between database objects
3. Execute All button will execute the SQL statements to synchronize selected database objects.

Options provided …