How to export ~20 million records per 20 GB from PhpMyAdmin?

Question

PHP

Tell me how to export ~20 million records per 20 GB from PhpMyAdmin? When you try to export the request, it takes about 2 minutes, after which it falls into an error.

Answer 1

ssh only.

Answer 2

Export not through phpMyAdmin but through consor or remove time limits for script execution.

Answer 3

mysqldump for example. If without a lock, then you need to add the key "--single-transaction". For the rest of the keys in man.