Stephen Groom Taking a shot at becoming a Poker Pro

How to remove AVG safesearch from firefox address bar

Recently, I installed AVGFree and overall I found it to be fine.  There was one thing however, that has bugged me ever since.

If I typed a keyword, or website title into the firefox address bar, google and it's wonderful "I'm feeling lucky" feature whisked me off to the #1 result in google for the keyword I had typed.  This was particularly handy if I knew a page or website title but not the full URL.  Since installin AVGFree however, this functionality disappeared and it started directing me quite annoyingly to Yahoo sponsored by AVG.

To fix this do the following:

• Go to "about:config" in the firefox address bar
• Click the "I'll be careful, I promise" button on the page that loads in order to view the bowels of firefox.
• Type "keyword.url" in the search box at the top of the page
• Simply right click the item displayed below and click reset.  If for whatever reason you are unable to reset, enter the following value manually.
  "http://www.google.com/search?ie=UTF-8&oe=UTF-8&sourceid=navclient&gfns=1&q="
• Enjoy firefox being back to it's normal function

I hope this was useful
Stephen

How to transfer a MySQL Database to a remote server

This tutorial will show you how to transfer your mysql databases to a remote server.  The databases will be directly transferred over TCP which removes the time spent downloading .sql files from your old server and re-uploading them to your new server.  This is the fastest way to transfer a MySQL database. This guide is written using linux commands but how to do the same thing on windows should be obvious.  If it isn't, leave a comment below and I'll explain step by step.

Preperation

The new server (the destination for the database) must be accepting connections on port 3306 to MySQL.  This is acheived using the following steps:

• Edit it's my.cnf file and ensure that the line "skip-networking" is removed
• Ensure the server is accepting connections on port 3306:  "[]$ iptables -I INPUT -p tcp --dport 3306 -j ACCEPT"
• Add a user to mysql who is authorised to connect from a remote IP.
  <mysql>: CREATE USER 'transfer'@'[OLD SERVER IP]' IDENTIFIED BY '[PASSWORD]';
  <mysql>: GRANT ALL PRIVILAGES  ON *.* TO 'transfer'@'[OLD SERVER IP]' WITH GRANT OPTION;
  Don't forget to replace [OLD SERVER IP] and [PASSWORD] with your own values

Process

Now we will dump the data from our old server at [OLD SERVER IP] to the new server.  From a shell on our new server run the following command:
[]$ mysqldump -u[USER] -p[PASS] --all-databases | mysql -utransfer -p[PASSWORD] -h[NEW SERVER IP]

This command will then transfer all databases from [OLD SERVER IP] to [NEW SERVER IP].  Remember to delete the user 'transfer' from the mysql database for security reasons after this process is complete. For information on the mysqldump command see the mysqldump page and for any additional information please leave a comment below

Thanks
Stephen