I'm in the midst of setting up my new dedicated webserver, and boy am I glad about that. The last few days my site has been crawling due to traffic from other sites on my current server. (Eventually, someone will realize that you simply cant have a designer building your site and expect to handle any kind of traffic.)
Step 1 is moving the data. Installing MySQL is a breeze, and they have even nicely packaged all the GUI applications together, called "GUI Tools" making them that much easier to install. This package is considered a Release Candidate.
I had used the Migration Toolkit to transfer data from one server to another with some success, so I started off using it. That was not a smashing success. Firstly, it uses and old JDBC driver that will not communicate the passwords correctly, so I had to create a new user without a password. Ok, so I'm able to connect. But will it move the data? No. It transfered one table successfully, and then got stuck on the second. It didn't stop, just looked like it was in an endless loop and never reported an error.
I figured that there was probably some corrupt data or something in that table that the Migration Toolkit wasn't handling correctly, so I tried migrating one table at a time. This worked for most tables, but was very time consuming and defeated the purpose of the tool. It also didn't work for the one table I needed it for, the biggest table in the database, so I stopped the process.
I ended up transferring the data by simply backing up the old database, transferring it to the new server and restoring it. That process is slow, about 2 hours, but it worked for all the tables in the database.
From my experience, this product is far from ready for release.
Item of the Day: KWC Kitchen Waterstation