Cómo cambiar Wordpress de subdirectorio

Have you ever had the need to install wordpress in a subdirectory/subfolder or even replicate a previous instalation of wordpress and simply couldn’t get it to work?

1) Let’s assume your site is magro.ic21.eu and you need to install it to magro.ic21.eu/foobar
2) Create the subdirectory (I’ named it foobar)
3) Move all files from the previous wordpress directory to foobar
4) You’ll notice that magro.ic21.eu/foobar will not have any posts displayed and wp-admin will not work.
5) Go to mysql prompt and issue the following command:
update wp_options set option_value='http://magro.ic21.eu/foobar' where option_name = 'home' or option_name = 'siteurl';

NOTE: You need to change magro.ic21.eu/foobar with your site/subdirectory name!!!