I was searching for documentation on exporting the database by means of phpMyAdmin in combination with the usage of BigDump.php. I found following article in the Knowledge base section which is great Transferring Your Board to a New Host or Domain
However, I need some support as I am still missing some information regarding the export settings when using phpMyAdmin. I have marked the missing information with a
I am using phpMyAdmin 188.8.131.52-Debian-11 / MySQL client version: 5.0.84
“Select All” and tick radio button “SQL” Knowledge Base Article
SQL options section
Add custom comment into header (\n splits lines) -> leave open?
Enclose export in a transaction -> tick/untick checkbox?
Disable foreign key checks-> tick/untick checkbox?
SQL compatibility mode -> What setting?
Structure -> tick
Add DROP TABLE / DROP VIEW -> tick Knowledge Base Article
Add IF NOT EXISTS-> tick/untick checkbox?
Add AUTO_INCREMENT value -> tick/untick checkbox?
Enclose table and field names with backquotes -> tick/untick checkbox?
Add into comments section
Creation/Update/Check dates -> tick/untick checkbox?
Data -> tick Knowledge Base Article
Complete inserts -> tick Knowledge Base Article
Extended inserts - untick Knowledge Base Article
Maximal length of created query -> what value?
Use delayed inserts -> tick/untick checkbox?
Use ignore inserts -> tick/untick checkbox?
Use hexadecimal for binary fields -> tick/untick checkbox?
Export type -> INSERT
Save as file section
Save as file -> tick
File name template -> _DB_ Knowledge Base Article
Compression -> What setting?