Dynamic data import / export

datenbank

simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: CSV Import - Export long text to MySQL

CSV Import - Export long text to MySQL 5 years 9 months ago #2139

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 261
Hello,

Is there anyway to export long text from a csv file to mysql? I have only been able to export a small amount of text. My database table structure is setup for long text but there is not an option for it in Flowheater.

Thanks,
Gabe
Request via Email

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

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.

Re:CSV Import - Export long text to MySQL 5 years 9 months ago #2140

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Administrator
  • Administrator
  • Posts: 261
Hi Gabe,

You do not need any option! FlowHeater can import/export long text without any further settings.

There are two possible reasons why you can't import/export large text from/into your MySQL database.
  1. You use an incorrect MySQL data type!
    Here are how many byte / characters can store the MySQL data types
    • TEXT 65,535 characters
    • MEDIUMTEXT 16,777,215 characters
    • LONGTEXT 4,294,967,295 characters
    Please be sure you use the correct MySQL data type.
  2. The MySQL parameter "max_allowed_packet" are too small for your data you want to import/export. Please try to increase the parameter "max_allowed_packet" in the mysql ini (my.ini) file.
    e.g.
    max_allowed_packet=10M

    Sets the maximum packet size for each SQL statement to 10 Megabyte! After changing this parameter you have to restart your MySQL databases server and try it again.

Hope this helps!

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

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.

Re:CSV Import - Export long text to MySQL 5 years 9 months ago #2141

Thanks for getting back to me on this. I figured it out and it was my own fault. My actual csv file didn't have the complete text so FlowHeater couldn't upload it. Sorry for the hassle.

Gabe

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

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.089 seconds