Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Problem reading-in an auto-populated .csv / .txt from localhost

mars's profile image mars posted 1 month ago in Import/Export Permalink

HeidiSQL 11.0.0.5919 connected on localhost 127.0.0.1

I created a database with 2 tables with column names and field attributes that is supposed to be loading in data from a .csv file located in localhost root. The .csv files in the root directory are being auto-populated via a HTTP POST from a running application. The one of the tables is populating properly to mirror its .csv file source; however, the second table is not populating to mirror its file source.

I did run into errors below when running mysql_upgrade, but I don't know if it is related.

Repairing tables mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist status : Operation failed mysql.slave_master_info Error : Table 'mysql.slave_master_info' doesn't exist status : Operation failed mysql.slave_relay_log_info Error : Table 'mysql.slave_relay_log_info' doesn't exist status : Operation failed mysql.slave_worker_info Error : Table 'mysql.slave_worker_info' doesn't exist status : Operation failed Upgrade process completed successfully.

Can anyone help?

Thanks in advance.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.