MySQL Forum - MySQL - Toad World

MySQL Forum

MySQL Community

 

NOTE: This forum is for non-product questions and discussions on the MySQL database platform.
 
Please post Toad-family product questions in their respective product forums.  Thanks!

 

Community Discussion

ohare0314
Follow / 27 May 2016 at 10:02pm / MySQL

New to Toad Data Point

Expand content
Hi! I am a new data analyst for konami gaming and will be using toad data point to help me with the analysis of data. I was wondering what suggestions you might have to help me get familiar with the software...

Hi! I am a new data analyst for konami gaming and will be using toad data point to help me with the analysis of data. I was wondering what suggestions you might have to help me get familiar with the software.

7 0 / Create an account to join the discussion.
FranzS
Follow / 17 May 2016 at 7:39am / MySQL
Latest post by Anonymous on 17 May 2016 at 8:29am

SSH Connect to DB without password (unix_socket auth) using root user...

Expand content
Hello, I've already used Toad for mysql using ssh connections using passwords to connect as root to the database. Now as I want to secure the connections to the DB I'm wondering if it is possible...

Hello,

I've already used Toad for mysql using ssh connections using passwords to connect as root to the database.

Now as I want to secure the connections to the DB I'm wondering if it is possible to connect to the Database using the unix_socket authentication via ssh.

I guess it would work if I would connect as "root" to the server via ssh and leave the password empty.

The problem that arises is that I'm using Ubuntu and as most of you know there is no root user, but I did not found a sudo option in the connection.

Anyone knows if it is possible to do what i'm thinking about?

Maybee just a "sudo" checkbox is missing in the ssh options in Toad, but I'm not sure.

Kind Regards

/FranzS

Unanswered 48 1 / Create an account to join the discussion.
wood1e
Follow / 21 Mar 2016 at 2:22pm / MySQL

how to open a .sql 2 file

Expand content
Hi, I have been confused by a colleague who sent me an .sql 2 file, I belive it is a an archive file? Anyway, I can't open with TextEditor or any other software. Even the mighty Toad?!?! :) What...

Hi,

I have been confused by a colleague who sent me an .sql 2 file, I belive it is a an archive file?

Anyway, I can't open with TextEditor or any other software. Even the mighty Toad?!?! :)

What am I missing? Do I need ot extract or something similar?

Many thanks in advance

106 0 / Create an account to join the discussion.
Leigh Roy2
Follow / 28 Jan 2016 at 5:18am / MySQL

Importing large amounts of data eventually slows down which means...

Expand content
Hi, I have an issue whereby when I load either very large single files or massive amounts of small files if the amount of the data is too large then eventually the import slows down and even if it finishes...

Hi,

I have an issue whereby when I load either very large single files or massive amounts of small files if the amount of the data is too large then eventually the import slows down and even if it finishes I find that the import will have failed. This will happen typically speaking when the data size is around 1Gb. Can anybody help?


Kind regards,


Leigh

Unanswered 183 0 / Create an account to join the discussion.
flipside
Follow / 8 Dec 2015 at 5:03pm / MySQL

SSH Connection

Expand content
How can I make an ssh connection to to a remote server? SSH appears in the connection_type drop down, but how do I give it the key? I've tried tunneling through putty, but that doesn't work,...

How can I make an ssh connection to to a remote server?  SSH appears in the connection_type drop down, but how do I give it the key? 

I've tried tunneling through putty, but that doesn't work, either. It give me an "access denied" error.

183 0 / Create an account to join the discussion.
t.aichinger
Follow / 10 Oct 2015 at 11:44pm / MySQL

Toad for MySQL not working with IPv6

Expand content
I have Toad for MySQL 7.3.1.3290 and also tried it with 7.5.0.966 and found out that Toad for MySQL is not capable of using IPv6 connections. Can someone confirm that statment?

I have Toad for MySQL 7.3.1.3290 and also tried it with 7.5.0.966 and found out that Toad for MySQL is not capable of using IPv6 connections. Can someone confirm that statment?

Unanswered 317 0 / Create an account to join the discussion.
odar1291
Follow / 9 Dec 2014 at 3:50pm / MySQL
Latest post by on 9 Dec 2014 at 6:23pm

do not appear decimals value

Expand content
When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS) I tried: select cast(3/4 as decimal(8,2)) example but the result is example 0.00 and...

When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS)

I tried:

select cast(3/4 as decimal(8,2)) example

but the result is 

example

     0.00

and the real value do not appear

Unanswered 585 1 / Create an account to join the discussion.
chin tan oza
Follow / 24 Feb 2014 at 6:02am / MySQL

How to create local table .. like we have convert to local table option...

Expand content
Hi , Is there any way i can copy tables from Database( I only have read access) and convert it to local table?? why i need this... because i am not allowed to use join functions in queries as tables...

Hi ,

Is there any way i can copy tables from Database( I only have read access) and convert it to local table??

why i need this... because i am not allowed to use join functions in queries  as tables are large. hence i want to save some of database tables to local table and then i can define relationships and use join function.

