PhpMyAdmin

If you are after a mirrored setup of your site, I would recommend downloading xampp.
One click installer.
Drop your blog file into /htdocs
Import your .sql export into a db using phpmyadmin (which comes with xampp)
and you should be good to go.

thanks for that podz i’ll try my best ??

Everything is running ok atm and i have created a same user name and password to my online site. I need to know how can i download the online database to my pc and create additional databases for the new user ?

Thanks in advance

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
— https://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 ??

That sounds good but i dont have phpMyAdmin on the online webhost, only installed on the local machine. Would i need to install it on my webhost if so how ? THanks

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

When i first installed WP on my host i knew the mysql password &username details so i managed by luck maybe to create a database for my blog.

But if i wanted to backup or create multiple databases how can i acheive this with no phpMyadmin installed on my host ?

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.

Thanks 2fargon but how do i edit wp-config.php file to include more databases ?? .

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.

I want to create another 3 sites that have WP installed and access to the seperate databases, can i use the same database but like you said different tables within the database linked to the seperate web blogs ? If so how can i acheive this thanks.

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.

Thanks 2fargon i’ll let you know how i getting along ??

So i just change this ‘wp_’; to this ‘wp2_’; ? Then i get two tables within the same database ?

Yes, that’s what that little piece is for. It allows you to have two wordpress installs on one site/one database. If you were able to look at your database once you have the two wordpress’s installed, it would show you tables like such..wp_categories, wp_comments, wp_exhibit, etc and wp2_categories, wp2_comments, etc.