Tips : Use MySQL to double the nodes in your Drupal database

Now as a shell script. You may have to update the MySQL user in the script. A file version of the script is attached. Download it, make it executable with chmod +x ./doublenodes, and then run it with ./doublenodes databasename

#!/bin/sh

Tips : Drupal Shared Database Multi-Site

Tips : Backing Up Your Drupal Database

Tutorial : Two Sites, One Database, One Installation of Drupal | DB Setup

The guidance provided below assumes:

Tutorial : Database Migration Part II

Tips : What is the Content Construction Kit? A View from the Database

The Content Construction Kit (CCK) began as a natural evolution from the popular Flexinode module. The Flexinode module allowed you to define your own content types (a blog entry, a recipe, a poll, etc) with a number of custom fields. CCK also allows you to do this, but in a more powerful way.

Fastest way to get just one result from a database table in Drupal

Merging two Drupal instances into a single database

I recently had to transfer some tables from a Drupal site that had been developed in it's own database, into an existing Drupal database. In order to do this, the MySQL dump needed to be edited to add table prefixes, lest the existing Drupal install be wiped out.

3 Easy ways to import large MySQL database

From time to time, we get into situation when we would like to know just how-to import big database in phpmyadmin?

A beginner's guide to caching data

Building complicated, dynamic content in Drupal is easy, but it can come at a price. A lot of the stuff that makes a Web 2.0 site so cool can spell 'performance nightmare' under heavy load, thrashing the database to perform complex queries and expensive calculations every time a user looks at a node or loads a particular page.