- 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
-
🏆 Texturing Contest #33 is OPEN! Contestants must re-texture a SD unit model found in-game (Warcraft 3 Classic), recreating the unit into a peaceful NPC version. 🔗Click here to enter!
-
🏆 Hive's 6th HD Modeling Contest: Mechanical is now open! Design and model a mechanical creature, mechanized animal, a futuristic robotic being, or anything else your imagination can tinker with! 📅 Submissions close on June 30, 2024. Don't miss this opportunity to let your creativity shine! Enter now and show us your mechanical masterpiece! 🔗 Click here to enter!
Backing up and moving mysql data bases
- Status
- Joined
- Feb 26, 2008
- Messages
- 891
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
