Solve the problem of secure-file-priv option when importing and exporting mysql data

Mysql database imports or exports from a file to a file, prompting The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. The reasons and solutions are as follows:

Some versions of mysql have restrictions on import and export through files, which are not allowed by default.

View the configuration and execute the mysql command

Bing daily picture api official interface

Bing daily picture official interface:

https://www.bing.com/HPImageArchive.aspx?format=js&idx=0&n=8

Among them, format can choose xml and js (json)

idx represents the data of several days forward, 0 is the current day, 1 is the previous day

n represents the number of pictures returned each time, the maximum is 8

Using idx and n in combination, the test returns data 15 days before the current date at the earliest. 

Return results:

Subscribe to Technical