![]() Step 5 : restore your data mysql -u root -p < dump.sql If you have create table and timestamp(6) column is used than default values should be changed from CURRENT_TIMESTAMP to CURRENT_TIMESTAMP(6) `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), Step 4 : edit your data to address differences between versions (5.5 and 5.7) Sudo dpkg -i mysql-apt-config_0.6.0-1_all.deb Step 3 : install new version of mysql 5.6 sudo apt-get install mysql-client-5.6 mysql-client-core-5.6 ![]() Step 2 : remove old mysql sudo apt-get remove mysql-server Step 1 : take a backup mysqldump -lock-all-tables -u root -p -all-databases > dump.sql
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |