Sunday, March 11, 2007

mySQL DBA: Putting mySQL 5.0.33 into production

mySQL DBA: Putting mySQL 5.0.33 into production: "Otherwise it's a straight forward upgrade for me, so far.

I have a mysql 4.0 database that was about 200GB in size, most of that data was removed yet the ibdata file is still 200GB. So, what I did was

mysqldump --single-transaction -uroot -p --all-databases --master-data=1 > all_databases.sql"

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home