{{tag>Brouillon MySQL}}

= Migration DB MySQL / MariaDB


== Serveur Source

<code bash>
mysqldump mydb -u myuser -pP@ssw0rd |pigz > /var/mydb.sql.gz
</code>

<code ->
mysql> SELECT user,host,password FROM mysql.user WHERE user='myuser';
+------------------+-----------+-------------------------------------------+
| user             | host      | password                                  |
+------------------+-----------+-------------------------------------------+
| myuser	   | localhost | *FFCB02F67B3F444B093A3A20CB5CB10481C0807C |
+------------------+-----------+-------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW GRANTS FOR 'myuser'@'localhost';
+--------------------------------------------------------------------------------------------------------------+
| Grants for myuser@localhost                                                                                  |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD '*FFCB02F67B3F444B093A3A20CB5CB10481C0807C'|
| GRANT ALL PRIVILEGES ON `mydb`.* TO 'myuser'@'localhost'                                                     |
+--------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
</code>

Voir également 
<code sql>
SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER;
</code>

== Serveur Destination

<code sql>
CREATE DATABASE mydb;
-- CREATE USER 'myuser'@'localhost' IDENTIFIED BY PASSWORD '*FFCB02F67B3F444B093A3A20CB5CB10481C0807C';
-- REVOKE ALL PRIVILEGES ON *.* FROM 'myuser'@'localhost';
GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD '*FFCB02F67B3F444B093A3A20CB5CB10481C0807C';
GRANT ALL PRIVILEGES ON `mydb`.* TO 'myuser'@'localhost';
-- FLUSH PRIVILEGES;
</code>

<code bash>
zcat /var/mydb.sql.gz |mysql -D mydb
</code>


== Autres

<code sql>
SELECT user,db FROM mysql.db
</code>

<code bash>
mysqldump mysql --tables user --where="user='myuser'" --skip-add-drop-table --skip-add-locks --no-create-info --replace --complete-insert
</code>