List:General Discussion« Previous MessageNext Message »
From:Nunzio Daveri Date:August 18 2010 2:24pm
Subject:Is this the right export / import command for all databases and users?
View as plain text  
Hi all, I have upgraded a few test boxes and everything seems to work fine BUT I 
wanted to verify with the gurus if my syntax is correct so as to avoid any 
future problems ;-)

The purpose is to dump all databases and users / user privileges from our 4.1.20 
server and import it into our 5.1.49 server.  On the 4.x server I ran:

# mysqldump -A -uroot -p | gzip -4 > ./4.x_mysqldump.sql.gz

Once done and I have MySQL 5.x running on the same box, I type:

# gzip -dc 4.x_mysqldump.sql.gz | mysql -uroot -p

Question: So with these 2 commands I export all the databases and user's and 
user's privileges and then import the databases and user's and user's privileges 
into 5.x?

Question: Will the above export and import change the 5.x mysql root password 
which is different than the 4.x root password?

Question: Will the above export the mysql database (inside mysql 4.x) from 4.x 
and re-import it into 5.X (the database that controls users and access and 
...)?  If so is this okay to do since it's a version upgrade?

Thanks in advance...

Nunzio



      
Thread
Is this the right export / import command for all databases and users?Nunzio Daveri18 Aug