First you will have to create a database at the new location. Then populate it with the contents of the database from the old site.

A couple of things to keep in mind :
1. Install and activate all themes and plugins at the new database, before importing. This will get rid of a lot of possible problems.

2. Most widgets dome come across in a database transfer. So be prepared to rebuild them.

3. After you have exported the site (save in in text format) and open it in Notepad.

Now do a search and replace form the old domain (eg : http://www.old-domain.com) and replace with new domain name (http://www.new-domain.com)

4. Also do a replace for the old file path system. The old one might look like :

/home/xyz123/public_html/

and replace with new path,

/home/abc124/public_html/

Save the file, and then import using phpMyAdmin on the new site.

If you just want to bring the posts across, then export the posts using the Tools->Export option. Save to your local PC, and then go the to the new site and go

Tools ->Import and import from your local PC.

Hope this helps, and be prepared for some heartache..

Bruce

[DELETED]

First of all, the error you receive is not defined. Basically, you'll need to create a new DB_name & DB_user with the same passwd as the old hosting in your new hosting control panel. Backup the wordpress database in the old web host and upload it to the new one.

Upload all your files/folders to the appropriate directory in your new host and login to wp-admin.

Make sure you upload all your files to the exact location in your new host as it was in the old.

Hope this helps!

hey,
you need to create a new database in new server. and then import it.

then change the new database and user name details at wp-config.php file in the wordpress site.



regards
anuradhan

maybe you could take the file and try it on local servers, to keep it more secure.