CSV Import - Export long text to MySQL

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

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!

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