How to set up a test site???

[julianpuje]

Hi all

 

I need to set up a test site, to make changes to the current site, view the changes as a live site, then upload them to the real live site. I now edit a bit of code at a time and have to upload it to the live site to see if it worked. This is no good.

I have Dreamweaver and have set up a subdomain on the server, anyone got any idea on how to get my catalogue in the sub domain and how to configure Dreamweaver to read it? If thats what i have to do.

I am a Newbie, but have been trying this for over a week now and its driving me up the wall.

Also set up a MySQL database on the server.

Any help please :(

 

TIA Julian

[Guest]

Create a new test database and import the live one into it

copy over all the files from the live site to your testing folder, then edit the paths in the configure.php file accordingly in both catalog and admin

 

that should do it

 

You could also download phptriad and install it locally on your desktop and test your site there as well

[julianpuje]

Thanks for the reply.

I've created the database already on the server, to try and set up my test site there, but can't find how to copy the files over.

After the last week, I now have everything possible on my desktop, to test it locally, but can't configure it all. Tried it too many times to mention!

I've got IIS (for XP), phptriad, Apache, mysql, pretty much everything.

Any help with configuring this would be great.

[julianpuje]

I think i might be getting somewhere now.

I have a testsite sub-domain now showing in my catalog. I have copied my site to this new folder and edited the config files.

What exactly do i change in the config files? is it just the database to use, or all the address references?

 

TIA

[Guest]

Yes, you have to change all the paths AND the database info

 

Glad you're making progress :)

[julianpuje]

OK, i've done that, but have an error message now when i try to go the test site on-line.

1146 - Table 'julianp_testsite.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

No idea what this means.

 

My set up now, is:-

 

I have all my site files in a sub domain folder called "testsite" placed within the catalog (public_html) of my root.

I have a new Mysql database named "testsite" also ??

In the testsite folder, i have edited the config in includes & admin to show all this. So instead of it reading public_html, it now reads public_html/testsite.

etc etc on all the address references.

 

I feel like i'm getting closer, but still not working yet.

[241]

Table configuration is being looked for on database julianp_testsite and it cannot be found.

 

You say that you created a database called testsite not julianp_testsite

 

check that the database information for the configure.php files matches the name of the database.

[julianpuje]

Yes, i've created the database julianp_testsite and i've put the same in my config files.

The only thing i have just found is that if i check the contents of the "live" database, theres quite a few files in there, as i would expect. But when i check the new one, theres nothing at all in it. Is this because it hasn't been used yet?

Still can't get it to all come together?

[241]

Did you run the sql file on the newly created database.

Did you take a backup copy of the live site database and run this sql file on the newly created database

 

 

The easy solution for setting up on a local machine is to use Easyphp

[julianpuje]

NO!

I am new to all of this. So what do i do with the sql.

I've found this relating to the new database. I take it this is what you mean.

If so, what do i do with it???

I am no programmer to say the least.

Any help

 

Cheers

 

 

$dbh=mysql_connect ("localhost", "julianp_GavinE", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("julianp_testsite");

[241]

No I am meaning the actual database nothing to do with the codes in the files.

You created a new database, which would be blank until you populate it.

You can use phpMyadmin for this, startup phpMyadmin and select the live site database from the drop menu on the left, then on the right select the EXPORT tab this will allow you to create a backup of your database. In the export page set as follows:

 

check this ----Structure

check this ----Add 'drop table'

no check ----Add IF NOT EXISTS

check this ----Add AUTO_INCREMENT value

no check -----Enclose table and field names with backquotes

no check -----Add into comments Creation/Update/Check dates

 

check this --- Data

check this ---- Complete inserts

no check ----- Extended inserts

 

Click Go

 

on the resulting page on the right hand side, right click select all and copy.

 

Now on left hand side select the newly created testsite database and on the right hand side select the SQL tab, you will be presented with a sql query window, right click in this sql query window and select paste, now scro;; to the top of the sql query window left click in front of the first character of the first line in the sql query window, which will be something like:

 

Database julianp_testsite running on localhost

change this to

-- Database julianp_testsite running on localhost

or

## Database julianp_testsite running on localhost

depending on your database settings.

 

 

Then click the Go button that should populate your database unless there are errors in the sql

[julianpuje]

Your a star. :D Thank you very much for all your help.

It's finally working. The only problem with it now, is i've got a lot of work to do, and get testing it.

 

Cheers again

 

Julian

 

 

Another good result from the OsComm Forum.

I don't know what i'd have done without it.