Toad for MySQL - General

Community Discussion

Alan Ramires
Follow / 29 May 2015 at 2:53pm / Toad for MySQL

Toad for MySQL - field manipulation

Expand content
where can i change a float field (11,0) to (11,2) ? and second, how can i re-order fields ? thanks

where can i change a float field (11,0) to (11,2) ?

and second, how can i re-order fields ?

thanks

125 0 / Create an account to join the discussion.
Enric_Naval
Follow / 27 May 2015 at 8:16am / Toad for MySQL

incorrect accents in column headers (in grid)

Expand content
Toad has issues displaying the accents in the grid, but only in the column name (see example in the image), Not a show-stopping bug, but a bit annoying.

Toad has issues displaying the accents in the grid, but only in the column name (see example in the image),

Not a show-stopping bug, but a bit annoying.

304 0 / Create an account to join the discussion.
Guest
Follow / 17 Feb 2010 at 2:41pm / Toad for MySQL
Latest post by on 26 May 2015 at 3:45pm

4.6 Database Explorer Encoding

Expand content
Hi, Upgraded to 4.6 and the encoding from Database Explorer is all messed up. Tried to change it but was unable to find it. I need support for characters like á ç ã Tks for all the...

Hi,

Upgraded to 4.6 and the encoding from Database Explorer is all messed up.
Tried to change it but was unable to find it. I need support for characters like á ç ã

Tks for all the help

6030 5 / Create an account to join the discussion.
zpaya
Follow / 26 May 2015 at 8:07am / Toad for MySQL

Not able to CSV on Remote mysql server using Toad for mysql

Expand content
Using excel 2013 converted to CSV file by below command LOAD DATA LOCAL INFILE 'D:\\filename.csv' INTO TABLE dbname.tablename FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'...

Using excel 2013 converted to CSV file by below command

LOAD DATA LOCAL INFILE 'D:\\filename.csv' INTO TABLE dbname.tablename
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (ColA,ColB);

ERROR log:

********************************************************************************
Exception Information
********************************************************************************
Exception: System.NotSupportedException
Message : Not supported field count found.
Stack Trace:
at CoreLab.MySql.b.a(e[]& A_0, Int32& A_1)
at CoreLab.MySql.b.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at CoreLab.MySql.v.d()
at CoreLab.MySql.MySqlCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Quest.Toad.Db.ProxyCommand.ExecuteReader()
at Quest.Toad.Db.ProxyAdapter.ExecuteReleasedReader()
at Quest.Toad.Db.BackgroundAdapter.FillQuery()

********************************************************************************
Application Information
********************************************************************************
26-05-2015 12:18:39
Support Bundle for Toad 2.0.0.604
Toad, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 2.0\Toad.exe
Referenced Assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
ToadCore, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822

Loaded Plugins:
ToadControls, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 2.0\ToadControls.dll
Referenced Assemblies:
DevExpress.Utils3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

ToadCore, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 2.0\ToadCore.dll
Referenced Assemblies:
ActiproSoftware.Shared, Version=1.0.76.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9
ActiproSoftware.SyntaxEditor, Version=3.1.203.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
ActiproSoftware.WinUICore, Version=1.0.76.0, Culture=neutral, PublicKeyToken=1eba893a2bc55de5
DevExpress.Data3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.Utils3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraBars3, Version=3.7.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraGrid3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraNavBar3, Version=2.7.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraPrinting3, Version=1.12.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraReports3, Version=1.12.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraTreeList3, Version=1.11.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
FlexCel, Version=3.7.0.2, Culture=neutral, PublicKeyToken=3b4004b85c62843e
ManagedQP5, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822
mscorlib, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Modeler.Drawing, Version=1.0.9.70, Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.AxQExplain2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.FmtOptCom, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.KXpert, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822
SandDock, Version=2.3.2.1, Culture=neutral, PublicKeyToken=75b7ec17dd7c14c3
SharpZLib, Version=0.84.0.0, Culture=neutral, PublicKeyToken=1b03e6acf1164f73
SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822
System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Management, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Runtime.Serialization.Formatters.Soap, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Xml, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Xml, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
ToadControls, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822

