Changes between Initial Version and Version 1 of Ippdb_copy_database

Timestamp:

Feb 24, 2009, 4:23:57 PM (17 years ago)

Author:

trac

Comment:

--

Ippdb_copy_database

@@ +1 @@
+* make a backup of a mysql database called DBNAME with:
+ mysqldump -uUSERID -hDBHOST -pPASSWD --opt DBNAME > DBNAME.mysql
+
+ * create a new database with:
+ mysql> create database NEWDB;
+
+(user USERID must have CREATE permissions) 
+
+ * unpack the backed-up copy of DBNAME into your new database NEWDB with:
+
+ mysql -uUSERID -hDBHOST -pPASSWD NEWDB < DBNAME.mysql
+(will wipe out the exising DB)