MySql phpMyAdmin Wordpress

How to Backup your WordPress Database using simple steps

Today i will show you how to take backup of your wordpress database and stay happy for future issues like db lost, hacking and more.
Please backup the existing database by logging into your PHPMYADMIN. It is very necessary to backup the database before you proceed with any changes. I also backup my website database once in a week. It is a good practice to always backup your database before making any major changes(like cleaning database for spam comments and meta data and more). If anything gone wrong then you can easily be able to restore the backupd database.

If you are not a tech guy and want to backup the database in very simple steps and withuot taking much headache then you can download WP-DB-Backup or WP-DBManager plugin to backup your database through your WordPress admin panel. Alternatively, you can backup your database through phpMyAdmin manually.

If you are still reading and decide to backup your WordPress database manually then you should follow these very simple steps:

  1. Login to your phpMyAdmin(Generally phpMyAdmin can be accessed using cpanel of your website like this
  2. Select your WordPress database(If you are more database installed on your web server).
  3. Click on Export at the top of the navigation.
  4. Select the tables you want to backup(i suggest you to backup all the tables), or select all tables to backup the whole database.
  5. Select SQL to export as .sql extension.
  6. Check the “Save as file” checkbox.
  7. Choose compression type, select gzipped to compress the database to a smaller size.
  8. Finally click Go, and a download window will prompt you to save your backup database file. Smile
Magento Open Sources

How to send notification mails to Magento Store admin after product is sold

As i have worked on so many projects in Magento. In one of my project in magento, my client wanted me to send him notification mail after the product is sold. So if you are looking for the same thing, then here is a easy and time saving trick to

Send mails to Magento Store Admin after the Product Sale.

Here are the few simple steps to do the above thing

Step1 : Log in into magento admin area,  System->Configuration menu.

Step2 : Scroll down to Sales section and click on the Sales Emails and select the first section Orders.

Step3 : Enter your admin e-mail in the field “Send Order Email Copy To”.

Step4 : This is it, now  every time a product is sold from your Magento Store then admin will receive mail with the details of that product and user.

PHP Programming Languages WebSites

How to upload files to online server using FTP softwares

When any dynamic website runs on server it uses database and some programming language files.

Suppose if you are using WordPress then the files are php files and if you have setup the development environment on your personal computer then after making changes in those PHP files you may want to upload those files to online server.

You may be interested in installing wordpress on local computer/home pc.

What you need to upload files and how you will do this

1. First you need a uploading software so that you can upload the files to online server.

Download the FTP softwares like FileZilla and CuteFtp.

Then you can easily connect to the online server by using connection settings.

2. You need to enter the Host name, port number (mostly 21), username and password.

3. You can see a folder named as public_html folder, this is the main root folder, you need to make changes in this folder only.

4. Now you need to go to the folder in which you have made changes on your local server and then you can easily upload files.

Have fun coding and enjoy the uploading tips.