Blog

MySQL

Adapting Diagram File to Another Database

Posted by on October 19th, 2012

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file.

Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database Diagram file. Now, you want to avoid redesigning the database model from scratch and only reassign the existing database model to another MySQL server. (more…)

Using MySQL Full-Text Search in Entity Framework

Posted by on July 10th, 2012

Introduction

MySQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:

We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the full-text search functionality in our Devart dotConnect for MySQL ADO.NET Entity Framework provider. (more…)

Workaround for ‘Authentication failed’ Issue When Connecting through HTTP Tunnel

Posted by on May 11th, 2012

Some of our users have encountered problems with establishing a connection over the tunnel.php script despite the fact that the tunnel.php script is installed correctly. The following error message occurs:

‘Can’t connect to MySQL server on ‘your.sitename.com’ (10061): Authentication failed.’

The problem appears to be with cached proxy servers and will be fixed in one of the next builds of our product.

Currently it can be fixed by replacing the dbforgemysql.exe.config file, that can be found in dbForge Studio for MySQL installation folder, with the attached one.

Mind data modifications via Data Editor in dbForge Studio for MySQL

Posted by on January 30th, 2012

Since one of our users has encountered a problem when modifying data via Data Editor, we decided to bring such a situation to our users’ attention.

Let’s assume you have the following table:

CREATE TABLE dept(
  DeptNo INT(10),
  DName VARCHAR(14),
  loc VARCHAR(13),
  Salsum FLOAT
);

Data-Editor-1

Let’s execute the following query in the SQL document:

SELECT DName, loc FROM dept WHERE DeptNo = 20;

Now if you change any of the values of the first record in Data Editor, the changes will be applied to all records of the original table that have ‘DName’ = ‘Research’ and ‘loc’ = ‘Dallas’. (more…)

Get 20% off on any Devart product (expires January 10th)!

Posted by on December 14th, 2011

Merry Christmas and Happy New Year!

As Christmas holidays are drawing closer, we offer you to get 20% off any product license order.

Don’t think twice, just save 20%. And what more, you get free access to all future releases of the respective products for one year.

Get 20% discount!

Hurry up, this offer is available only from December 01, 2011 till January 10, 2012. Decide and order right now.

We wish you all the best in the coming year, let joy and happiness be your constant partners and friends!

Best Christmas Wishes,
Devart Team

MySQL Debugging Methods Overview

Posted by on September 23rd, 2011

Introduction
Debugging SQL code is a very important task these days. Unfortunately not all database servers support this feature. And MySQL is one of such servers. In spite of its wide feature set, debugging is not implemented in it. So the problem is that MySQL provides no API functionalities for code debugging. But the necessity to debug SQL code does not disappear and becomes more and more important each year. Some companies that develop tools to access data of MySQL server databases create their own debuggers that solve this problem to some extent.

MySQL Debugger

Types of Debuggers
Now we will consider the types of debuggers that can be implemented for MySQL server and principles of their work.
(more…)

2011 DevProConnections nominates dbForge Studio for MySQL as Best IDE Product!

Posted by on August 16th, 2011
dbForge Studio for MySQL - Best IDE Product

dbForge Studio for MySQL – Best IDE Product

Support Your Favorite Devart Products in 2011 DevProConnections Voting!

We would like to invite you to take part in 2011 DevProConnections
voting. The Community Choice Awards, as presented by Windows IT Pro, SQL Server
Magazine, and DevProConnections, allow you to decide, which IT products get chosen
for acclaim and recognition. This year Devart dbForge Studio for MySQL
is nominated in the following category.

2011 DevProConnections Community Choice Awards:

Category 14 (page 2): Best IDE Product – dbForge Studio for MySQL
If you think that Devart’s MySQL GUI Client is worth of being the best in the given categories, vote now for your favourite Devart products:

2011 DevProConnections Community Choice Awards

With Best Wishes,
The Devart Team

dbForge Studio for MySql on Linux family operating systems

Posted by on June 22nd, 2011

Despite the fact that dbForge products were developed only for Windows platforms, our active users (thanks to Tsvetkov) have found a way to use some features of dbForge Studio for MySql on Linux family operating systems.

Tests were run under .Net Framework 2.0 on Wine emulator. (more…)

Comic video about developing dbForge Studio for MySQL

Posted by on June 17th, 2011

Our company has been working on its own MySQL GUI client development for over 6 years. Many features were implemented in this product in accordance with our users’ requests, that acted as task originators for us. We are glad that the development process of our MySQL Front-End goes on and on, and we were able to release version 5.0 of the product. For the release of version 5.0, we decided to make a special video telling about the product history. You can see the result.

MySQL-Studio-Developing-video

Funny video about history of our MySQL GUI tool

We did not intend to have a professional video made by clip-makers. The video was shot frame-by-frame using a common digital camera. After that jpg files were rendered to the mp4 video format. Shooting took almost 7 hours. All models were made by hand from plasticine by one of our employees, whose hobby is design and model-making. All of us want to thank him for this!

Export a MySQL Table to a CSV File Methods Overview

Posted by on May 30th, 2011

To perform successful export of a MySQL table to a CSV file you will need the dbForge Studio for MySQL database management tool. You can download it for free and evaluate its features during a 30-day trial period.

A comma-separated values (CSV) file is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. CSV file is a text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next with a comma. For example, a CSV file might be used to transfer information from a database to a spreadsheet or another database. Of course, there are more advanced formats to store data, for example, XML, but CSV does have one advantage over XML. CSV has much lower overhead, thereby using much less bandwidth and storage than XML.

Now let’s analyse how one can save data from a MySQL table to a CSV file.

(more…)