FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


How Do I Transfer an SQL Database from one domain to another





jipmerite
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.
vinx_18
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.
Diablosblizz
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.
jipmerite
Thanks a lot guys. Will the same procedure work for phpbb forums as well if I wanted to transfer the forum as well?
Diablosblizz
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.
kansloos
In the case of reuploading the SQL data through phpmyadmin, please beware that there is a filesize limit
Diablosblizz
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.
Related topics
Can I create many SQL database by my self
phpBB - Installation Tutorial
myBBoard - Installation Tutorial
Trying to move SQL database
Joomla! - Installation Tutorial
Joomla issue
SQL Databases for another web site !
Any fast way to transfer/backup a domain to another server?
transfer of joomla website incl database
How to move SQL database to new domain?
manually input to sql database
Move database to different SQL server
English Dictionary in text file or sql database
PHP website with SQL Database.
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.