Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

Mysql Connection problem

More
11 years 8 months ago #2273 by ESteban
Mysql Connection problem was created by ESteban
I want to import from cvs to mysql, I can read the cvs file but went I try to connect to mysql there is a problem. if I write the servername, user and password and test de connection is ok but went I select the database I got an error and is no posible to connect.
the error is : connection could not be established, bad handshake, the problem is the same with any of mysql databases

Thanks
Esteban

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #2274 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Mysql Connection problem
Hi Esteban,

In case you use an older version than 2.2.0 please try to use the current version 2.5.1. The MySQL Bad Handshake issue for MySQL version 5.5 was solved with version 2.2.0.

In case this does not solve your problem please post your used FlowHeater and also your used MySQL Server version.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #2275 by ESteban
Replied by ESteban on topic Re:Mysql Connection problem
yes, I update to 2.5 and works fine, the only problema I still have is I dont want to import the quotation mark "" which is in all columns. is there a way to delete with flowheater before import to database, I tried with the option "without" but nothing change

thank you
Esteban

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #2276 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Mysql Connection problem
Hi Esteban,

You just have to use the option "abc".

This means

On the READ side, importing) Are in your CSV file the data enclosed by quotation marks FlowHeater removed this during the import process.

On the WRITE side, exporting) FlowHeater enclose your data with quotation marks during the export.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Time to create page: 0.262 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.