Answer the question
In order to leave comments, you need to log in
Why does mysql crash when editing tables via phpmyadmin?
Sometimes when editing tables in the mysql database through Phpmyadmin, an error occurs, and as a result, the database freezes. To resume its work, you need to reboot it. And here's another trick is that if you copy the generated sql query for editing and execute it through the console, then everything works. Are there any options why this is happening?
Versions : Database server
:
Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.1.44-MariaDB-0+deb9u1 - Debian 9.11
Protocol version: 10
User: [email protected]
Server encoding: UTF-8 Unicode (utf8)
- ---- Apache
Web Server
/2.4.25 (Debian)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b5
PHP extension: mysqli curl mbstring
PHP version: 7.0.33-0+deb9u7
-----
phpMyAdmin
Version info: 4.6.6deb4
Answer the question
In order to leave comments, you need to log in
1) Look in the MariaDB log - you might find something interesting.
2) how much memory is on the server? what does 'free -m' say?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question