Portal Home > Knowledgebase > Articles Database > Do i need sql update?
Do i need sql update?
| Posted by ruba, 09-14-2013, 05:11 AM |
| I have using a vps server and i see there is installed SQL version 5.1
I will getting any improvement if i update to 5.5 ??
or its secretive if i update the latest versions? Or there is any problem if i will update?
http://my.jetscreenshot.com/demo/201...5wnv-117kb.jpg
|
| Posted by alex0, 09-14-2013, 05:29 AM |
| As such I don't see any harm. If you update then you will get more bug fixes and other better features also to use. The only thing you need to be careful is to ensure that you have taken an appropriate back up before you update because if at all anything goes wrong(chances are less) and damages your data, you can have a backup to restore and continue your work without any loss.
|
| Posted by ruba, 09-14-2013, 05:41 AM |
| Well now tell me the update process, i see there is 7 steps to finished update
|
| Posted by Mayur-strad, 09-14-2013, 05:59 AM |
| if you will update you will get improved features & bug fixes with new versions.
|
| Posted by ruba, 09-14-2013, 08:33 AM |
| Thanks for reply, 5.5 is suitable for vBulletin forum?
if yes, please tell me procedure.
|
| Posted by pdean, 09-14-2013, 05:18 PM |
| Hello,
Upgrading to 5.5 shouldn't hurt a thing, it should only help. I recommend taking a dump of your databases before running the auto upgrade. The command to do this is below , assuming you are comfortable with the shell.
---------------------------------------------------------------
mysqldump --all-databases > /root/all_db_backup.sql
---------------------------------------------------------------
|
| Posted by mikefrancis, 09-14-2013, 09:06 PM |
| Upgrading to a newer version is always best to keep up with. Make sure you have backups available before doing anything first just in case they are needed.
|
| Posted by maruti_strad, 09-19-2013, 06:37 AM |
| as such i dont think so you dont get problem but in case problem occure you might update your database in config file.
|
| Posted by tjohnson3757, 09-19-2013, 09:21 AM |
| No problem with updating Mysql. No issues here so far.
|
| Posted by net, 09-19-2013, 09:22 AM |
| Moved > Hosting Security and Technology .
|
| Posted by peet, 09-19-2013, 10:42 AM |
| I could see the VB is compatible with mysql 5.5 versions.
Only thing we needs to make sure that a error free upgrade. You can refer http://dev.mysql.com/doc/refman/5.5/...us-series.html to understand the basic changes.
Issues comes mainly when we skips a major version in our upgrade.
|
| Posted by Lost Eagle, 09-20-2013, 01:34 AM |
| Do the update via whm, and read the warnings well if any .....
|
| Posted by Kailash12, 09-20-2013, 02:03 AM |
| As far I know MySQL 5.5 is better than MySQL 5.1. vBulletin and other third party scripts should work with MySQL 5.5 without any trouble.
Before you upgrade MySQL version, make sure that you secure the full backup. Since you are using cPanel, upgrade MySQL from WHM -> MySQL upgrade. Make sure you read the steps completely during upgrade.
|
| Posted by WebHostDog, 09-20-2013, 12:02 PM |
| if you are really worried for upgrading MySQL just make a dump of all the databases and you can always roll-back to the previous MySQL version if something goes really wrong. You can take some time first to read the MySQL changelog between versions.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
