Difference between revisions of "User:Huck/move to manticore"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | + | 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 06: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!