# Restauration mysql

**URL:** <https://www.debian-fr.org/t/restauration-mysql/88968>\
**Category:** Support Debian\
**Tags:** serveur\
**Created:** [Octobre 12, 2023, 12:16 UTC](https://www.debian-fr.org/t/restauration-mysql/88968 "2023-10-12T12:16:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bobylapointe](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/b/3be4f8/32.png) [@bobylapointe](https://www.debian-fr.org/u/bobylapointe)\
**Post date:** [Octobre 12, 2023, 12:16 UTC](https://www.debian-fr.org/t/restauration-mysql/88968/1 "2023-10-12T12:16:53Z")

</div>

Bonjour,  
j’ai voulu faire une restauration de ma base et j’ai eu un joli message.

```nohighlight
MaBase -h localhost -P 3306 -u root -pxxxxxx< mysqldump_Mabase_2310120813.sql

ERROR 1118 (42000) at line 278879: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

```

je suis un peu perdu dans tout ce que j’ai pu lire… avez vous des conseils ?  
Merci a vous

---

<div class="post-metadata">

**Author:** ![bobylapointe](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/b/3be4f8/32.png) [@bobylapointe](https://www.debian-fr.org/u/bobylapointe)\
**Post date:** [Octobre 12, 2023, 12:56 UTC](https://www.debian-fr.org/t/restauration-mysql/88968/2 "2023-10-12T12:56:32Z")

</div>

j’ai mis cela dans le cnf du server

```nohighlight
innodb_log_file_size = 512M
innodb_strict_mode = 0

```

et ca marche oufff!!!