While bigdump.php is not included with Apache2Triad, it is a useful tool that greatly simplified working with large databases and Drupal. Used correctly, it can greatly speed importing large databases under Apache2Triad, and will also assist in importing large databases hosted on remote servers where restrictions are placed on the size of databases that may be imported. This is done by breaking up one big import operation into several small ones, reducing load on the computer and avoiding import file size limitations.

1) Download a copy of bigdump.php, unzip the file, and open the file "bigdump.php" by right clicking it with your mouse, selecting "Open with" from the context menu and then "Notepad" from the list of applications.
2) Find the following section of the file:

// Database configuration

$db_server = 'localhost';
$db_name = 'drupal';
$db_username = 'root';
$db_password = 'password';

The entries should be as shown above, substituting the correct values depending on where the database that is to be imported is located. Close this file and save a copy of it to your desktop or somewhere it will be easily remembered.
3) If you are using bigdump to import a database into your Apache2Triad installation, you should place a copy of the file you just edited in your htdocs folder along with a copy of the database you intend to support. If you are importing the database to a remotely hosted Drupal installation, you will need to transfer copies of the database and the bigdump.php file you edited to your server.
4) Open your web browser, select the text in the address bar, and type:
http://localhost/path-to-my-drupal-folder/bigdump.php
if you are importing to Apache2Triad and
http://www.example.com/path-to-my-drupal-folder/bigdump.php
5) Bigdump.php should run unattended after it has run, and will inform you of it's success when the database has been completely installed.
6) If you are importing to a remote database, you should delete the bigdump.php file for security purposes with your ftp program or other utility as suggested in the bigdump.php documentation, and you may wish to remove the old database at this time as well, to free up server space.

Comments

akaserer’s picture

a great and very easy tool to do backups and restores for big databases is

http://www.mysqldumper.de

its similar to phpmyadmin but it can handle very big databases ( i backup about 1 gb with that tool regularly). it runs on a php-webserver.