Thursday, September 9, 2010

Archive for March, 2009

How to Moving a Large mySQL Database to Account using BigDump

Posted by dishan On March - 19 - 2009

This is question that most people have when they have large databases.  This tool will help you with.

So you have a larger mySQL database of more than 30 MB size, you want to move it to a new server, and you’re unable to import your database to the new server via phpMyAdmin, due to its time and size limitations.
But don’t worry, its not a big problem. It can be done using a tool BigDump

Here are the steps involved in moving your large database to a new server easily.

1. First you will have to download your old mySQL database to your local computer. This can be done via phpMyAdmin using the Export function.

2. Download the dumper from BigDump website, and unzip it to your local computer, using Winzip or any other unzip tool.

3. Create a new folder named e.g. “dump” on your new web server, and change its permissions to chmod 777. (Do change it back to default when you’re don’t with importing database.)

4. Open the unzipped file bigdump.php in a text editor like notepad, and adjust the database setting, i.e. database name, username, password.

5. Upload bigdump.php along with the dump file (downloaded from old server) to the new server under the directory we just created named “dump”

6. Now open the bigdump.php file by using a browser, i.e. Firefox, Internet Explorer, using address something like http://www.yourwebsite.com/dump/bigdump.php

7. Select the appropriate options and start the process, then wait for the process to finish, do not close your browser, if you do so, then you will have incomplete database on your new server. As the dump file is present on the server it will take less than a minute to complete the process, if the dump file is, consider 40 MB.

8. You must remove your dump (MySQL) file and the bigdump.php file from your server, also delete the dump folder, or change its permissions back to default which is 755 or 644.

Tech Tips

Spammers-retool

Posted by admin On March - 19 - 2009

The botnets responsible for so much spam appear to be in a brief rebuilding phase, but any respite is likely to be brief and new threats loom on the horizon, according to e-mail security firm MX Logic.

“Over the long haul, there is no reason to think that the decline is going to continue,” said Sam Masiello, MX Logic’s vice president of information security.

Read the rest of this entry »

Featured, Just Blog Stuff

Why SaaS Makes Sense in a Slow Economy

Posted by Staff On March - 13 - 2009

When the economy takes a downward turn, corporate IT budgets are usually one of the first casualties.  This is the case with the current recession, as evidenced by an October 2008 CIO Magazine survey in which 40 percent of 234 IT chiefs surveyed said they are cutting spending, essentially freezing new IT initiatives, if not scrapping them altogether.

However, technology is a critical element of business, and despite the current economic climate, the need for reliable IT remains the same-especially when it comes to fundamental business applications such as email or customer relationship management (CRM). As companies across all industries face tough decisions about where to put their limited dollars, here are three key reasons why the hosted or “software as a service” (SaaS) model makes a great deal of sense.

Read the rest of this entry »

Featured, Just Blog Stuff