Skip to content

dbForge Studio for MySQL

dbForge Studio for MySQL is a universal set of MySQL GUI tools for database management, administration and development. It enables to create and execute queries, develop and debug MySQL routines, and automate MySQL database object management in the convenient environment.

http://www.devart.com/dbforge/mysql/studio/

dbForge Studio for MySQL

Categories

JUMP TO ANOTHER FORUM

460 results found

  1. I have about 100 database connections - these appear to be presented in creation order, so I have to remember when I created something in order to find it

    This view should at least have a sort option... Others have suggested search, which would also be a great help

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. I hope you add a dpi awareness per monitor, because I use two monitors with deferent dpi (one with higher resolution and higher dpi and second with lower resolution and lower dpi), and when I move the application from the first monitor to the second it doesn't look clear.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. If multiple queries are run at the same time on the same sql tab, and there are thus multiple outputs, there should be the ability to export all the outputs simultaneously. This feature is available in PL SQL Developer.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Currently the data format for some field types like date, datetime, time, etc, has a default formatting which is not modifiable when using 'Copy Data As' feature, it changes to a format that isn't working for me now, so it will be nice to set default formats by the user

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    This can be workarounded by using the MySQL command “SOURCE”. For example, in the new SQL file, you can type the following:

    SOURCE .\sqlfile1.sql;
    SOURCE .\sqlfile2.sql;

    SOURCE .\sqlfileN.sql;

    Here, instead of the local path .\ you can specify it explicitly as follows:

    d:\folder\sqlfile.sql

  6. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please provide us a concrete example of this?

    You can send a reply straight to our support system at supportATdevartDOTcom

  7. In the data viewer, I can update a single row, however, I often want to update all returned rows. It would be nice to right click on the column and set all rows to the same thing. As is, I have to recraft the query to be an update -- not hard, just annoying (unless I cant, in which case, the exporting of a list of pks into a update is more painful).

    Love the software otherwise.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    This can be achieved with the functionality implemented in the new version by right-clicking in the data grid and selecting ‘Generate Script As → UPDATE’ from the popup menu.

  8. Now the synchronization aborts when an error occurs. Adding an option which overrules this behaviour and the synchronization process for a table continues.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please provide us a screenshot of the synchronization you are referring to?

    You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom

  9. Currently, when you are working with your own templates or ones you have modified, it is very easy to have a few syntax errors during your edits. It is my experience that the line error information is either not correct or entirely not working most of the time. Clicking on an error is useless since it does not actually take me to the error (sporadic and inaccurate). After minor template changes I made, I have often spent hours trying to figure out the error messages I get when I run, only to find some stupid one character mistake in the…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please clarify what functionality you are referring to and provide us a concrete example of this? Screenshots would be also of help.

    You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom.

  10. when I want to choose the other colors to change the color of "Select Marker" in the menu of "Options --> Text Editor --> Font&Colors", the the border color of the "Select Marker" is the same as before, There is no change in the editor?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

  11. При простое в работе (примерно через час) отключается таблица.
    и постом при возобновление использования минимум ВСЕГДА ДВА раза пишет , одну и туже ошибку( Lost connection to MySQL server during query (......:3306) Table:....... ) если нажать обновить .

    а иногда вообще даже кнопка обновить исчезает и пишет что 0 записей хотя они есть. приходится переподключаться, исправьте пожалуйста, этот баг

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Вы можете попробовать увеличить значение в поле ‘Тайм-аут соединения’ на вкладке ‘Дополнительные’ окна ‘Свойства соединения базы данных’ (щёлкните правой кнопкой мыши на соединении в Проводнике и выберите ‘Изменить соединение…’ в контекстном меню). Значение, равное нулю, означает бесконечность.

    1. Options > Data Editor > General > Open Data Editor in read only mode
    2. Execute a SELECT statement. Data Editor shows up in Read Only Mode. Good.
    3. Flip Data Editor to Edit current table. Do one edit. Apply.
    4. (Optional: Flip Data Editor back to Read Only Mode)
    5. Execute a SELECT statement on ANY table. Data Editor shows up in Edit Mode on the current table. Disregarding both its last set state or System Setting
    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

  12. Version: 8.0.80 (Professional)
    Tried with MySQL 5.6 and 5.7

    Explain Partitions returns an error, but it works fine on the MySQL CLI.

    In dbForge I ran:
    EXPLAIN partitions SELECT * FROM log.log;

    And the error I got was:
    Table 'log.partitions' doesn't exist

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Hello,

    This issue is going to be fixed in the next product build. Currently, as a workaround, you can run statement using F5 button.

  13. Whem importing from Access Database tables with a space in the name do not work at all. Also I just updated to the latest version hoping it would be fixed and now when the console prints out how many records have been imported, it prints on a new line instead of same line.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    > Whem importing from Access Database tables with a space in the name do not work at all.

    Could you please send us the imported file and let us know if you are importing into a new table or existing one?

    > Also I just updated to the latest version hoping it would be fixed and now when the console prints out how many records have been imported, it prints on a new line instead of same line.

    Could you please provide us a screenshot of this?

  14. right-click table / view for source, then right-click table / view for destination!

    Should be across connections or within same schema!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. The 2..99 'WHEN's should lineup

    <code>
    .....ORDER BY
    ..........CASE WHEN intSortField = 0 THEN ContractDashZone
    ....................WHEN intSortField = 1 THEN ContractNameAndContractCode
    END;
    </code>

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. In my company Database Developers write Stored Procedures in files and then Execute Script in MySQL Databse using dbForege and then testing and debugging . If we do not declare vvariable1 and use them in as
    IF v
    Variable1 > 0 THEN
    OR
    CALL procname1(v_Variable1

    dbForge does not check variables in above cases. I appreciate if you add this feature in your coming release, this will help to make a good MySQL IDE for Stored Procedures.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. When I run a sequence of stored procedure calls and somewhere in there an error occurs, the debugging session just ends. If the error could have happened at multiple places then it would be very helpful to have a back trace of the last line to successfully execute or the one that failed to execute.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. It would be really handy to be able to print scripts in colour as it is displayed in the script editor.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. when creating a new table, many developers have default fields (triggers, indexes) they use: we need a setup based on a project where a new table is created based on a setup/config that was made before.
    for example: every new table sould have 2 fields like:

    • db_created (datetime)
    • db_changed (datetime)

    and also 2 triggers

    • trdbchanged ---> SET db_changed = NOW() ....

    the first field dbforge creates, is based on the table name, would
    be great, if we could change that regex, for example:

    if the table name is: "user" --> i always want the first field named based…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
1 2 5 7 9 22 23
  • Don't see your idea?