Migrating the Mad Thought Blog to a new server (mysql, php)
By jeltsch on Wed, 04/04/2007 - 21:16- Dump the database data mysqldump --host=localhost --user=root -p journal >journal.sql
- Create the databse on the new machine mysql -u root -p CREATE DATABASE journal;
- Import the data into the database mysql -p -h localhost journal < journal.sql
- Create the user 'journal' GRANT ALL PRIVILEGES ON *.* TO 'journal'@'localhost' IDENTIFIED BY 'journal' WITH GRANT OPTION;