how to

WordpressYes, I ran into troubled water yet again. My webmaster decided to shift my server to a new one, and hence had to go through the process of backing up my blogs, and getting them up again from scratch. It is indeed a pain, at least it was for me. I made a whole list of blunders and I screwed up badly. The result, my blog went offline for a whole 3 days. How frustrating it is to find your blog’s main page set to a white background displaying “Error in establishing database connection”. So this is what you should actually do when you backup your WordPress, and get ready for setting your blog on a new server.

Things to remember:

Have your wp-content folder in wordpress backed up , including your uploads, images, plugins and themes. I forgot to do it, and my last minute panic was a definite qualifier for the YouTube humor Video Awards. If you DON’t do this, what you’ll end up seeing is your lovely blog set to the default WordPress Classic theme. Trust me, it HURTS.

(I am not mentioning the other details involved with shifting of the DNS or namespaces etc. My assumption is, that you have your URL ready and directed to the server where you are about to setup your already existing blog.)

So, here we go. First, as mentioned in my previous post, have your backup database ready. Ensure that it has been properly downloaded and that the file isn’t corrupt. Try opening the SQL file in a text editor like Notepad or Wordpad and you should be able to read the contents. The SQL contains your DB Name. Remember this is the DB name which you are gonna use. [Continue Reading]

{ 0 comments }

How to back up your WordPress DB?

by Sujoy on March 21, 2008

WordpressIt is quite essential to regularly back up your blog data. More so when you are hit with a bad weather in your servers. That is when you see the whole world crumbling down. Imagine me, when my servers crashed and I had no access to the c-panel and neither could I ftp to the servers as well. And yes, I was without a single back up of my more than 30 posts on Techkeyla, and another 50 I believe on OneKnightStands. That’s when you actually start re-reading your posts, in a state of hallucination that is. So to avoid such levels of trauma in the blogging world, back up is a must.

Now there are quite a bit of plugins in WordPress which offer similar features and facilities. I found this one to be quite simple to use, very fast and with all the necessary tools needed. It is called , shockingly WordPress backup, and the link is here. http://www.ilfilosofo.com/blog/wp-db-backup/

How to install: Download the zp file from going to the link here. Extract the zip file to a local folder and have the php file uploaded in your plugins folder of your wordpress folder. It should be inside :wp-content.
Now once it is uploaded, go to your WordPress admin console and go to the plugins tab. Hit Activate to activate the plugin and voila, job is done, but not yet. Next is to actually back up your DB. So, go to Manage–> Backup.
It should now show you a page with Backup options as to where you want to back up. The options are – On the server in a folder, download it to your local machine, or email it to a specified address.
Besides these, you can also set the Scheduled Backup. Most of us have daily posts, so an hourly backup doesn’t make much sense.A weekly backup also might face the risk of running behind a couple of posts. To be noted: You need to give write permissions for wp-content folder to enable Back Up files to be saved.
P.S. Do a manual back up once in a while, just to make sure that your data doesn’t vanish if your auto-backups fail.

Tip of the Day: If you have a Gmail ID, which I believe all of us do, set the filter for the given mails sent as backup attachments and you’ll have an arranged inbox of your backups. And the backup files are in a gun zipped SQL, and have convenient naming conventions and their date of backup can be easily identified . Happy Blogging!

Thanks to Brajeshwar for all the help in backing up my blogs.
Pics Courtesy:Jbiljr

{ 1 comment }

Firefox Tip: Browsing between Tabs

by Sujoy on January 26, 2008

I am an avid Firefox user. There’s absolutely no existence of the IE on my machine in terms of usage. And well, I also use Flock, which is again a Firefox based browser. And what hooked me to Firefox at the first place was the Tab Browsing facility. With time, we all got so used to it, that we ran out of control while pressing the Ctrl+T button, and the number of tabs ran to 15 and upwards. That’s when browsing between tabs raises an issue. You can of course surf through them by the old trick-using the Ctrl+Tab button. Or perhaps putting in Ctrl+<Number of Tab> to jump directly to the desired Tab. But that limits it to only 9 tabs. What if it’s more than that?Here’s the remedy. [Continue Reading]

{ 0 comments }

This one comes in really handy when you design or redesign your site layouts. Specially with so many free WordPress layouts available, it is absolutely mandatory for all bloggers to keep in mind about the end user browsing experience, in terms of the layout being stable (Techkeyla had a few problems-the sidebars had all scrolled down to the bottom, as IE doesn’t believe in resizing the images to fit the width. Had to resize them myself). But then, we cannot install all the possible browsers available and of course, not test them on multiple OS-s as well. Now, here’s the perfect solution to a complicated problem. Browsershots.org. This site enables you to test your site/blog on multiple browsers and their multiple versions available across three OS-s,viz. Linux, Windows and Mac OS. Among the listed browsers are Firefox, Opera, MS IE, Kazehakase, Epiphany, Firebird, Flock, Mozilla, SeaMonkey, Phoenix, Safari, BonEcho, GranParadiso, Galeon, Konqueror, Minefield,K-Meleon and Navigator.Here in the picture above, I tried testing Techkeyla across multiple browsers and it seems to be quite consistent in display. [Continue Reading]

{ 0 comments }