How to BACKUP the WSN Guest's all data in mySql if you want to change web location: WSN Support

Version:

How to BACKUP the WSN Guest's all data in mySql if you want to change web location

charles2smart
Member

Usergroup: Customer
Joined: Dec 01, 2003
Total Topics: 5
Total Posts: 11

Posted 12/14/04 - 06:36 PM:	#1
Hi, Paul: I've already set up a WSN Guest which is up and running! However, I would like to learn better of how to BACKUP the mySql database before I launch the site! I admit that I am still very new to PHP, though! Given that there is a website http://www.myfirstwebsite.com/wsnguest/ where my guestbook has been running couple of months and one day it has to be moved to a new site with different domain name, say http://www.mysecondwebsite.com/gbook/ Here are the questions: 1. Can all the database in http://www.myfirstwebsite.com/wsnguest/ be successfully transferred to http://www.mysecondwebsite.com/gbook/ without fail? even if they have got totally different domains or paths? 2. As I noticed that in setting up a wsn guest in database, you need to set up a DATABASE with an ID, as well as a USER-ID already set up to handle the database well. Do I need to set up absolutely identical database-IDs and username-IDs in between the two web locations/domains? so that the variables in database wont be messed up or whatsoever? - I mean, if I set up the database in www.myfirstwebsite.com with DB-id= guestbook, user-id= webmaster, do I have to set up absolutely the same IDs (i.e. DB-id= guestbook, user-id= webmaster) in www.mysecondwebsite.com ??? That's what I've been thinking of! I look forward to hearing from you, thanks very much for the kind help!

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 6014

Posted 12/17/04 - 02:58 PM:	#2
1. I believe there's a 'guestbook url' setting which you would have to set to the new value before backing up the database, in order to prevent it from redirecting you to your old site's admin panel on login. The easiest method for backup and restoration is to just use phpmyadmin. 2. If the database name and mysql access info is different on the new host, as it presumably is, then you need to edit the config.php file. In config.php replace the old database info with the new.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

charles2smart
Member

Usergroup: Customer
Joined: Dec 01, 2003
Total Topics: 5
Total Posts: 11

Posted 12/17/04 - 07:19 PM:	#3
Thanks, Paul, I'll follow your instructions and tips, and try to work on the test within a week's time! Cheers!

charles2smart
Member

Usergroup: Customer
Joined: Dec 01, 2003
Total Topics: 5
Total Posts: 11

Posted 12/17/04 - 07:20 PM:	#4
Thanks, Paul, I'll follow your instructions and tips, and try to work on the test within a week's time! Cheers!

You don't have permission to post.