Transfer Wordpress Help?

by humbledmarket Banned
5 replies
Hello,
I'm trying to transfer a wordpress site and I've transfered the site files however now I need to transfer the database if I'm not mistaken.

However when I try to import the database I get the following error:

Can I import the data base directly or should I create a new database and then import?

Thanks, sorry very inexperience with site transfers.
#transfer #wordpress
  • Profile picture of the author Bruce Hearder
    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
    {{ DiscussionBoard.errors[2499127].message }}
  • Profile picture of the author geek4ever
    Originally Posted by humbledmarket View Post

    Hello,
    I'm trying to transfer a wordpress site and I've transfered the site files however now I need to transfer the database if I'm not mistaken.

    However when I try to import the database I get the following error:

    Can I import the data base directly or should I create a new database and then import?

    Thanks, sorry very inexperience with site transfers.

    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!
    {{ DiscussionBoard.errors[2517984].message }}
    • Profile picture of the author adrianwinston
      Use phpmyadmin to download the DB, and reupload to the new location. Simple.
      {{ DiscussionBoard.errors[2518989].message }}
  • Profile picture of the author ar.anandan
    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
    {{ DiscussionBoard.errors[2531907].message }}
  • Profile picture of the author raksamuda
    maybe you could take the file and try it on local servers, to keep it more secure.
    {{ DiscussionBoard.errors[2538564].message }}

Trending Topics