Backing up your Drupal site is now very easy, you just need to download and install a module called Backup & Migrate. To install the module click on the Administer » Modules check the Backup and Migrate module and enable it and save the settings.

Then navigate to the Administer » Content Management » Backup and Migrate then do the following settings.

► Exclude the following tables altogether: select the table which you dont want to take backup.

► Give the backup file name.

► There are also options to compress the file before download, or add a datestamp.

► And then click Backup Database.

Alternately you can take backups using PhpMyAdmin.