MySQL 5.5 Data Migration under Windows 5.7 Notes

I don't want to upgrade the version of the notebook MySQL database that I usually use. Because the green version of mysql5.5 in Phpstudy is always used, and some websites that I usually test are tested on the local machine, so the database is still a bit database. But this time when I use the framework with IDEA, the framework must be MySQL 5.7+. My mind explodes. I always use 5.5, If the SQL file is not upgraded, an error is reported when importing it. If you want to install it into the virtual machine, it is troublesome every time you start it! Then we plan to install it directly, so we start the following work.

-Read the full text-

MySQL automatically backs up scripts and automatically deletes the backup content 2 weeks ago

1. Environment test environment: centos6.9 mysql version: mysql5.6 mysql installation directory:/usr/local/mysql/backup directory:/mysqlbak script location:/mysqlbak/mysqlbak.sh2. The script code script content is as follows. There are comments, please modify according to the content: # 2018.4.15 Liu Jiji # Define user name and password user="root" pass="root"

-Read the full text-

Latest articles

classification

file

link

other