How to Backup All MSSQL Databases on a VPS at Once

Last Updated on Wednesday, 27 February 2013 08:51 Written by Khaleel Demeri Friday, 1 March 2013 12:00

Have you ever wondered if you can back up all your databases at once? In this post I will discuss how to do this with one script. A separate file will be created for each database.

Let’s start!

1) Please make a directory where you want the backup files to be created. I will use C:\DB_Backup\ as my directory in this post.

Note: Step one is an important thing to do. We will use the path of that directory later in our script.

How to Add Hooks to Prestashop 1.5 (the new way)

Last Updated on Monday, 18 February 2013 08:44 Written by Fabio Porta Thursday, 21 February 2013 12:00

Prestashop 1.5 introduced a new way to add hooks, which doesn’t involve overrides or database queries. Unfortunately, it’s not yet been documented in the official Docs, so let’s see how to take advantage of it!

How to Optimize Your Database Tables in phpFox

Last Updated on Monday, 18 February 2013 03:37 Written by Stephanie Brown Thursday, 21 February 2013 12:00

This article will focus on optimizing your database tables within your phpFox AdminCP.

Periodically you will want to optimize your database tables, reducing the size of the database by cleaning out unnecessary “empty” space.  You can do this in a couple different ways, but we will focus on using the tools available in your phpFox AdminCP.

As always, before you make any major changes or do any maintenance to your site, it is advised that you backup your site files and/or database.

Login to your admincp and select Tools > SQL > Maintenance.

Easy Way to Check Space Usage in Your Microsoft SQL Database

Last Updated on Monday, 18 February 2013 04:28 Written by Naveed Ashraf Tuesday, 19 February 2013 12:00

nopCommerce Tips: How to Access Your Live nopCommerce Database

Last Updated on Friday, 8 February 2013 04:26 Written by Carole Bennett Saturday, 9 February 2013 12:00

nopCommerce has a very robust and extensive administration panel, but every now and again, you’ll find that data needs to be updated or corrected in a way that’s not supported by nopCommerce directly. It’s at those times that you may find it preferable to edit the database directly – today, we’ll talk about how to do just that.