ToadMySQL, Version=2.0.2.604, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 2.0\Plugins\MySQL\ToadMySQL.dll
Referenced Assemblies:
ActiproSoftware.SyntaxEditor, Version=3.1.203.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
CoreLab.MySql, Version=3.50.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.Utils3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraBars3, Version=3.7.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraGrid3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraTreeList3, Version=1.11.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ManagedQP5, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Modeler.Drawing, Version=1.0.9.70, Culture=neutral, PublicKeyToken=c862883b2ae69822
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
ToadControls, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822
ToadCore, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822
ToadMySQLProvider, Version=2.0.2.604, Culture=neutral, PublicKeyToken=c862883b2ae69822

ToadMySQLProvider, Version=2.0.2.604, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Quest Software\Toad for MySQL Freeware 2.0\Plugins\MySQL\ToadMySQLProvider.dll
Referenced Assemblies:
DevExpress.Utils3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors3, Version=3.2.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
ToadControls, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822
ToadCore, Version=2.0.0.604, Culture=neutral, PublicKeyToken=c862883b2ae69822

********************************************************************************
System Information
********************************************************************************
Operating System
Microsoft Windows 7 Enterprise 6.1.7601
Manufacturer: Microsoft Corporation
Computer Name: MyDesktop
Windows Directory: C:\Windows
Serial Number: 00392-918-5000002-85801

Computer System
Computer Manufacturer Name: Hewlett-Packard
Computer Model: HP ProBook 450 G2
System Type: x64-based PC
Total Physical Memory: 8,257,648 KB

System Processor
Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 69 Stepping 1
CPU Speed: 2.401 GHz
L2 Cache Size: 1 KB

System Bios
BIOS: Default System BIOS
BIOS Version: HPQOEM - 1

