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!
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!
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.
Comments on How to BACKUP the WSN Guest's all data in mySql if you want to change web location
Member
Usergroup: Customer
Joined: Dec 01, 2003
Total Topics: 5
Total Comments: 11
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!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
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.
Member
Usergroup: Customer
Joined: Dec 01, 2003
Total Topics: 5
Total Comments: 11
Thanks, Paul,
I'll follow your instructions and tips, and try to work on the test within a week's time!
Cheers!
Member
Usergroup: Customer
Joined: Dec 01, 2003
Total Topics: 5
Total Comments: 11
Thanks, Paul,
I'll follow your instructions and tips, and try to work on the test within a week's time!
Cheers!