I was restoring the backup of a MySQL 5.x server into MySQL 8.x server – and found out that it corrupt the MySQL 8.x ‘s mysql table
Which stores the usernames and passwords.
So I had to delete the mysql table from the backup, before trying to restore it again
Turn out it’s pretty easy, just will take some time since it’s a pretty big backup :
# search for beginning of 'mysql' table
cat backup.mysql | grep -n Current Database: `mysql`
# 155604:-- Current Database: `mysql`
# search for ending of 'mysql' table
tail -n +155604 backup.mysql | grep -n "Current Database"
# 1: -- Current Database: `mysql`
# 916:-- Current Database: `phpmyadmin`
# cut that table out
head -155603 backup.mysql > new.mysql
tail -n +$(( 155603+916 )) backup.mysql >> new.mysql
# voila !
Great article. It is very useful and informative. Thanks a lot for sharing this post. – best tile store in chennai
Awesome Blog! It’s a great spot to find new information. Thank you so much for this wonderful article. – shirdi flight packages from chennai
Awesome Blog! It’s a great spot to find new information. Thank you so much for this wonderful article. – tile showroom in chennai
Nice info. This is very impressive post, Very useful information, it clarified things a lot for us. Thanks for sharing valuable tips. – best tile store in chennai
Nice, thanks you very much
thanks for sahre information, it’s so nice for an articel
Terima kasih atas informasi yang diberikan.
Izin kami beri informasi seputar mesin usaha untuk jualan bensin eceran.
Mesin pom mini digital.
Pengiriman ke seluruh Indonesia.
Info : 082311159791
Harga Pom Mini
Good Job!
eVisaNation is an independent company that provides the simplest solution to apply for visa online.
Dreamnightcallgirls provides independent escort service in Chandigarh. Chandigarh Escort offers a variety of companion models for every type of adult meeting management.
Buy clean undetectable original money Euro Dollar Pound Whatsapp:+39 351 169 5046
Buy Super High Quality undetectable original money Online GBP, Dollars, Euros
All our bills and notes bypass everything, counterfeit pens and machines. More Info
WhatsApp:+39 351 169 5046 Website: https://echtedokumentes.de/product-category/pfund/
Sexy photo Katy Perry.
https://celebviva.com/sexy-katy-perry-in-the-magazines-glamour-gq-maxim/
Katy Perry topless! Hot Nude pics.
EllaThorne luxurious model with a stunning figure.
https://nano-chat.com/ellathorne-luxurious-model-with-a-stunning-figure/
Don’t miss out on the chance to experience the beauty of communicating with this sexy model.