System Time Zone
Time Zone: (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi

Logical Memory Configuration
********************************************************************************
Connection Information
********************************************************************************
Current Connection:
xxx@xx.xx.xx.xx
MySQL database
Server version 5.6.19
Connected since 26-05-2015 12:17:04
0 of 1 connection in pool active
Database Variables:
auto_increment_increment = 1
auto_increment_offset = 1
autocommit = OFF
automatic_sp_privileges = ON
back_log = 80
basedir = C:\Program Files\MySQL\MySQL Server 5.6\
big_tables = OFF
bind_address = *
binlog_cache_size = 32768
binlog_checksum = CRC32
binlog_direct_non_transactional_updates = OFF
binlog_format = STATEMENT
binlog_max_flush_queue_time = 0
binlog_order_commits = ON
binlog_row_image = FULL
binlog_rows_query_log_events = OFF
binlog_stmt_cache_size = 32768
block_encryption_mode = aes-128-ecb
bulk_insert_buffer_size = 8388608
character_set_client = utf8
character_set_connection = utf8
character_set_database = utf8
character_set_filesystem = binary
character_set_results = utf8
character_set_server = utf8
character_set_system = utf8
character_sets_dir = C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\
collation_connection = utf8_general_ci
collation_database = utf8_general_ci
collation_server = utf8_general_ci
completion_type = NO_CHAIN
concurrent_insert = AUTO
connect_timeout = 10
core_file = OFF
datadir = C:\ProgramData\MySQL\MySQL Server 5.6\data\
date_format = %Y-%m-%d
datetime_format = %Y-%m-%d %H:%i:%s
default_storage_engine = InnoDB
default_tmp_storage_engine = InnoDB
default_week_format = 0
delay_key_write = ON
delayed_insert_limit = 100
delayed_insert_timeout = 300
delayed_queue_size = 1000
disconnect_on_expired_password = ON
div_precision_increment = 4
end_markers_in_json = OFF
enforce_gtid_consistency = OFF
eq_range_index_dive_limit = 10
error_count = 0
event_scheduler = OFF
expire_logs_days = 0
explicit_defaults_for_timestamp = OFF
external_user =
flush = OFF
flush_time = 0
foreign_key_checks = ON
ft_boolean_syntax = + -><()~*:""&|
ft_max_word_len = 84
ft_min_word_len = 4
ft_query_expansion_limit = 20
ft_stopword_file = (built-in)
general_log = OFF
general_log_file = LT0018468.log
group_concat_max_len = 1024
gtid_executed =
gtid_mode = OFF
gtid_next = AUTOMATIC
gtid_owned =
gtid_purged =
have_compress = YES
have_crypt = NO
have_dynamic_loading = YES
have_geometry = YES
have_openssl = DISABLED
have_profiling = YES
have_query_cache = YES
have_rtree_keys = YES
have_ssl = DISABLED
have_symlink = YES
host_cache_size = 279
hostname = LT0018468
identity = 0
ignore_builtin_innodb = OFF
ignore_db_dirs =
init_connect =
init_file =
init_slave =
innodb_adaptive_flushing = ON
innodb_adaptive_flushing_lwm = 10
innodb_adaptive_hash_index = ON
innodb_adaptive_max_sleep_delay = 150000
innodb_additional_mem_pool_size = 7340032
innodb_api_bk_commit_interval = 5
innodb_api_disable_rowlock = OFF
innodb_api_enable_binlog = OFF
innodb_api_enable_mdl = OFF
innodb_api_trx_level = 0
innodb_autoextend_increment = 64
innodb_autoinc_lock_mode = 1
innodb_buffer_pool_dump_at_shutdown = OFF
innodb_buffer_pool_dump_now = OFF
innodb_buffer_pool_filename = ib_buffer_pool
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_abort = OFF
innodb_buffer_pool_load_at_startup = OFF
innodb_buffer_pool_load_now = OFF
innodb_buffer_pool_size = 300941312
innodb_change_buffer_max_size = 25
innodb_change_buffering = all
innodb_checksum_algorithm = crc32
innodb_checksums = ON
innodb_cmp_per_index_enabled = OFF
innodb_commit_concurrency = 0
innodb_compression_failure_threshold_pct = 5
innodb_compression_level = 6
innodb_compression_pad_pct_max = 50
innodb_concurrency_tickets = 5000
innodb_data_file_path = ibdata1:12M:autoextend
innodb_data_home_dir =
innodb_disable_sort_file_cache = OFF
innodb_doublewrite = ON
innodb_fast_shutdown = 1
innodb_file_format = Antelope
innodb_file_format_check = ON
innodb_file_format_max = Antelope
innodb_file_per_table = ON
innodb_flush_log_at_timeout = 1
innodb_flush_log_at_trx_commit = 1
innodb_flush_method =
innodb_flush_neighbors = 1
innodb_flushing_avg_loops = 30
innodb_force_load_corrupted = OFF
innodb_force_recovery = 0
innodb_ft_aux_table =
innodb_ft_cache_size = 8000000
innodb_ft_enable_diag_print = OFF
innodb_ft_enable_stopword = ON
innodb_ft_max_token_size = 84
innodb_ft_min_token_size = 3
innodb_ft_num_word_optimize = 2000
innodb_ft_result_cache_limit = 2000000000
innodb_ft_server_stopword_table =
innodb_ft_sort_pll_degree = 2
innodb_ft_total_cache_size = 640000000
innodb_ft_user_stopword_table =
innodb_io_capacity = 200
innodb_io_capacity_max = 2000
innodb_large_prefix = OFF
innodb_lock_wait_timeout = 50
innodb_locks_unsafe_for_binlog = OFF
innodb_log_buffer_size = 4194304
innodb_log_compressed_pages = ON
innodb_log_file_size = 50331648
innodb_log_files_in_group = 2
innodb_log_group_home_dir = .\
innodb_lru_scan_depth = 1024
innodb_max_dirty_pages_pct = 75
innodb_max_dirty_pages_pct_lwm = 0
innodb_max_purge_lag = 0
innodb_max_purge_lag_delay = 0
innodb_mirrored_log_groups = 1
innodb_monitor_disable =
innodb_monitor_enable =
innodb_monitor_reset =
innodb_monitor_reset_all =
innodb_old_blocks_pct = 37
innodb_old_blocks_time = 1000
innodb_online_alter_log_max_size = 134217728
innodb_open_files = 300
innodb_optimize_fulltext_only = OFF
innodb_page_size = 16384
innodb_print_all_deadlocks = OFF
innodb_purge_batch_size = 300
innodb_purge_threads = 1
innodb_random_read_ahead = OFF
innodb_read_ahead_threshold = 56
innodb_read_io_threads = 4
innodb_read_only = OFF
innodb_replication_delay = 0
innodb_rollback_on_timeout = OFF
innodb_rollback_segments = 128
innodb_sort_buffer_size = 1048576
innodb_spin_wait_delay = 6
innodb_stats_auto_recalc = ON
innodb_stats_method = nulls_equal
innodb_stats_on_metadata = OFF
innodb_stats_persistent = ON
innodb_stats_persistent_sample_pages = 20
innodb_stats_sample_pages = 8
innodb_stats_transient_sample_pages = 8
innodb_status_output = OFF
innodb_status_output_locks = OFF
innodb_strict_mode = OFF
innodb_support_xa = ON
innodb_sync_array_size = 1
innodb_sync_spin_loops = 30
innodb_table_locks = ON
innodb_thread_concurrency = 9
innodb_thread_sleep_delay = 0
innodb_undo_directory = .
innodb_undo_logs = 128
innodb_undo_tablespaces = 0
innodb_use_native_aio = ON
innodb_use_sys_malloc = ON
innodb_version = 5.6.19
innodb_write_io_threads = 4
insert_id = 0
interactive_timeout = 28800
join_buffer_size = 262144
keep_files_on_create = OFF
key_buffer_size = 8388608
key_cache_age_threshold = 300
key_cache_block_size = 1024
key_cache_division_limit = 100
large_files_support = ON
large_page_size = 0
large_pages = OFF
last_insert_id = 0
lc_messages = en_US
lc_messages_dir = C:\Program Files\MySQL\MySQL Server 5.6\share\
lc_time_names = en_US
license = GPL
local_infile = ON
lock_wait_timeout = 31536000
log_bin = OFF
log_bin_basename =
log_bin_index =
log_bin_trust_function_creators = OFF
log_bin_use_v1_row_events = OFF
log_error = .\LT0018468.err
log_output = NONE
log_queries_not_using_indexes = OFF
log_slave_updates = OFF
log_slow_admin_statements = OFF
log_slow_slave_statements = OFF
log_throttle_queries_not_using_indexes = 0
log_warnings = 1
long_query_time = 10.000000
low_priority_updates = OFF
lower_case_file_system = ON
lower_case_table_names = 1
master_info_repository = FILE
master_verify_checksum = OFF
max_allowed_packet = 4194304
max_binlog_cache_size = 18446744073709547520
max_binlog_size = 1073741824
max_binlog_stmt_cache_size = 18446744073709547520
max_connect_errors = 100
max_connections = 151
max_delayed_threads = 20
max_error_count = 64
max_heap_table_size = 16777216
max_insert_delayed_threads = 20
max_join_size = 18446744073709551615
max_length_for_sort_data = 1024
max_prepared_stmt_count = 16382
max_relay_log_size = 0
max_seeks_for_key = 4294967295
max_sort_length = 1024
max_sp_recursion_depth = 0
max_tmp_tables = 32
max_user_connections = 0
max_write_lock_count = 4294967295
metadata_locks_cache_size = 1024
metadata_locks_hash_instances = 8
min_examined_row_limit = 0
multi_range_count = 256
myisam_data_pointer_size = 6
myisam_max_sort_file_size = 107374182400
myisam_mmap_size = 18446744073709551615
myisam_recover_options = OFF
myisam_repair_threads = 1
myisam_sort_buffer_size = 93323264
myisam_stats_method = nulls_unequal
myisam_use_mmap = OFF
named_pipe = OFF
net_buffer_length = 16384
net_read_timeout = 30
net_retry_count = 10
net_write_timeout = 60
new = OFF
old = OFF
old_alter_table = OFF
old_passwords = 0
open_files_limit = 6209
optimizer_prune_level = 1
optimizer_search_depth = 62
optimizer_switch = index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
optimizer_trace = enabled=off,one_line=off
optimizer_trace_features = greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit = 1
optimizer_trace_max_mem_size = 16384
optimizer_trace_offset = -1
performance_schema = ON
performance_schema_accounts_size = 100
performance_schema_digests_size = 10000
performance_schema_events_stages_history_long_size = 10000
performance_schema_events_stages_history_size = 10
performance_schema_events_statements_history_long_size = 10000
performance_schema_events_statements_history_size = 10
performance_schema_events_waits_history_long_size = 10000
performance_schema_events_waits_history_size = 10
performance_schema_hosts_size = 100
performance_schema_max_cond_classes = 80
performance_schema_max_cond_instances = 3504
performance_schema_max_file_classes = 50
performance_schema_max_file_handles = 32768
performance_schema_max_file_instances = 6770
performance_schema_max_mutex_classes = 200
performance_schema_max_mutex_instances = 15906
performance_schema_max_rwlock_classes = 40
performance_schema_max_rwlock_instances = 9102
performance_schema_max_socket_classes = 10
performance_schema_max_socket_instances = 322
performance_schema_max_stage_classes = 150
performance_schema_max_statement_classes = 168
performance_schema_max_table_handles = 4000
performance_schema_max_table_instances = 12500
performance_schema_max_thread_classes = 50
performance_schema_max_thread_instances = 402
performance_schema_session_connect_attrs_size = 512
performance_schema_setup_actors_size = 100
performance_schema_setup_objects_size = 100
performance_schema_users_size = 100
pid_file = C:\ProgramData\MySQL\MySQL Server 5.6\data\LT0018468.pid
plugin_dir = C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\
port = 3306
preload_buffer_size = 32768
profiling = OFF
profiling_history_size = 15
protocol_version = 10
proxy_user =
pseudo_slave_mode = OFF
pseudo_thread_id = 21
query_alloc_block_size = 8192
query_cache_limit = 1048576
query_cache_min_res_unit = 4096
query_cache_size = 0
query_cache_type = OFF
query_cache_wlock_invalidate = OFF
query_prealloc_size = 8192
rand_seed1 = 0
rand_seed2 = 0
range_alloc_block_size = 4096
read_buffer_size = 65536
read_only = OFF
read_rnd_buffer_size = 262144
relay_log =
relay_log_basename =
relay_log_index =
relay_log_info_file = relay-log.info
relay_log_info_repository = FILE
relay_log_purge = ON
relay_log_recovery = OFF
relay_log_space_limit = 0
report_host =
report_password =
report_port = 3306
report_user =
rpl_stop_slave_timeout = 31536000
secure_auth = ON
secure_file_priv =
server_id = 0
server_id_bits = 32
server_uuid = 29c4013c-9cb8-11e4-8622-18cf5eaf20f7
shared_memory = OFF
shared_memory_base_name = MYSQL
skip_external_locking = ON
skip_name_resolve = OFF
skip_networking = OFF
skip_show_database = OFF
slave_allow_batching = OFF
slave_checkpoint_group = 512
slave_checkpoint_period = 300
slave_compressed_protocol = OFF
slave_exec_mode = STRICT
slave_load_tmpdir = C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
slave_max_allowed_packet = 1073741824
slave_net_timeout = 3600
slave_parallel_workers = 0
slave_pending_jobs_size_max = 16777216
slave_rows_search_algorithms = TABLE_SCAN,INDEX_SCAN
slave_skip_errors = OFF
slave_sql_verify_checksum = ON
slave_transaction_retries = 10
slave_type_conversions =
slow_launch_time = 2
slow_query_log = OFF
slow_query_log_file = LT0018468-slow.log
socket = MySQL
sort_buffer_size = 262144
sql_auto_is_null = OFF
sql_big_selects = ON
sql_buffer_result = OFF
sql_log_bin = ON
sql_log_off = OFF
sql_mode = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql_notes = ON
sql_quote_show_create = ON
sql_safe_updates = OFF
sql_select_limit = 18446744073709551615
sql_slave_skip_counter = 0
sql_warnings = OFF
ssl_ca =
ssl_capath =
ssl_cert =
ssl_cipher =
ssl_crl =
ssl_crlpath =
ssl_key =
storage_engine = InnoDB
stored_program_cache = 256
sync_binlog = 0
sync_frm = ON
sync_master_info = 10000
sync_relay_log = 10000
sync_relay_log_info = 10000
system_time_zone = India Standard Time
table_definition_cache = 1400
table_open_cache = 2000
table_open_cache_instances = 1
thread_cache_size = 10
thread_concurrency = 10
thread_handling = one-thread-per-connection
thread_stack = 262144
time_format = %H:%i:%s
time_zone = SYSTEM
timed_mutexes = OFF
timestamp = 1432622922.713113
tmp_table_size = 51380224
tmpdir = C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
transaction_alloc_block_size = 8192
transaction_allow_batching = OFF
transaction_prealloc_size = 4096
tx_isolation = REPEATABLE-READ
tx_read_only = OFF
unique_checks = ON
updatable_views_with_limit = YES
version = 5.6.19
version_comment = MySQL Community Server (GPL)
version_compile_machine = x86_64
version_compile_os = Win64
wait_timeout = 28800
warning_count = 0

No Expire Freeware

126 0 / Create an account to join the discussion.
Enric_Naval
Follow / 25 Feb 2015 at 10:18am / Toad for MySQL
Latest post by on 25 May 2015 at 3:57pm

"Format code" doesn't understand SEPARATOR?

Expand content
"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR: For example: SELECT level , GROUP_CONCAT(code SEPARATOR ' ' ) FROM Logs GROUP BY level; SEPARATOR...

"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR:

For example:

SELECT
level
, GROUP_CONCAT(code SEPARATOR ' ')
FROM Logs
GROUP BY level;

SEPARATOR is valid since at least MySQL 4.1: http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html#function_group-concat

This bug exists since beta 7.0 http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/f/90/t/20717.aspx

Answered 5038 2 / Create an account to join the discussion.
foobarjohnny
Follow / 21 May 2015 at 7:02pm / Toad for MySQL
Latest post by on 24 May 2015 at 4:51pm

[Bug Report] "Find Previous .." is missing.

Expand content
Can not see the "Find Previous ..." command under menu Edit --> Find and Replace, there only has "Find Next ..." command. And in the Options --> Environment --> Keyboard...

Can not see the "Find Previous ..." command under menu Edit --> Find and Replace, there only has "Find Next ..." command.

And in the Options --> Environment --> Keyboard, it has not "Find Previous" under EditMenu.

Toad for MySQL version is 7.5.0.966.

800 2 / Create an account to join the discussion.
reman37
Follow / 4 Feb 2014 at 9:07am / Toad for MySQL
Latest post by on 24 May 2015 at 2:44am

Toad on mysql for linux: almost there

Expand content
I was able to install toad for mysql on linux (Kubuntu 13.10). It starts and I can connect to a database. Unfortunately whene toad try to draw a grid I obtain an exception. So fa I was not able to...

I was able to install toad for mysql on linux (Kubuntu 13.10).

It starts and I can connect to a database. Unfortunately whene toad try to draw a grid I obtain an exception.

So fa I was not able to solve it and I don't find any good reference online.

Any idea?

System.ArgumentException
Parameter is not valid.
Stack Trace:
   at System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
   at DevExpress.Data.Utils.ImageTool.ImageFromStream(Stream stream)
   at DevExpress.XtraEditors.Drawing.LoadingAnimator.get_LoadingImage()
   at DevExpress.XtraGrid.Views.Base.ColumnView.get_LoadingAnimator()
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawLoadingIndicator(GridViewDrawArgs e, GridColumnInfoArgs ci)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawColumnIndicator(GridViewDrawArgs e)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawColumnPanel(GridViewDrawArgs e)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.DrawContents(GridViewDrawArgs e)
   at DevExpress.XtraGrid.Views.Grid.Drawing.GridPainter.Draw(ViewDrawArgs ee)
   at DevExpress.XtraGrid.Views.Base.BaseView.Draw(GraphicsCache e)
   at DevExpress.XtraGrid.GridControl.OnPaint(PaintEventArgs e)
   at DevExpress.Utils.Drawing.ControlPaintHelper.PaintWithErrorHandling(PaintEventArgs paintEventArgs, Int32 layer)
   at DevExpress.Utils.Drawing.ControlPaintHelper.ProcessWMPaint(Message& m)
   at DevExpress.XtraGrid.GridControl.CheckProcessMsg(Message& m)
   at DevExpress.XtraGrid.GridControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

6132 4 / Create an account to join the discussion.
AMDWEBSITES
Follow / 8 Apr 2012 at 5:56pm / Toad for MySQL
Latest post by on 20 May 2015 at 9:14am

Connection Error - "Unable to connect to any of the specified...

Expand content
Hi there, I hope you can help, as I'm almost pulling my hair out!! I've set up a MySQL database through my host tsohost and tried to connect to it via TOAD but am constantly getting the error message...

Hi there,

I hope you can help, as I'm almost pulling my hair out!!

I've set up a MySQL database through my host tsohost and tried to connect to it via TOAD but am constantly getting the error message "Unable to connect to any of the specified MySQL hosts."

I've checked all my details and entered them correctly. I've also checked that my Port 3306 is open. I'm at a loss as to what is wrong...

These are the details I have from my host:

Hostname: 10.168.1.** (also tried the default localhost)
Connection Method: TCP
Database Version: MySQL 5
Database Name: amd_****
Database Username: amd_****
PAssword: ****

Can you please help?

9002 4 / Create an account to join the discussion.
foobarjohnny
Follow / 20 May 2015 at 8:58am / Toad for MySQL

[Bug report] Toad for MySQL write UTF-8 as UTF-8 BOM

Expand content
In Toad For MySQL windows version, set "File encoding type" to Unicode(UTF-8) inside Options --> Editor --> General, and open an UTF-8 script file such as test.sql, then modify and save...

In Toad For MySQL windows version, set "File encoding type" to Unicode(UTF-8) inside Options --> Editor --> General, and open an UTF-8 script file such as test.sql, then modify and save it, the file's encoding type become "UTF-8 BOM" instead of UTF-8, because it adds hex data "EF BB BF" at the beginning of file.

This results in that the UTF-8 BOM script file can not be recognized correctly by Toad Mac Edition and MySQL WorkBench for windows.

BTW, dbForge Studio has the same problem too, it seems that it is an Windows API issue, but MySQL WorkBench and EditPlus 3 and Notpad++ can correctly save file as UTF-8 instead of UTF-8 BOM under Windows.

The Toad For MySQL version number is 7.5.0.966.

900 0 / Create an account to join the discussion.
jhaustein
Follow / 20 May 2015 at 8:28am / Toad for MySQL

mysql database error

Expand content
hi i try to create an connection to my database with toad to my provider now i get this error message Der angeforderte Name ist gültig, es wurden jedoch keine Daten des angeforderten Typs...

hi

i try to create an connection to my database with toad to my provider

now i get this error message

Der angeforderte Name ist gültig, es wurden jedoch keine Daten des angeforderten Typs gefunden

151 0 / Create an account to join the discussion.
Brad Wulf
Follow / 19 May 2015 at 11:06pm / Toad for MySQL

Community Question – Toad MySQL for Amazon RDS

Expand content
Are you using Toad to connect to MySQL or Aurora instances hosted on Amazon RDS? If so, what is working/what isn’t working? Answer in the comments below!

Are you using Toad to connect to MySQL or Aurora instances hosted on Amazon RDS?  If so, what is working/what isn’t working?

Answer in the comments below!

918 0 / Create an account to join the discussion.
dungneogame_437
Follow / 11 Mar 2014 at 2:46am / Toad for MySQL
Latest post by on 18 May 2015 at 4:13pm

Toad for MySQL 6 and 7 unicode Not working

Expand content
Before i use Toad for MySQL ToadforMySQL_Freeware_4.6.0.531 it working with unicode normal Ex: addr NVARCHAR(400) NOT NULL, INSERT abc (addr) VALUES('Thái Hà - Hà Nội'); -...

Before i use Toad for MySQL ToadforMySQL_Freeware_4.6.0.531  it working with unicode normal 
Ex:  
  addr NVARCHAR(400) NOT NULL,
  INSERT abc (addr) VALUES('Thái Hà - Hà Nội');
--->  addr:  Thái Hà - Hà Nội
But when i update to ToadforMySQL 6 or 7
--->  addr:  Th?i H? - Hà N?i 

Anyone can say for me WHY ??????????????????????

5288 1 / Create an account to join the discussion.
benyitzhaki
Follow / 6 May 2015 at 1:59pm / Toad for MySQL

Compare schemas - can i produce clean "alter" statements...

Expand content
I'm struggling with an issue when trying to compare schemas of two mysql databases. I'll explain with an example: I have added an index to one of the columns, something that should have been...

I'm struggling with an issue when trying to compare schemas of two mysql databases. I'll explain with an example:

I have added an index to one of the columns, something that should have been summed as something like:

ALTER TABLE `tablename`

ADD INDEX `index_name` (`column_name`);

And instead.. it wants me to do the whole "create temp table, copy data to temp table, drop original table,rename temp table to original table name".. that's crazy and moreover, it might (and will) lead to some downtime when trying to update a production db.

Is there a way to change that behavior?

Thanks

1783 0 / Create an account to join the discussion.
UTTAM POWAR
Follow / 2 May 2015 at 11:01am / Toad for MySQL

connection time out while connecting.

Expand content
I have mysql database connect it with database via toad 7.3 mysql Problem is that, It doesnot connect without internet services run. Is it possible to connect it without running internet service ...

I have mysql database connect it with database via toad 7.3 mysql

Problem is that, It doesnot connect without internet services run.

Is it possible to connect it without running internet service

Let me know setting if any

1871 0 / Create an account to join the discussion.
akshay
Follow / 3 Oct 2014 at 9:34am / Toad for MySQL
Latest post by on 15 Apr 2015 at 12:03pm

Attempted to read past the end of the stream MySQL Database Error

Expand content
With Toad for MySQL 7.3 I am now unable to connect to a DB (ssh) which I was able to connect to with the 7.2 version and no details have changed. I keep getting the following error: "Attempted to...

With Toad for MySQL 7.3 I am now unable to connect to a DB (ssh) which I was able to connect to with the 7.2 version and no details have changed. I keep getting the following error:

"Attempted to read past the end of the stream".

Can someone please help to resolve this issue

Unanswered 5463 1 / Create an account to join the discussion.
Swapnil Ronghe
Follow / 14 Apr 2015 at 10:02am / Toad for MySQL
Latest post by on 14 Apr 2015 at 1:14pm

sql join query taking too much time to execute in mysql

Expand content
taking too much time to execute sql join query in toad for mysql

taking too much time to execute sql join query in toad for mysql

2591 1 / Create an account to join the discussion.
jaybonk_218
Follow / 14 Jun 2010 at 7:54pm / Toad for MySQL
Latest post by on 12 Apr 2015 at 6:01pm

Object Explorer doesn't show all stored procedures

Expand content
I created a procedure and when I went to view it in the object explorer tab for procedures, it wasn't visible in the list. This is the only procedure in this particular database, but if I do a select...

I created a procedure and when I went to view it in the object explorer tab for procedures, it wasn't visible in the list.  This is the only procedure in this particular database, but if I do a select from information_schema.routines it shows up, along with the list of procedures in other databases.

I've dropped and created the procedure a number of times, each time it says executed successfully, and shows up in information_schema, just not in the object explorer.

5530 4 / Create an account to join the discussion.
NioZero
Follow / 12 Feb 2015 at 7:17pm / Toad for MySQL
Latest post by on 10 Apr 2015 at 3:01pm

Download Older version

Expand content
Hi, i want to download an older version of Toad for MySql. I installed the last version but when i try to connect to one of our databases it shows the message "Authentication with old password no...

Hi, i want to download an older version of Toad for MySql. I installed the last version but when i try to connect to one of our databases it shows the message "Authentication with old password no longer supported, use 4.1 style passwords". Older version of Toad has no problem connecting to the database

What is the last version when old password where supported and if possible to have a download link please?

Answered 5882 9 / Create an account to join the discussion.
dennis7
Follow / 9 Apr 2015 at 2:24pm / Toad for MySQL

Change colors of Database Diagram tables?

Expand content
Hi, Is there any way to change the colors used in the Database Diagrams? With the default color scheme, I cannot even read the names of the tables on a printout. Thanks!

Hi,

Is there any way to change the colors used in the Database Diagrams? With the default color scheme, I cannot even read the names of the tables on a printout.

Thanks!

Unanswered 2808 0 / Create an account to join the discussion.
CMT18
Follow / 7 Apr 2015 at 9:19am / Toad for MySQL

Reverse Engineer Table/FK question

Expand content
Hi, When extract DDL from a schema, Is there a way to separate between the table and its foreign keys? I would want the create Foreign Keys to be separate since I would want to create all the tables...

Hi,

When extract DDL from a schema, Is there a way to separate between the table and its foreign keys?

I would want the create Foreign Keys to be separate since I would want to create all the tables first

and then create all the foriegn keys without worrying that FK create may fail since the ref table was not created first ?

2976 0 / Create an account to join the discussion.