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

62 results found

  1. 170407 12:16:38 - mysqld got exception 0xc0000005 ;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help diagnose
    the problem, but since we have already crashed, something is definitely wrong
    and this may fail.

    keybuffersize=16777216
    readbuffersize=262144
    maxusedconnections=2
    maxthreads=151
    thread
    count=2
    connectioncount=2
    It is possible that mysqld could use

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  2. In your emailed advertisement the unsubscribe link does not work as a link. Suggestion: repair 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 →
  3. When checking for updates(Help | Check for Updates...), encode the Devart authentication login field. This way email addresses containing a plus(+) will not fail.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  4. sice today's release, time fields appear "1.12:45:00" instead of "12:45:00"

    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 →
  5. Dbforge studio can't connect to mysql 5.7.15.

    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  ·  Bugs  ·  Admin →
  6. when adding a new table to a project, it is added to the bottom of the build order list. If I edit the list thru the project properties > build order tab, the order changes are not persisted. I have had to edit the xxx.mydev file manually (outside of visual studio) to get the build to create the .sql file with the table listed in the right order based on foreign key dependencies.

    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 →
  7. CREATE DEFINER = 'camskpn'@'%'
    PROCEDURE cams_kpn.proctest(operation int, PID int, CID int, DID int, UID int, ct varchar(50), CLID int)
    BEGIN

    /*

    operations - Properties

    1 = Contract Select - PID ProjectID
    2 = Doc List - CID ContractID
    3 = Linked Documents - DID DocID
    4 = Ball in Court - DID DocID

    5 = Change Issues - DID DocID
    6 = Change Sources - DID DocID

    7 = Change Items - DID DocID
    8 = Filters - UID UserID
    9 = DocumentDetail - DID DocID
    10 = DocTypes
    11 = Stati
    12 = Change Categories
    13 = Approval Type…

    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 →
  8. Each new run left another instance. Eat memory, lock updates. All 7.x versions, last 7.0.52.0 too.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  9. OpenSSH 7.0 defaults to no support for diffie-hellman-group1-sha1 key
    exchange.

    If we can't edit the config of openssh, we can't use the SSH security feature. Can you upgrade the lib and use one of the default protocol ?

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Bugs  ·  Admin →
  10. since Mysql 5.6.4 (2011), there is a support for fractional datetime and timestamp.

    cf. http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html

    select now(6) should return 2015-07-16 23:48:52.720993 (like with phpmyadmin) and not 16/07/2015 23:46:52

    or better , it should return the localized version 16/07/2015 23:46:52.720993

    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 →

    This can be setup as follows:

    1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Data Editor → Formatting’ branch.
    3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
    4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
    5. Click ‘OK’.

  11. If you have a view that uses/selects columns that no longer exist, you cannot open the view to edit/fix the missing columns:

    View '<TABLE>.<VIEW>' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

    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 →
  12. When you modify the database structure, e.g. delete a table in a particulary database, dbforge dont use that database, instead of that, modify directly the database information_shema, so there are problems in replication configurations.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  13. v 6.3.341

    Open a SQL editor window, write a SELECT query - list the FROM tables, start to build SELECT clause.
    Don't save Query - leave open in editor. Open a Table being referenced in query, and add a new field. Switch back to SQL editor. The new field doesn't appear in the Intellisense drop down (or whatever you call the drop down box - MS call it Intellisence) as you type.
    I was doing this in the SELECT clause. I had also given the tables aliases in the FROM clause, if that make any difference.

    Many thanks.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  14. Most keywords seem to auto-select in the code completion dropdown as you type, with the only exception I've noticed so far being "AS" for column and table aliases (even though its the only choice in the list most of the time). Other short keywords such as "ON" and "BY" will auto-select, making it easy to type in lower case, get the suggestion dropdown, have it automatically selected for you, hit Enter to get the upper case equivalent and keep on going. With "AS" it breaks that pattern requiring you to hit down to select it in the list first.

    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 →

    It’s not highlighted because this could be a part of a user-defined alias starting with AS…

    Though, you can manage this with the ‘Select items in the list even if a user input is expected’ option available in the ‘Text Editor → Code Completion → List Members’ branch of the ‘Options’ window that can be invoked by selecting ‘Tools → Options…’ from the main menu.

  15. When searching objects (cntrl+D,F), searching in tables data and you get a lot of results, that do not fit in result windows, a scroll bar did not show up. It needs to click on the place where it should be, only then it appears.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  16. Not open some of the procedures, don't know what it is, but with a short name opening all the time, and long not open > ~ 40 characters (can cause). The error message "Cannot parse the source 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…)
    2 comments  ·  Bugs  ·  Admin →
  17. In latest version of dbForge while importing Excel 2007 file columns formatted as a date cannot be properly recognized as dates (they are recognized by dbForge as serial numbers) and due to this cannot be properly imported to the corresponding table fields. In older versions such bug hasn't had a place.
    Import date fields from Excel 2003 works fine in 6.3.330 version.

    BR

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  18. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  19. Under newest version (6.2.280) database explorer doesn't update, even after manually refreshing.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  20. Using "create script as + create" generates an invalid script in dbForge Studio for MySQL

    This happens when the default value on a field is currenttimestamp(6) ON UPDATE currenttimestamp(6)

    Example of what gets generated.

    CREATE TABLE test.junkola (
    Id int(11) NOT NULL AUTOINCREMENT,
    RowVersion datetime(6) NOT NULL DEFAULT 'CURRENT
    TIMESTAMP(6)' ON UPDATE CURRENT_TIMESTAMP (6),
    PRIMARY KEY (Id)
    )

    The QUOTES around 'current_timestamp(6)' do not compile in your tool.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Bugs  ·  Admin →
  • Don't see your idea?