In some cases, SQL backups break exports into multiple files, usualy by table name.
I wanted to import all the files in one go and figured googled my way to this “one liner”:
for sql in `ls wp_sql` do Next up is $sql time wp db import wp_sql/$sql --skip-optimization done
How to use this command – Setup:
This assumes that you have exported the files correctly.
- Make sure that the directory holding your SQL files are in the root WordPress directory (next to
- Make sure you’ve changed directory to the WordPress root.
- Rename the directory to
wp_sqlor change the name in the script to the name of your directory.
- Add each command line by line.
I hope this helps some one.