PhpMyAdmin

I’ve recently just done this too 🙂

Easiest way:

1: Login to phpMyAdmin on your current webhost.
2: Select the wordpress database from the right hand menu
3: Click EXPORT

4: Make sure the following options are ticked
Structure (ticked)
– Add AUTO_INCREMENT value (ticked)
– Enclose table and field names with backquotes (ticked)

Data (ticked)
– Use hexadecimal for binary fields (ticked)

5. No compression
6. Click go! You’ll get output similar to the following:

— phpMyAdmin SQL Dump
— version 2.6.1
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Feb 28, 2005 at 10:29 PM
— Server version: 4.1.10
— PHP Version: 5.0.3
—
— Database: wordpresshome
—

— ——————————————————–

—
— Table structure for table wp_categories
—

CREATE TABLE wp_categories (
cat_ID bigint(20) NOT NULL auto_increment,
…
…
…
… etc

7. Copy everything from CREATE_TABLE to the end.
8. Using phpMyAdmin on your home server, create a new database. Select it, and click “SQL” and paste the text into the window.
9. Click go! This will import your database 🙂

gb2000, how exactly do you access your database at your host? What tool(s) do they provide?

You can use the same database, with different table prefixes (definable in the wp-config.php file) to have different blogs use the same database.

A man only needs one database, like a man only needs one email client 🙂

To backup your wp database, use the one-click backup and restore plugin, which you can search on google to find.

What is that you want to do?

For one wordpress blog, one database is good enough, there is no need to add any more databases.

If you want to create a new blog that uses the same database, change the table prefix in wp-config.php (to, say, ‘wp2’ instead of the default ‘wp’).

But it depends on why you are wanting to create more than one database. So please explain why and I will try my best to answer you.

Yes,
For your second wp powered blog, edit wp-config.php and use the same database, username, password etc as you did for your first wp blog. In addition, find the lines that say:

// Change the prefix if you want to have multiple blogs in a single database.
$table_prefix = 'wp_'; // example: 'wp_' or 'b2' or 'mylogin_'

and edit the line to

// Change the prefix if you want to have multiple blogs in a single database.
$table_prefix = 'wp2_'; // example: 'wp_' or 'b2' or 'mylogin_'

You can have any number of blogs on the same database, all you need to do is to edit the wp-config.php file to have a different $table_prefix value, for each blog.