Webmastersite.net
Register Log In

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

Comments on 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 Comments: 11
Posted Dec 14, 2004 - 6:36 PM:

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
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Dec 17, 2004 - 2:58 PM:

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.
charles2smart
Member

Usergroup: Customer
Joined: Dec 01, 2003

Total Topics: 5
Total Comments: 11
Posted Dec 17, 2004 - 7:19 PM:

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 Comments: 11
Posted Dec 17, 2004 - 7:20 PM:

Thanks, Paul,

I'll follow your instructions and tips, and try to work on the test within a week's time!

Cheers!

Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.