-
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.
-
The Hive's 22nd Icon Contest: Creep Abilities is now concluded, time to vote for your favourite set of icons! Click here to vote!
-
✅ The POLL for Hive's Texturing Contest #34 is OPEN! Vote for the TOP 3 SKINS! 🔗Click here to cast your vote!
Backing up and moving mysql data bases
- Status
- Joined
- Feb 26, 2008
- Messages
- 893
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
