Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Mysql Connection problem

Mysql Connection problem 3 years 9 months ago #2273

  • ESteban
  • ESteban's Avatar
  • Offline
  • New Member
  • Posts: 2
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
The administrator has disabled public write access.

Re:Mysql Connection problem 3 years 9 months ago #2274

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

Re:Mysql Connection problem 3 years 9 months ago #2275

  • ESteban
  • ESteban's Avatar
  • Offline
  • New Member
  • Posts: 2
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
The administrator has disabled public write access.

Re:Mysql Connection problem 3 years 9 months ago #2276

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.083 seconds