How to find and replace SQL for wordpress
As you should know (if you have been keeping up to date with my blog/website) we have moved servers, while doing this i had to do a few bits and bobs. I will be posting these to my website over the next few days, as i get time to write something up for you all. I thought this one was just a quick little nugget. The SQL will let you find and replace text in your wordpress posts when executed on the database. I used this to change the domain details for the images used on the sites. Here it is: UPDATE wp_posts SET post_content = REPLACE(post_content, 'andyfielder.com', 'andyfielder.co.uk'); You...
Read MoreWordPress Blogs Same Users
Another guide i thought i would commit to my blog for the future. These code snippets allow you to had any number of wp blogs and use the wordpress users all from the same blog. To start with install the 1st blog as per the instructions. Make the table prefix something you will recognise eg “wp_main_” as you will have to refer back to it. Once your fist blog has been installed, install your 2nd wordpress blog in a different directory. Make the table prefix something differnt ot the main/1st blog you made. But in the same database. Once the setup is complete, download the wp_config...
Read MoreSVN on 1and1 Hosting
Here is another of my guides for 1and1 users, i had issues finding a good guide when installing or adding SVN, subversion to my 1and1 shared hosting for the first time, to trial is use for updating wordpress on 1and1 automatically, but more of that another day. Sorry for no pictures, if you are a more visual person then i will try and get some screen shots etc to help you on your way with SVN and 1and1 Here is the executable code, it has taken me a few trials to get it all working as it should after studying the various guides on the net. NOTE: You need to substitute YOUR_SERVER and the...
Read More1and1 Meet Magento
A Guide to Installing Magento on 1and1 Shared Hosting. Hopefully you are aware that there limitations when using a sharedhosting provider, often implemented to allow the provider to keep the server secure. Luckily with 1and1 we are able to work around this and allow Magento access to PHP 5.2 (Please note this guide is just for using with 1and1′s shared hosting solutions). Enjoy! Getting Started Setup your MySQL database Navigate to your 1and1 Administration tab in your 1and1 control panel Using the 1and1 MySQL Administration page click New Database, start a fresh one just for...
Read MoreNew Bits Section
I’m going to be writing new posts in the bits section, which are there for reference, of things that i hope people will find interesting to read and a help. If you like to read things like this, rather than knowing absolutley everything about what im geting upto on the net, subscribe to the Bits category. Enjoy
Read More
Recent Comments