I have made a wordpress blog at a domain, let's say www.xyz.com/forums.... Now I want to transfer the whole blog to another domain, say www.abc.com/forums. Please give me some guidance. Thanks.
How Do I Transfer an SQL Database from one domain to another
You only have to back up all your files and upload it on the new server. In the case of the mysql or sql datas, you will have to dump it, or execute a mysqldump or you will have to export it. Then, after backing up all the sql datas, you will have to extract or load it on the sql server.
If both hosts have phpmyadmin then this is a peice of cake. Here are the steps to get the backup file from your *CURRENT* host:
1. Go into phpmyadmin.
2. Locate the database you need to backup.
3. Once found, click on the Export button.
4. Skip everything on that page and just press 'Go.'
5. Copy the outputed text.
Next, to upload it to your new host:
1. Go into phpmyadmin.
2. Locate the database you want to apply the backup to.
3. Once found, click on the SQL button.
4. Paste the backup in there and press go.
Your backup is now on your new host! Easy as that, though I would suggest that you install your blog first, then apply the backup.
1. Go into phpmyadmin.
2. Locate the database you need to backup.
3. Once found, click on the Export button.
4. Skip everything on that page and just press 'Go.'
5. Copy the outputed text.
Next, to upload it to your new host:
1. Go into phpmyadmin.
2. Locate the database you want to apply the backup to.
3. Once found, click on the SQL button.
4. Paste the backup in there and press go.
Your backup is now on your new host! Easy as that, though I would suggest that you install your blog first, then apply the backup.
Thanks a lot guys. Will the same procedure work for phpbb forums as well if I wanted to transfer the forum as well?
I believe the "backup database" feature in PHPBB will do this easier than the steps I posted above. After you download it I believe you can just re-upload it?
If not, then yes the above steps will work.
If not, then yes the above steps will work.
In the case of reuploading the SQL data through phpmyadmin, please beware that there is a filesize limit
| kansloos wrote: |
| In the case of reuploading the SQL data through phpmyadmin, please beware that there is a filesize limit |
I do not believe that there is a file size limit on the SQL tab. (where you type in your own query to be executed) If you downloaded your backup, then yes there is a file limit.
 |