|
1) Make a backup of your database
2) Create database with new name
3) restore old database to new database like this:
mysqldump --username=YOURUSER --password=YOURPASS DB_NAME > /path/to/dump/file.sql
mysql --user=YOURNEWUSERNAME --password=YOURNEWPASSWORD NEW_DB_NAME < /path/to/dump/file.sql
4) change your database name, username and password in your local.xm file,
|
