How to import .sql
file into multiple databases at one shot.
I have tried this:
mysql -uroot -p -all-databases < test.sql
But it asks for database name. Whatever there in test.sql
file should reflect in all the databases/Schemas.
MySQL
How to import .sql
file into multiple databases at one shot.
I have tried this:
mysql -uroot -p -all-databases < test.sql
But it asks for database name. Whatever there in test.sql
file should reflect in all the databases/Schemas.
Best Answer
If you're running on Linux/Unix, you can do it with a bit of shell:
Will obviously be easier if you temporarily set it up to be passwordless.