How to import sql dumps into database using Yii2?

Question

MySQL

Hello,
after importing data from xls files to a local database, I need to transfer all the data to the server. Please explain how you can import a sql dump with these yii2 tools.
Thanks to all!

Answer 1

$this->execute(file_get_contents(__DIR__ . '/db.sql'));

Answer 2

Why do this with Yii? In my opinion, this is easier to do using MySQL.
For example, like this:

mysql -u USER -pPASSWORD DATABASE < /path/to/dump.sql

Or with the help of managers that work with MySQL (PHPmyadmin, etc.).

Answer 3

That's right, thanks, I'm familiar with these methods. But what if I want to wrap the import of the dump into a base migration, and later, when developing the project, create migrations and roll them on the server over this one?