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: CSV Import - Export long text to MySQL

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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
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:CSV Import - Export long text to MySQL 5 years 4 months ago #2140

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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!
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:CSV Import - Export long text to MySQL 5 years 4 months ago #2141

  • Gabe
  • Gabe's Avatar
  • Offline
  • New Member
  • Posts: 1
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
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.071 seconds