MySQL Forums
Forum List  »  Install & Repo

MySQL upgrade with mysqldump
Posted by: Pura Vida
Date: January 28, 2014 12:57PM

Hello All,

I plan to do mysql upgrade using mysqldump and run the the script
statements generated from it. The basic steps I am thinking of is
as follows:

(1) Back up the database with mysqldump --all-databases
(2) Install the new version of mysql
(3) Run the SQL scripts from (1)

The issue that I imagine as this:

In the user table, there are already root accounts. If you run the scripts
in step (3), there will be a conflict. Besides the root accounts, what else
would cause conflicts, such as test schema. How would one resolve these
problems?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
MySQL upgrade with mysqldump
January 28, 2014 12:57PM
February 05, 2014 09:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.