$conn = new mysqli('host', 'user', 'pass', 'bd');
$conn->begin_transaction();
$result = $conn->query('SELECT * FROM table');
// и другие запросы
foreach ($row = $result->fetch_array()) {
// что-то делаем
}
$conn->commit();
mysqldump - u root -p --result-file=dump.sql databasename
create database databasename character set utf8;
show databases;
class RegisterFilter extends InputFilter
{
public function __construct()
{
$this->add([
'name' => 'login',
'filters' => [
['name' => 'myfilter'],
],
]);
}
}