moving an entire mysql database…
There comes a time when it is necessary to move servers... and it's related services and databases... it was time for me to move onto bigger and better ... server that is. Over the years, we have tried out and customized few things within the web server which ended up getting big ... in the process mysql database also gotten bit big... so to migrate from one to the other... I had to use the dumpmysql but standard usage of mysql dump resulted in whole bunch of errors including errorno: 24 which was result of large database.
But this can be avoided by using the flag –lock-tables=false into the command line.
$mysqldump --opt -u [user.ID] -p -A --lock-tables=false > [dump.filename]
After that, it was easy as just moving file from one server to another using any secure method you like and using following command to restore it on to the new server...
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
Note: if no database exist in your new server [database_name] can be omitted.
And that's it, your new database is all new and shiny...
Reference: http://jamielesouef.com/linux/tip-backing-up-a-large-mysql-database-errno-24/
phpMyAdmin 1045 Access Denied error!
Having internet is like a double edged sword. On one hand, you have endless amount of information at your finger tip (literally), but asking the right question is the key of find that information your need in any given moment. Also, there's that problem of information overflow which is another issue all together, but I digress.
As a web admin / net admin / just a handy IT guy around the office, I do use phpMyAdmin quite often because its interface is much easier to navigate than terminal. Also, I'm a visual person and like to see large amount of data in nice tables. Today however, I was faced with an issue. I was not able to access it. Following was the error message that I've got.
1045 - Access denied for user 'root'@'localhost' (using password: NO)
To make sure I've tried to access it from the terminal using
mysql -u root
but the problem persisted. So on to the Google I went and searched online for the error message and apparently, this was a common instance that came up from time to time. After going through few of the top links, I've found following solution http://tekxplorer.blogspot.com/2010/05/phpmyadmin-mysql-error-1045-access.html which was easier than what other's have suggested and you know what? It works! thanks you internet and that guy who posted his experience 
If you don't feel like following the link to the solution page, basically this is what you need to do...
- Add '/scripts/signon.php" at the end of your site URL, so that it will look like http://yourdomain.com/phpmyadmin/scripts/signon.php"
- From the sign on page, login using your root user id and password for mySQL
- Ta-da, you are back in!
After doing this once, problem with the access denied error seems to magically disappear. Well, one less worry for me and I'll know what to do next time 
WordPress, new host, and plug-ins oh my!
It's been four months since my last post. Few things had to change. A new hosting company, upgrade to WordPress and new plugins. My previous hosting company 'godaddy.com' seemed to be owned by red neck CEO (Bob Parsons) who takes African safari hunting trips to kill elephants and tries to disguise as a humanitarian mission to feed the local tribe elephant meat? Well that's not entirely the reason for my move but it did put an icing on the cake. On ward to 1 and 1. Though I don't like giant companies, 1 and 1 proved to be faster with better customer support.
The move was done as well as the domain migration which took out the majority of my time. (The whole 90 day wait time for domain exchange to happen on top of the security lock that was put on my domains was an interesting experience to go through to say the least)
Along the way I have upgraded my WordPress to the latest 3.1.1 which was actually 3.0 when all of this started. Since then, WordPress has been turning more and more into a full CMS solution, thought it was already a quite capable CMS to begin with. Also I have tested and tried out few interesting plugins... So I thought I mention what's under the hood...
Akismet: Protection from spam in comments and trackback. I'm not sure why this isn't installed on all of the packages of WordPress install.
All in One SEO Pack: SEO plugin solution for WordPress. Just installed it, so not too sure how effective this will be.
DBC Backup: Backup solution using cron. Set it once and forget it.... until your site gets hacked and have to revive it form the dead.
Fast Secure Contact Form: Contact form, secure. Just in case you need to find out what your visitor wants to say to you, but don't want to let them know of your true email address
Select Google XML Sitemaps: Another SEO improvement plugin to have your site get better indexing.
Hello Dolly: I forgot to delete this...
W3 Total Cache: Helps to improve the performance of your site by caching pages, objects, and more...
WassUp: Not budwiser commercial, it is a traffic analyzer, might come in handy when you are trying to find out who's looking at your site.
Wickett Twitter Widget: Don't tweet much, but I thought it was interesting... having hard enough time trying to write something on this blog...
WordPress Importer: In case I wanted to import things from my other blog(s)...
WPtouch: Turns my blog / site into mobile version! Wow wee...
For now that's all I can handle in an hour... maybe when I get more time later, I'll test out some of the other security plugins...