mysqldump -u user -p --skip-lock-tables -A > alldb.sql
import back mysql < alldb.sql
MySql
How to check the MySql version
20/06/2017
by admin
by admin
Create a query with:
SHOW VARIABLES LIKE "%version%";
Result is similar to:
Variable_name Value ----------------------- ------------------------------ innodb_version 5.6.35 protocol_version 10 slave_type_conversions version 5.6.35-log version_comment MySQL Community Server (GPL) version_compile_machine x86_64 version_compile_os Win64