You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL great and have the most points for this month!
Installed new Toad for MySQL 7.7. Imported connections from Toad 7.0.
I am unable to connect to any of my pre-defined connections which still work in Toad 7.0.
Newly created connections do not work either. I have 105 MySQL servers on linux which i administrate
and so far Toad 7.7 has gone backwards and is useless to me.
87 MySQL servers are MySQL Enterprise 5.7 and the remaining units are Enterprise 5.6
i tried to copy rows from result sets grid to excel with hot keys(ctrl+A ,ctrl+C, ctrl+V),
there are 175rows in result sets grid,but only copied 104rows to excel,
this pb exists in both v7.3 and v7.7,
is this a bug?or did i miss configuring something?
thanks in advance.
I'm using Toad for Mysql 22.214.171.1249. When i connection to a db, and right click on a table, and select alter table, and then go to the columns list, and click on a column, the collation property 1) does not show the current collation setting for that column 2) does not list the available collations when i click on the drop down on the combo box to show the contents of the combo box.
Is this an unsupported operation, or am I missing something?
Here's a screen shot. You can see the collation is set to utf8_unicode_ci in the create table sql behind the dialog, but the alter table dialog shows nothing.
Well looks like this is a common problem. I am running a mySQL instance on a Linux Server (CentOS) and my mySQL DB is running at port 3306. When ever I try to configure a new connection from my ToadformySQL , it gives error saying "unable to connect to any of the mySQL host specified". I am using TCP as connection type , then I hv supplied the username and password and spefied the port. I have also checked that the port is not blocked in the server(remote) and the user I am trying to connect as is having all the required privilege. I am using WIn8 as my client machine.
Has anybody ran into same issue? what may be the probable solution?
When you have multiple iterations of the same field and you want to query only on the most current one, is there a specific function or command that can help me with this?
I have this problem since version 6 on windows 7, I thought it would be resolved but I've tried with the newest version and I'm still having the same problem.
I've already change some options but nothing happens.
Is there any solution to this?
I attach a screen capture of the error, I hope some one could resolve or something like that. I'd be very very thankful to someone who has been able to resolve this problem.
I am new to this software and would like to know how to connect it to a Raspberry Pi 2.
I created a report using report manager. I have multiple databases that are the same schema, but have data for different companies. I need to run this report on each company, but I can't find where the report has the connection information. When I created the report, it was pulling data from one company, but now each time I open it, it pulls the data from another company.
How can I change the database source on the report?
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
I am using load data to import several csv files. These imports will eventually be scheduled to run every night, so I was wondering if there is a way to log ALL the warnings/errors that might occur. When I run the scripts maually, I can see (some of) the erros/warnings int the messages tab, but I would need to store this in a table.
I'm setting up import automation scripts. In my template, I have checked the option "If error occurs, save unimported rows to a discard file". Now, each row that cannot be imported (e.g. because of data type conversion errors) gets reported twice in the output csv file.
Any idea how this can be fixed?
need your help i got some error when try connect to mysql server via Toad Mysql, i got error "Mysql Database error Attempted to read past the end of the stream."
also i included with capture error from toadmysql.
thanks your time for answer my question.
Using Toad for MySQL 126.96.36.1999: Is there a way to turn off or disable the toad option: environment - Grid - Data formatting such that the automatic data formatting will not apply? I want an need to use the format options that SQL commands have available to format the data into different presentations for similar data in the same query. For example date, I have say 4 different date time fields that I want to display in a single query. I want to be able to use DATE_FORMAT to display the date of one column in one format, then a different format for second column and a third format for a the third column. I just need to be able to turn off or disable the drid data formation function so that I can apply the SQL command format output.
I am currently trying to integrate Linux services into my Windows environment and have installed MariaDB with PAM authentication following the guidance from MariaDB.
I have tested successfully on the box (using putty) that I can authenticate using my AD credentials, however when I try to login via Toad I get the following error:
Client does not support authentication protocol requested by server; consider upgrading MariaDB client
I have tried adding the line pam-use-cleartext-plugin to the conf file and restarting the server but no joy. I have downloaded HeidiSQL and confirmed that its use of libmysql.dll means that it can use the PAM authentication. It looks like toad for MySQL utilises myodbc.dll - any ideas how to work around this? I love toad and would much rather be able to use it
Why am I getting the table name duplicated when I build a simple SELECT statement with the Query Builder?
SELECT film.title, film.description FROM film film
It also happens when I do a join:
SELECT film.title, film.description, actor.last_name, actor.first_name FROM (film_actor film_actor INNER JOIN actor actor ON (film_actor.actor_id = actor.actor_id)) INNER JOIN film film ON (film.film_id = film_actor.film_id)
It's annoying! Using TOAD for MySQL 188.8.131.529
Thanks in advance...
Is somebody knows, how to cover this bug in the "Schema compare"?
Current version is "Toad for MySQL 184.108.40.2069", and i faced it every time i used "Schema compare" last two years.
I would like to use Toad for MySQL from USB flash drive.
It should run on various (Win 7 based) computer even those where it was originally NOT installed.
This seems to be currently not possibly.
Are there some missing driver installations or Registry entries?
Is there a way to make it portable?
While messing with the field list (explorer) and properties toolbars in the report design view they both disappeared and I cannot find a way to restore them. I tried uninstal/reinstal but that didn't work. If anyone could give me some tips it'd be much appreciated.
It looks like I unpinned the field and properties toolbars on the right of the report preview and closed the windows. Unfortuantely I'm not seeing a way to re-enable them - none of the view or tool options restore them.
Steps to reproduce:
1. Make connection
2. go to tools -> Reports -> Data Report
3. Standard Report -> Enter simple query -> Move fields over to "Fields to Display" and click the "finish" button
4. On the right side of the report you should see a field list and properties menu. This is what's missing - not sure how to get them back.
Any help would be appreciated. Thanks..