mysql - How does phpmyadmin export data in sections?

Question

My database has 1.9G, how can I export a file of 100M in batches

Answer 1

Set the number of rows exported each time, such as id1 to id10000

Answer 2

What, mysql migration. If the version is high enough, just copy and paste the physical files.

Answer 3

tar czf <Database file directory>|split -b 100m -d -x 1 <Package name>.

Answer 4

If you just want to back up to other machines, just rsync. My MySQL is now built in a docker container. When working as a master and slave, I can directly rsync to other machines, which is very fast.