I want to upgrade my server to new components, I have a 4.23 mysql and I want to upgrade to 5 MySQL database with out losing everything,
So I guess the first step would be to dump the database into a SQL file uninstall older server install new server then upload SQL file back.
I have never done this and Iâ€™m worried of loosing everything. I have other peopleâ€™s WebPages on my server so I really donâ€™t want to f&ck it up
Can I use this command.
mysqldump --user=root --password=xxx --compatible=mysql40 devside > devside.sql
or can I from PHPmyadmin use the export tab, select all ( all Databases) highlight SQL then save has file.