- make a backup of a mysql database with: mysqldump --opt DBNAME > DBNAME.mysql
- create a new database with: mysql> create database DBNAME;
(user 'ipp' has CREATE permissions)
- unpack a backed-up copy into your new database with:
mysql -u ipp -h alala -p DBNAME < DBNAME.mysql (will wipe out the exising DB)
Last modified
17 years ago
Last modified on Feb 24, 2009, 4:23:57 PM
Note:
See TracWiki
for help on using the wiki.
