MySQL Insert

Try for free

Developed by

Petr Cermak

This act takes a crawler execution and inserts it's results into a remote MySQL database.

0.0 (0)

Pricing

Pay per usage

Total users

Monthly users

Last modified

2 years ago

Developer tools

Integrations

Open source

Back to issues Create new issue

JSON example not working in JSON editor

Closed

stizzi opened this issue

I copied the JSON example into the JSON box, updated the connection details to my remote mySQL DB. There is an error that says "Error: Cannot start actor run (Field "connection" is required)"

Paulo Cesar (pocesar)

can you show me a task or run that you're having issues?

stizzi

Sure. I'm copying this into "JSON" and hitting run.

{ "connection": { "host" : "hostname", "user" : "admin", "password" : "pass", "database" : "dbname", // optional "port" : 3306 // optional }, "table": "test", "rows": [ {"column_1": "value_1", "column_2": "value_2"}, {"column_1": "value_3", "column_2": "value_4"} ] }

Paulo Cesar (pocesar)

that's just an example of how the input should look like, JSON doesn't allow comments, //optional are comments

Add comment

PostgreSQL Insert

petr_cermak/PostgreSQL-insert

This act takes a crawler execution and inserts it's results into a remote PostgreSQL database.

Petr Cermak

Microsoft SQL Server Insert

petr_cermak/MSSQL-insert

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

Petr Cermak

Backup MySQL Database - Google drive Integration

worldunboxer/backup-mysql-database

Effortlessly back up your MySQL database with our Apify actor. It securely connects to your database, generates full SQL backups, and stores them on Google Drive, FTP servers, or Apify Key-Value Store. Ensure data safety with seamless storage and sharing options tailored to your needs.