- 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!
-
It's time for the first HD Modeling Contest of 2024. Join the theme discussion for Hive's HD Modeling Contest #6! Click here to post your idea!
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
