What permissions does MariaDB need to write files?
Also, MariaDB needs permission to write files in the specified location. If the secure_file_priv system variable is set to a non-empty directory name, the file can only be written to that directory. ...
How do I transfer data from one MariaDB server to another?
In cases where you have two servers using different character-sets, using SELECT INTO OUTFILE to transfer data from one to the other can have unexpected results. To ensure that MariaDB correctly interprets the escape sequences, use the CHARACTER SET clause on both the SELECT INTO OUTFILE statement and the subsequent LOAD DATA INFILE statement. ...
What is the difference between select into outfile and select into dumpfile?
MariaDB Icon.png
