Announcement

Collapse
No announcement yet.

cannot dump table(s) from mysql database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • cannot dump table(s) from mysql database

    version 11.1.3
    when dumping table from context menu on tablename(1) (data and structure) or menu Tools\Data Transfer (to sql file) (2)
    i get
    [Msg] [Dtf] DataTransfer started
    [Err] [Dtf] 80050009: Connection 10.208.14.15 not found
    [Err] [Dtf] Finished - Unsuccessfully

    history log for 1
    [2017-08-24 17:06:13.115] [17205400] [10.208.14.15] [MYSQL]
    SHOW VARIABLES LIKE 'lower_case_%'

    [2017-08-24 17:06:13.117] [17205400] [10.208.14.15] [MYSQL]
    SHOW VARIABLES LIKE 'profiling'

    [2017-08-24 17:06:13.118] [17205400] [10.208.14.15] [MYSQL]
    SHOW DATABASES

    [2017-08-24 17:06:15.185] [17205403] [10.208.14.15] [MYSQL]
    SELECT @@character_set_database, @@collation_database

    [2017-08-24 17:06:15.189] [17205403] [10.208.14.15] [MYSQL]
    SELECT EVENT_CATALOG, EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_DEFINITION, EVENT_TYPE, SQL_MODE, STATUS, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STARTS, ENDS, ON_COMPLETION, CREATED, LAST_ALTERED, LAST_EXECUTED, EVENT_COMMENT FROM information_schema.EVENTS WHERE EVENT_SCHEMA='ukmserver' ORDER BY EVENT_NAME

    [2017-08-24 17:06:16.364] [17205403] [10.208.14.15] [MYSQL]
    SHOW FULL TABLES WHERE Table_type != 'VIEW'

    history log for 2
    [2017-08-24 17:07:25.849] [17205400] [10.208.14.15] [MYSQL]
    SHOW DATABASES

    [2017-08-24 17:07:25.869] [17205400] [10.208.14.15] [MYSQL]
    SHOW DATABASES

    [2017-08-24 17:07:25.874] [17205403] [10.208.14.15] [MYSQL]
    SHOW FULL TABLES WHERE Table_type != 'VIEW'

    [2017-08-24 17:07:26.020] [17205403] [10.208.14.15] [MYSQL]
    SHOW FULL TABLES WHERE Table_type = 'VIEW'

    [2017-08-24 17:07:26.142] [17205403] [10.208.14.15] [MYSQL]
    SHOW PROCEDURE STATUS WHERE Db='ukmserver'

    [2017-08-24 17:07:26.155] [17205403] [10.208.14.15] [MYSQL]
    SHOW FUNCTION STATUS WHERE Db='ukmserver'

    [2017-08-24 17:07:26.180] [17205403] [10.208.14.15] [MYSQL]
    SELECT EVENT_CATALOG, EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_DEFINITION, EVENT_TYPE, SQL_MODE, STATUS, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STARTS, ENDS, ON_COMPLETION, CREATED, LAST_ALTERED, LAST_EXECUTED, EVENT_COMMENT FROM information_schema.EVENTS WHERE EVENT_SCHEMA='ukmserver' ORDER BY EVENT_NAME


    dump via mysql console is ok


  • #2
    Hi,

    Please upgrade to version 11.2 to see if it can solve the problem. You can submit your registered email address on the Customer Center at: https://customer.navicat.com

    Comment

    Working...
    X