MySQL Tools

dbForge Studio for MySql on Linux family operating systems

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

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

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…)

MySQL GUI: dbForge Studio for MySQL – new cutting-edge version released!

In the new version we made a lot of improvements and added a whole pack of new features in almost all dbForge Studio’s GUI tools. And the most remarkable thing about this release is that nearly all novelties were suggested by our users. So we hope they will enjoy working with the new version and feel that they have contributed a lot to make it as it is.

dbForge Studio for MySQL

Cutting-Edge MySQL GUI Client: dbForge Studio for MySQL

With the help of our users we could work on the product on the new level, and as a result of such successful tight cooperation its standard of quality grew. This new standard includes taking into account actual needs of people using our product and implementing their exact requirements except studying the market in general and implementing features that are theoretically demanded.

When you open the application to get acquainted with the new version, you will be surely stunned and pleasantly surprised by its new look. When you start using it, we hope you will be thrilled by the inner improvements and make the best use of them:
(more…)

GUI Tool for MySQL: dbForge Studio for MySQL, v4.50.342 Released

Changes (as compared to 4.50.339) include:
Bug fixes:
* The error on entering selection criteria after selecting Group By fields in Query Builder fixed (T26884)
* The problem with showing 0 as a parameter value instead of NULL in the parameter editor fixed (T26867)
* Removing field’s autoincrement sign on adding index in the table fixed (T24859)
* Extra new line on copying data from a cell in Data Editor removed (T27021)
* The problem with losing ON UPDATE CURRENT_TIMESTAMP during editing a table fixed (T27090)
* The problems with connecting to MySQL Server via SSH tunnel fixed (T26911, T20079)
* InvalidOperationExceptions on generating schema synchronization script in the Schema Comparison tool fixed (T27106, T27108)

Read more about the tool: http://www.devart.com/dbforge/mysql/studio/

Downloads: http://www.devart.com/dbforge/mysql/studio/download.html

How to Get a List of Permissions of MySQL Users

MySQL has advanced database access system. A database user can have access to the whole database, separate tables, or to separate columns of tables. Also there is a restriction for actions a user may perform with records. MySQL server uses several tables in a special database to organize such a complicated database access structure. The access policy is based on the values available in these tables.

The database that MySQL server uses to store internal data about users is called mysql by default. There are tables for storing information about users’ accounts in this database:
(more…)

Provide your feedback on dbForge Studio for MySQL at UserVoice!

Go to devart.uservoice.com and share your ideas about new features you want to see in dbForge Studio for MySQL. Here you can do the following:

  • Vote for features that are already in our roadmap, and they will get higher priority in our plans
  • Suggest your own features, and if they get enough votes, we will include them to the roadmap.

Your opinion helps us to make our MySQL GUI Client better and more useful for you.

Provide your feedback on dbForge Studio for MySQL at UserVoice

We have already started implementing the following features:

(more…)

GUI dbForge Studio for MySQL, v4.50.311 Released

Changes (as compared to 4.50.308) include: (more…)

How To: Create a MySQL Database Diagram Using a Sketch Image

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in the form of an image file in the project documentation.

(more…)

dbForge Studio for MySQL has been nominated in Best IDE Product of 2010 DevProConnections Community Choice Awards!

Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by a community vote. (more…)