# Commandes General
Poids base de doonnées
```mysql
SELECT sum( data_length + index_length) / 1024 / 1024 "Nom-de-la-base Taille en Mo" FROM information_schema.TABLES WHERE table_schema = "nom-de-base" GROUP BY table_schema;
```
Read permission
```mysql
GRANTSELECTON DBNAME.TABLE_NAME TO USERNAME
```
liste toutes les BDD
```mysql
show databases;
```
se met sur la BDD qui nous intéresse
```mysql
Use nomdelabdd;
```
Suppression de la BDD
```mysql
Drop database nomdelabdd;
```
Création de la BDD
```mysql
Create database nomdelabdd;
```
Dans le cas où le compte mysqldump n'a pas les droits de restauration de dump
```mysql
grant all privileges on *.* to mysqldump@localhost;
```
Restauration du dump dans la BDD
```mysql
mysql -u mysqldump -p "nomdelabdd" < "/production/mysql_dump/nomdelabdd.sql"
```
Vérification de la bonne restauration du dump
```bash
ls -alsh /production/mysql/nomdelabdd/
```
Pour se connecter
```bash
mysql
```
Pour avoir la taille de toutes les BDD:
```mysql
SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;
```
Pour avoir la taille de toutes les tables d'une BDD:
```mysql
SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "database_name" ORDER BY (data_length + index_length) DESC;
```
Reset Mot de passe Mysql:
```mysql
ALTER USER 'mysqldump'@'localhost' IDENTIFIED BY 'dump';
```