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

472 results found

  1. We are unable to define delimiters for variables. This causes query code from dbForge to fail when copied to a java based production environment.

    Currently the dbForge variable delimiters are not compatible with many environments.

    Provide means for users to define variable delimiters like DbVisualizer does.

    2 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)
  2. It would be nice to have a possibility of copy into the clipboard all selected column names from a table or view.
    It's really weary to copy them on by one.

    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  ·  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 clarify whether you were referring to the Data Editor or Table Editor functionality?

  3. 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?

  4. (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.

  5. I have to be able to write files to a secure Windows server location where the user is something other than {user}@localhost. Is there a way to pass a username and password in the select into outfile command? I cannot have the write-to location be open to the world because the data are confidential.

    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  ·  Questions  ·  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 and let us know how it should be connected with dbForge?

  6. 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.

  7. Posibility of make macros and shortcut-keys, each macro can write custom code like pgAdmin program. For example:
    Macro 1: Ctrl-F5 = "Select * from $SELECTION$"
    Macro 2: Ctrl-F6 = "select count(*) as rowsintable from $SELECTION$"

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

    We recommend you to try the Code Snippets feature. Please refer to the ‘Code Snippets
    ’ topic in the product’s Help documentation for details.

  8. Once upgraded, I don't see an easy way to revert to the prior version. It seems to entirely wipe it. Its just a matter of time before the new version exhibits some serious problem.

    Additionally; it would be nice to set a preference to never accept a new version until it's been out for a month. Typically; I manually decline the upgrade until it seems like a month has gone by but that's just unscientific.

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

    Please note that you can unselect the ‘Check updates on startup once a week’ option available in the ‘Environment → General’ section of the ‘Options’ window that can be invoked from the main menu ‘Tools- > Options…’.

    Earlier product builds and versions are available to registered users only and can be downloaded from Registered User’s Area.

  9. SQL BUILDER in view create screen

    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  ·  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)
  10. Allow to switch float number decimal point from ',' to '.' in GUI. Countries other from Russia do not use ',' as decimal point

    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  ·  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 setting depends on the locale of your operating system and can be changed in the ‘Region and Language’ section of your Windows settings.

  11. 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

  12. If have procedures that use

    IF operation = 1 THEN
    BEGIN
    //code
    END;
    ELSEIF operation = 2 THEN
    BEGIN
    //code
    END;
    END IF;

    the outlining doesn't appear on the BEGIN statements in this scenario, so I cannot collapse everything inside the section. This would greatly help in navigating large procedures.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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 full script of the stored procedure and a screenshot displaying this issue?

    Please also let us know what version of dbForge you are using.

    You can reply straight to our support system at supportATdevartDOTcom

  13. in visual studio: press ctrl + h always global popup window. how to use "find & replace" locally mini popup?

    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  ·  Questions  ·  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?

    You can reply straight to our support system at supportATdevartDOTcom

  14. 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

  15. 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

  16. LOAD DATA INFILE (Error Message "Fix")

    I am requesting that you add the DETAILS from the POPUP dialog to the OUTPUT window. So after you click OKAY, you still have access to the PROPER Details including DATA FILE ROW NUMBER!

    https://www.screencast.com/t/wAdjle8sHmal

    That is what I get once I clear the dialog. I get NO repeat of the "in row 1663857 of the data"

    It was in the POPUP message (Called Additional Information)

    https://www.screencast.com/t/DLfhMmAK5VZz

    It would be helpful.

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

    Please note that there is information on the error including the row number in the ‘Error List’ window that can be opened by selecting ‘View → Error List’ from the main menu (Ctrl+W, E).

  17. 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  ·  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 describe this in more detail and specify in what cases exactly this should be applicable?

  18. the latest version 7.3.137 once minimized or hiden by another program, after some time it cannot be brought to the foreground. And if you try to close it from the task bar, pops up a box to save any unsaved objects, but there is way to click on the buttons, it like something else is grabbing the input. In that state I saves a process dump. Please let me know how can I uploaded it to you.

    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)
  19. Provide a new option to perform page breaks in documentation when generating documentaion (e.g. at database table level). This would allow the documentation to be more readable for users. (SQL Documentor)

    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  ·  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 screenshots of the actual and expected results?

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

  20. 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 .

  • Don't see your idea?