Difference between revisions of "User:Huck/move to manticore"

From WolfTech
Jump to navigation Jump to search
 
Line 1: Line 1:
This is a command line  
+
Step 1:
 +
 
 +
Transfer databases from Joe to Manticore using the following command line:
  
 
mysqldump --quote-names --skip-opt --add-locks --create-options --add-drop-table --disable-keys --extended-insert --quick --set-charset --host=joe.ece.ncsu.edu -u <username> -p<password> <dbname> | mysql --host=manticore.ece.ncsu.edu -u <username> -p<password> -C <dbname> -f
 
mysqldump --quote-names --skip-opt --add-locks --create-options --add-drop-table --disable-keys --extended-insert --quick --set-charset --host=joe.ece.ncsu.edu -u <username> -p<password> <dbname> | mysql --host=manticore.ece.ncsu.edu -u <username> -p<password> -C <dbname> -f
 +
 +
Step 2:
 +
 +
Create new user/password combos on Manticore.
 +
 +
Step 3:
 +
 +
Change code in all relevant scripts to correct database_pass/ includes files.
 +
 +
Step 4:
 +
 +
Test, test, test!

Revision as of 07:49, 14 July 2006

Step 1:

Transfer databases from Joe to Manticore using the following command line:

mysqldump --quote-names --skip-opt --add-locks --create-options --add-drop-table --disable-keys --extended-insert --quick --set-charset --host=joe.ece.ncsu.edu -u <username> -p<password> <dbname> | mysql --host=manticore.ece.ncsu.edu -u <username> -p<password> -C <dbname> -f

Step 2:

Create new user/password combos on Manticore.

Step 3:

Change code in all relevant scripts to correct database_pass/ includes files.

Step 4:

Test, test, test!