MySQL 5.5 to 5.7, how to handle backups

Ok, so, I need to move servers.... Old server MySQL 5.5, new has 5.7, when I restore backups, I get:

Unable to add user . Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50546, now ruing 50720. Please use mysql_upgrade to fix this error.Can't add user to : Unable to add user . Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50546, now ruing 50720. Please use mysql_upgrade to fix this error.

Error Adding Main Username to database: Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50546, now ruing 50720. Please use mysql_upgrade to fix this error.
Error with query "CREATE USER '<user>'@localhost" : Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50546, now ruing 50720. Please use mysql_upgrade to fix this error.

Is there anything I can do, other than installing MySQL 5.5?

There's no mysql_upgrade, even if it did, what use would it be? The data isn't importing.

برچسب: نویسنده: ایمان اصلاحی تاريخ: دوشنبه 18 دی 1396 ساعت: 15:25

درباره سایت

آخرین مطالب

امکانات وب

MySQL 5.5 to 5.7, how to handle backups

صفحه بندی

آرشیو مطالب

پيوندهای روزانه

لینک دوستان

خبرنامه