- Joined
- Aug 25, 2005
- Messages
- 1,133
Hi, I was wondering how I would go about backing up and moving a 5.0 mysql data base to a 5.5, anything would be helpful due to my low knowledge on this.
Thanks,
Madcat
Thanks,
Madcat
-
Listen to a special audio message from Bill Roper to the Hive Workshop community (Bill is a former Vice President of Blizzard Entertainment, Producer, Designer, Musician, Voice Actor) 🔗Click here to hear his message!
-
Read Evilhog's interview with Gregory Alper, the original composer of the music for WarCraft: Orcs & Humans 🔗Click here to read the full interview.
Backing up and moving mysql data bases
- Status
- Joined
- Feb 26, 2008
- Messages
- 892
The procedure on this should be fairly straightforward.
- Put your database into offline mode (so nothing is being written to it while doing the move)
- Dump the database to a file
- Move the file to the new MySQL install
- Import the database
Looks something like this:
mysqldump -u root -p databasename > somecoolfilename.sql
It will prompt for your root MySQL password.
Then move the .sql file to the new MySQL server.
Once there:
mysql -u root -p databasename < somecoolfilename.sql
- Put your database into offline mode (so nothing is being written to it while doing the move)
- Dump the database to a file
- Move the file to the new MySQL install
- Import the database
Looks something like this:
mysqldump -u root -p databasename > somecoolfilename.sql
It will prompt for your root MySQL password.
Then move the .sql file to the new MySQL server.
Once there:
mysql -u root -p databasename < somecoolfilename.sql
- Status
