Support » Plugin: Tabulate » Export to CSV not working

  • velu0303

    (@velu0303)


    When I am trying to export the data of a table to CSV using the button CSV, it throws an error,
    An error occured
    Unable to write to temporary directory /var/lib/mysql-files/

    kindly help me on this..

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author samwilson

    (@samwilson)

    Does your MySQL user have write access to that directory? Does it have the FILE privilege on the database server?

    There are more details here:

    https://tabulate.readthedocs.io/en/latest/faq.html#what-reasons-exist-for-the-unable-to-create-temporary-export-file-error

    You could try changing the temp directory to another one.

    velu0303

    (@velu0303)

    Thank You for your quick response..
    I am a Beginner in this aspect..
    Can you guide me, Where and how should we give GRANT.. or where should I add this line..?
    GRANT FILE ON *.* to db_user@localhost

    Plugin Author samwilson

    (@samwilson)

    You could try changing your temp directory by putting this in your wp-config.php:

    define( 'WP_TEMP_DIR', ABSPATH . 'wp-content/tmp/' );
    

    Other than that, you should ask your database administrator about granting FILE privilege to your user.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export to CSV not working’ is closed to new replies.