Updating mysql version Wabcamchatten

Rated 4.72/5 based on 777 customer reviews

Though it is always a good idea to make a backup before doing a major upgrade.

First make a backup of the data in your existing database: How to migrate your existing My SQL database off of your application server to scale your environment.

Now I want to update My SQL to newer version 5.5.16.Make sure that you make the startup script executable, and update the rc.d database to notify the system about the presence of a new startup script.There you go, you have a My SQL 5.5 server up and running in no time!PDF (US Ltr) - 27.1Mb PDF (A4) - 27.1Mb PDF (RPM) - 26.1Mb HTML Download (TGZ) - 6.6Mb HTML Download (Zip) - 6.6Mb HTML Download (RPM) - 5.6Mb Man Pages (TGZ) - 168.6Kb Man Pages (Zip) - 277.1Kb Info (Gzip) - 2.2Mb Info (Zip) - 2.2Mb My SQL Backup and Recovery My SQL NDB Cluster 7.2 My SQL Globalization My SQL Information Schema My SQL Installation Guide My SQL and Linux/Unix My SQL and OS X My SQL Partitioning My SQL Performance Schema My SQL Replication My SQL Restrictions and Limitations Security in My SQL My SQL and Solaris Building My SQL from Source Starting and Stopping My SQL My SQL Tutorial My SQL and Windows As part of the "Logical Upgrade", I had to add the --flush-privileges option when dumping because mysql didn't recognise the newly created users when restoring views.Additionally I added --triggers for completeness.mysqldump --add-drop-table --routines --events --triggers --flush-privileges --all-databases --force -uroot -p mysql_Furthermore, if you're using Debian linux, then you'll have to copy the password of the old debian-sys-maint user in /etc/mysql/to the new server, or login to mysql as root and replace the old password with the new one.

Leave a Reply