Migrate ALL our MySQL databasesBRL-CAD
Status: ClosedTime to complete: 48 hrs Mentors: SeanTags: SQL, scripting, unix, bsd, ssh

This task involves performing a database migration for a couple dozen MySQL databases from one server to another.  You'll need to not only perform the migration, but write a script or keep a detailed log of all commands you run so that the databases can be migrated again should they need to be.

Coordinate with 'brlcad' on IRC for access.  This task may only be claimed by students that completed another GCI web tasks that established SSH access.

This is a follow-on to this previous GCI task:

http://www.google-melange.com/gci/task/view/google/gci2012/7991209

 

Uploaded Work
File name/URLFile sizeDate submitted
mysqltransfer.sh320 bytesDecember 25 2012 19:20 UTC
migrate.txt299 bytesDecember 25 2012 19:20 UTC
Comments
Jacob Bon December 22 2012 00:59 UTCTask Claimed

I would like to work on this task.

Sean on December 22 2012 04:35 UTCTask Assigned

This task has been assigned to Jacob B. You have 48 hours to complete this task, good luck!

Melange on December 24 2012 04:35 UTCInitial Deadline passed

Melange has detected that the initial deadline has passed and it has set the task status to ActionNeeded. The student has 24 hours to submit the work before the task is reopened and sent back to the pool for other students to claim.

Melange on December 25 2012 04:35 UTCTask Reopened

Melange has detected that the final deadline has passed and it has reopened the task.

Jacob Bon December 25 2012 14:14 UTCTask Claimed

I would like to work on this task.

Jacob Bon December 25 2012 14:15 UTCMigration

The databases are already migrated.  It took longer to run than I thought it would, and mysqld had to be started.

Sean on December 25 2012 18:34 UTCTask Assigned

This task has been assigned to Jacob B. You have 48 hours to complete this task, good luck!

Jacob Bon December 25 2012 19:21 UTCHow to run

Run mysqltransfer.sh with a text file with database names one per line as the first argument.  Edit the script to change the remote host or password.

Jacob Bon December 25 2012 19:21 UTCReady for review

The work on this task is ready to be reviewed.

Sean on December 26 2012 18:34 UTCTask Closed

Congratulations, this task has been completed successfully.

Sean on January 14 2013 15:06 UTCthank you

As GCI comes to a close, we wanted to take the time to say THANK YOU for all your efforts.  This comment interface closes after GCI is over, so you're encouraged to join our mailing list where we'll be announcing contributions from GCI participants like yourelf over the upcoming months: 


https://lists.sourceforge.net/lists/listinfo/brlcad-news


If you've provided your full name, we'll be sure to credit you in our authorship documentation and you'll see your name in a future announcement.  If you contact us at devs@brlcad.org or via IRC, we'll even let you know when your work is integrated and follow up with updates.  You're welcome and encouraged to contact us any time, especially if you have a question about how to continue participating in Open Source after GCI is over, but even if just to keep in touch.  Note that ongoing participation in Open Source is one of the most impressive skills to have on your resumé.  Take care, be well, and thank you again!


As you almost single-handedly have helped us migrate, there's going to be several announcements related to and announcing your work specifically.  We hope you stay involved!