My database has 1.9G, how can I export a file of 100M in batches
光阴似箭催人老，日月如移越少年。
Set the number of rows exported each time, such as id1 to id10000
What, mysql migration. If the version is high enough, just copy and paste the physical files.
tar czf <Database file directory>|split -b 100m -d -x 1 <Package name>.
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.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Set the number of rows exported each time, such as id1 to id10000
What, mysql migration. If the version is high enough, just copy and paste the physical files.
tar czf <Database file directory>|split -b 100m -d -x 1 <Package name>.
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.