In this article, we will cover how to perform a mass import of multiple databases using SSH. By running a single command in your SSH terminal, you can import all your database backups at once, saving you time and effort. This method is efficient for managing large numbers of database imports in a streamlined process.
This article assumes a few things before you run the command:
You are running the command inside the directory where your backups reside
All of the SQL backup files are decompressed and filename ends in .sql
The databases have already been created on the server
The database name and SQL file name must be the same; otherwise, an error will occur.
Run this as one single command:
for dbfile in *.sql
do
db=${dbfile//.sql/}
echo "Importing database: $db from $dbfile"
mysql "$db" < "$dbfile"
echo "Done importing $db"
echo
done
Once the above command is run, it will output the following, indicating that all the databases have been imported successfully.
Congratulations! You've successfully mass imported databases using SSH.
If you have any questions, please don’t hesitate to contact our team via live chat.
For technical inquiries, please feel free to reach our support team by emailing support@bigscoots.com from your registered email or by submitting a support ticket.