Please help.

Regards,

Chintan Oza

1153 0 / Create an account to join the discussion.
jagbirsingh25_062
Follow / 20 May 2013 at 9:03am / MySQL

mysql query format

Expand content
i have two database values 1. runs 2. overs e.g. runs have value 1 and overs have 3 i want mysql query to display above two values in format 1/3 suggest me query , how to get this output. thanks jagbi...

i have two database values
1. runs
2. overs

e.g. runs have value 1 and overs have 3

i want mysql query to display above two values in format 1/3

suggest me query , how to get this output.
thanks
jagbir

959 0 / Create an account to join the discussion.
sparc
Follow / 11 May 2013 at 1:25am / MySQL

check constraint

Expand content
How to set check constraint for column, for example, was provided year from the employer greater than 15 and less than 45

How to set check constraint for column, for example, was provided year from the employer greater than 15 and less than 45

1063 0 / Create an account to join the discussion.
Milind
Follow / 12 Mar 2013 at 4:43am / MySQL

Procedures with DEFINER localhost not visible

Expand content
I am using Beta and do not see Procedures and Functions from remote (ISP) database whose definer is localhost. Only the procedures with definer '%' are seen. Is there a workaround for this?

I am using Beta and do not see Procedures and Functions from remote (ISP) database whose definer is localhost. Only the procedures with definer '%' are seen.

Is there a workaround for this?

1138 0 / Create an account to join the discussion.
RobGill
Follow / 5 Mar 2013 at 4:32pm / MySQL

Scheduled Tasks / Automation Scripts

Expand content
I created an Automation Script 'Automation_Script_HH_Data.tas' which runs several other Automation Scripts. This script runs well when I click Run Automation Script. However, if I add it to the...
I created an Automation Script 'Automation_Script_HH_Data.tas' which runs several other Automation Scripts. This script runs well when I click Run Automation Script. However, if I add it to the Scheduled Tasks, only the first Export Automation Script runs.

Please let me know what I am doing wrong. Thank you for your assistance.
Rob

HH_Book.tsm

HH_Book_Company.tsm

HH_Code_Description.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Furniture.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern.tsm

HH_Pattern_Alias.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern_Color.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern_Color_Book.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern_Color_Stock.tsm

SQL.zip

TAS.zip

TXP.zip

1431 0 / Create an account to join the discussion.
Becky
Follow / 26 Jan 2013 at 12:40am / MySQL
Latest post by on 28 Jan 2013 at 8:56pm

Getting Chinese Characters to work.

Expand content
Recently we've started receiving data in Chinese and are having trouble getting it to show up properly in our Databases. I'm generally importing CSV files from excel. But I've tried getting...
Recently we've started receiving data in Chinese and are having trouble getting it to show up properly in our Databases.

I'm generally importing CSV files from excel. But I've tried getting this to work by exporting the file from excel as unicode but that hasn't produced any results.

I've done some research but so far none of the solutions I've found work for me. I'm currently running version 6.3 of Toad. I can't get any changes in collation to save on the database level. And I've tried setting the collation to utf8 on every level that I can reach but it's still not working. Everything ends up reverting back into latin.

I've read a few places that I'd potentially need to change the collation on the server level. Which seems to only be something you can do when you create the server.

If anyone could give me some insight on what to try next I'd really appreciate it.
1321 1 / Create an account to join the discussion.
Belfor
Follow / 26 Jul 2011 at 7:41pm / MySQL
Latest post by on 12 Sep 2012 at 11:28am

No puedo Ver los Scrit de usuario en la optio "ver detalles&...

Expand content
Hola Todos, cuando intento ver el script de cualquier usuario por la opcion de "ver detalles" el toad me saca este error: You have an error in your SQL syntax; check the manual that corresponds...
Hola Todos, cuando intento ver el script de cualquier usuario por la opcion de "ver detalles" el toad me saca este error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@f0@@f1' at line 1

La version del motor de MySQL 5.1.41
Version del Toad es 5.0.0.345

Les agradezco la ayuda.

Saludos
1860 5 / Create an account to join the discussion.
MMaximov
Follow / 9 Jul 2012 at 4:36pm / MySQL

Access denied for user ''@'localhost' to database...

Expand content
Hi, Yesterday I downloaded and installed "Toad for mysql 6.3.0.642'. My installation is under Trial Version license. I'm using MySQL 5.5.20 After trying to debug a function, I received the...

Hi,

Yesterday I downloaded and installed "Toad for mysql 6.3.0.642'.
My installation is under Trial Version license.
I'm using MySQL 5.5.20
After trying to debug a function, I received the following messages:

1. MySQL Database Error: Access denied for user ''@'localhost' to database 'questsoftware'
2. MySQL Database Error: Access denied for user ''@'localhost' to database 'questdebug'

I don't know how to solve this issue.
I would be glad if anybody could help me in solving this issue.

Thank you in advance.

1736 0 / Create an account to join the discussion.