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

75 results found

  1. Comparing two databases I encounter this error.
    I have selected "Detect mysql charset" as I am advised by the error message.
    However I keep receiving this error.
    Is there a way to manually add some encodings?
    I have updated the application to the latest update.
    DB forge Studio for Mysql Pro.

    1 vote
    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)
  2. dbForge Studio 2019 for MySQL 8.1.22
    When sync data between MySQL 5.7.25 and MySQL 8.0.15 and table have field name in reserver keywords, got error like "check syntax ", rank,", fields and tables names must be enclosed in apostrophes.
    MySQL 8.0 event like
    CREATE
    DEFINER = 'username'@'localhost'
    EVENT odatabase.eventname
    ON SCHEDULE EVERY '1' WEEK
    ...
    in GUI shows as "every '7' (SEVEN) weeks", but DDL is right.

    1 vote
    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)
  3. Not sure if it needs to be classified as a bug or a new features BUT!!!!
    I noticed today after our Aurora AWS Cluster failed over that I was not able to recompile a stored procedure I was altering.
    From a query window you can close the connection and an execute will open it again.
    But you can't close the connection from the editor!!
    And it's the same with Table Editor.
    I know you can close it from the DB Explore but it's inconsistent with the SQL Editor UI. You should have the same buttons.

    1 vote
    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)
  4. Granting privileges has issues if the database name contains an underscore.

    If the database privileges have been defined on the mysql command line or in pma myadmin the underscores are escaped so that an exact match of the database name applies.

    eg.

    GRANT select on my\_db.* TO 'user'@'host'

    DbForge does not escape the _ character and creates a new privilege:

    GRANT INSERT on my_db.* TO 'user'@'host'

    If the 'my_db' escaped SELECT privilege is present then the INSERT privilege created by dbForge is ignored.

    The underscores in database and host names should be escaped out by dbForge when it…

    1 vote
    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)
  5. A have dbf files with FoxPro database. When i trying to import file with CURRENCY datafields I get error: "Неверный или неизвестный тип колонки DBF"

    1 vote
    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 provide us the CREATE definition of the table into which you are importing data and the imported .dbf file so we can reproduce this issue on our side?

  6. (or add an option if this is intended behavior). If I am zoomed in and move an object with the arrow keys the view will center on the object which makes moving something relative to something else that [was visible before the centering] very hard to do. It looks like the system is trying to guarantee the whole object is visible which results in the jumping if part of it is outside the view (clipped).

    1 vote
    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 describe this in more detail? Screenshots or video will be also of help.

    You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

  7. Awesome product btw - (just) one annoying bug:
    This relates to the top part of the data compare section; any selected cell to pick a related view turns white and doesn't show the number anymore - just the checkbox. Same for the source or target object name.
    (Moving away to see the number again resets the list view; looking at the tag bubble of the list requires searching the columns since the position is always shifting based on the length of all numbers. Not so much fun on large data sets)
    Thanks for your fantastic work,
    Regards,
    Martin.

    (customer since…

    1 vote
    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)
  8. The data viewer stops working intermittently. The only way to get it working again is to restart dbForge. I execute a query, and then right click on a cell in the results and select Data Viewer. In most cases this shows the data in the Data Viewer panel but it regularly jus displays nothing.

    1 vote
    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)

    Please make sure you are using the latest build 6.2.280.

    If the issue still persists in the latest build, please provide us the CREATE definition of the table and a test record so we can reproduce the issue on our side.

    You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

  9. I am working with other devs, one of which uses another app for sp's.

    In his app he has a weird formatter, but it will place / on there own line as part of a division statement in the sp.

    dbForge for MySQL won't even open the sp, says it cannot parse the sp, so I cannot even open the sp to edit it.

    1 vote
    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 provide us the CREATE definition of the stored procedure and let us know what version of dbForge you are using?

    You can reply straight to our support system at supportATdevartDOTcom

  10. When you reverse engineer a table with a column defined like this
    tdate timestamp NOT NULL DEFAULT date(CURRENTTIMESTAMP) ON UPDATE CURRENTTIMESTAMP
    after any change in the table, unrelated, you write the same column as
    tdate timestamp NOT NULL DEFAULT 'date(CURRENTTIMESTAMP)' ON UPDATE CURRENTTIMESTAMP
    which is wrong, the quotes cannot be there. The modification fails.

    1 vote
    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 provide us the CREATE definition of the table and specify what version of dbForge Studio for MySQL you are using?

    You can reply straight to our support system at supportATdevartDOTcom

  11. I remember this effect is good for the text editor of the SQL,but why is no effect now?

    1 vote
    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 provide us a screenshot explaining this and describe the steps to reproduce the issue in detail?

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

  12. Scenario

    DB user has SELECT privileges on mysql.proc.
    DB user has ALL PRIVILEGES on schemaA, and NO PRIVILEGES on schemaB.
    DB user is running dbForge for MySQL 8.0.40
    A Stored Procedure (spA) in schemaA calls a Stored Function in schema A (fnA).
    A Stored Procedure (sp
    B) in schemaB calls the Stored Function in schema A (fnA).

    Therefore, in the Database Explorer tree view, schemaA is listed, schemaB is not.

    Action

    The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.

    1 vote
    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 the result of the following query:
    SHOW GRANTS FOR ’DB_user_name’@’host_name’

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

  13. When editing SQL code in dbForge for MySQL 7.3.137, there is a case where it fails to detect the "start of comment" delimiter, and incorrectly intreprets the remaining text on the line as SQL code. This breaks the syntax highlighter, auto-complete, and ability to save stored procedures, functions, etc.

    Specifically, when using a double-dash "--" to start a comment in MySQL, it normally requires whitespace after the double-dash to be interpreted as a start of comment delimiter. However, when the double dash is at the beginning of a line, it does not require whitespace.

    See: https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html

    Example:

    -- This is…

    1 vote
    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)
  14. 1) meanwhile the execution of SQL script file if I click on some other window, ant then return in output window...the output windows shows the first output...and not the (more usefull) last one.

    2) please fix it! I have more than one schema. I select the first one. Open a SQL file...launch it. Ok. I open a second SQL file...THE SCHEMA CHANGE without show me the change and dbForge run the SQL script on the second schema!!! Damn it!

    1 vote
    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)
  15. BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8

    1 vote
    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)
  16. When a view references a table nad/or column which got deleted you can't edit the view anymore.
    I had to use phpmyadmin to edit the view just to drop the column.

    1 vote
    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)
  17. Right-click on Database "Foo" in object tree. Select--> Backup and Restore --> Restore Database... Dialog shows "Bar" in the Database dropdown list. The Filename text box does not default to the path used for the Backup operation.

    1 vote
    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)
  18. the table designer has a BUG. A table column can have as a default value an internal server variable, in my case @@bindaddress. The correct way to add it (@@bindaddress), and it works. But when the table editor reverses a table definition, it misinterprets these defaults and saves it back wrong.

    1 vote
    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)
  19. How about an option in the connection string to mark the connection as an interactive one so that interactivetimeout applies instead of waittimeout?

    1 vote
    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)
  20. When results from SQL query contain a newline/carriage return, only the first part of the result (until the first CR) is displayed.

    For instance, if my DB field contains CR as follows :
    My Business
    1 park avenue
    New-York
    USA

    When getting this field content through select, only the first line ("My Business") is displayed in the result panel.

    1 vote
    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)
  • Don't see your idea?