Want to Take a copy of my site and view it offline on my personal home Hadrive

[philpop]

Hi there,

 

I would like to Take a copy of my site and view it offline on my Harddrive. I am currently hosting it with a companies server.

 

However, I would like to have a copy of the site and be able to view it, and make changes in the admin side of things especially the orders to date on my personal home computer. These changes do not need to also take place on the actual website.

 

Is this posible?

 

If so, can anyone tell me how to do it as I need it rather urgently. Would I need "mysql" ?

 

thanks

Phil

[mtechama]

Hi there,

 

I would like to Take a copy of my site and view it offline on my Harddrive. I am currently hosting it with a companies server.

 

However, I would like to have a copy of the site and be able to view it, and make changes in the admin side of things especially the orders to date on my personal home computer. These changes do not need to also take place on the actual website.

 

Is this posible?

 

If so, can anyone tell me how to do it as I need it rather urgently. Would I need "mysql" ?

 

thanks

Phil

 

yes it is possible. first you neeed an mysql server on your hard drive, Second you may need a Apache Server, Lastly you need a PHP server.

[philpop]

yes it is possible. first you neeed an mysql server on your hard drive, Second you may need a Apache Server, Lastly you need a PHP server.

 

how do I get these servers?

 

will this effect my PC?

 

whats the best way to make it happen

 

thanks for you quick reply :)

[zwayne]

how do I get these servers?

 

will this effect my PC?

 

whats the best way to make it happen

 

thanks for you quick reply :)

 

Easiest way to do this is to first do a complete WAMP install (LAMP if your PC is Linux) that will install Apache, MySQL and Php in one go. A comparison of various packages is here:

 

http://en.wikipedia.org/wiki/Comparison_of_WAMPs

 

You'll have to do a little tweaking of initialization files, eg modifying php.ini to turn register_globals on if it's off.

 

You can then do an install of oscommerce or simply copy the files from the server to the appropriate location on your local PC, create your database, restore a backup of the database from the server, and then modify your configure.php files.

 

Not really that difficult. I have multiple oscommerce installs on my PC that I use for testing of all modifications. When things are working, I then ftp modified files to production.

[philpop]

Easiest way to do this is to first do a complete WAMP install (LAMP if your PC is Linux) that will install Apache, MySQL and Php in one go. A comparison of various packages is here:

 

http://en.wikipedia.org/wiki/Comparison_of_WAMPs

 

You'll have to do a little tweaking of initialization files, eg modifying php.ini to turn register_globals on if it's off.

 

You can then do an install of oscommerce or simply copy the files from the server to the appropriate location on your local PC, create your database, restore a backup of the database from the server, and then modify your configure.php files.

 

Not really that difficult. I have multiple oscommerce installs on my PC that I use for testing of all modifications. When things are working, I then ftp modified files to production.

thanks

 

I have downloaded Vertigo 209

 

any basic instructions to go from here? what tweaking do I have to do? I have downloaded a copy of the site onto my harddrive in a ZIP file. Where do I extract it?

 

thanks

[zwayne]

thanks

 

I have downloaded Vertigo 209

 

any basic instructions to go from here? what tweaking do I have to do? I have downloaded a copy of the site onto my harddrive in a ZIP file. Where do I extract it?

 

thanks

 

First, you'll have to make sure that all of your components are running. Type in localhost in your browser to see if apache is running. If you get a successful page, proceed; if not you'll have to figure out what the problem is. (E.g., make sure that the service is started.)

 

Figure out where your webroot is and put a file "phpinfo.php" in it that contains the following:

 

<?php phpinfo(); ?>

 

Then run localhost/phpinfo.php. That will tell you if Apache is configured to run php (probably is.) Search for register_globals and make sure that it is set to On. If not, modify php.ini accordingly and restart Apache (use ApacheMonitor.exe in the Apache2\bin directory.) Run the phpinfo file again to confirm.

 

phpinfo will also tell you if there is Mysql support, but won't tell you if it is running. Check your services to make sure.

 

Create your database (use a similar name as on your website for convenience, but you don't have to. Note that shared hosts will usually preference the db name with your user name; e.g., yourusername_yourdbname) . Do this with mysql -u root -p and enter the password if prompted. See the vertigo doc for default password for root. At the mysql prompt, type create database yourdbname Now since it is going to be a local test copy, you can possibly use the root name and password for your oscommerce db. If you want to use a different user name and password, just do a grant. Eg, grant all on yourdbname.* to 'yourusername'@'localhost' identified by 'yourpassword'

 

Now you need to restore the database from your backup. E.g.:

 

mysql -u root --password=rootpassword yourdbname < backup.sql

 

Copy your oscommerce directory structure underneath your webroot. Modify your two configure.php files (one for catalog, one for admin) so that it correctly references the file locations on your pc and the database connection info, and you're good to go!

[philpop]

Thanks, pretty much makes sense. With the help of a friend, I mangage to get ot working quite nicely.

 

However, I have just gotten a new pc, and am having troubles transfering the whole lot across.

 

 

when I go to the localhost in the browser it says

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in c:\program files\vertrigoserv\www\backup-8.2.2006_16-30-06_heli\homedir\public_html\includes\functions\database.php on line 19

Unable to connect to database server!

 

On line 19 it says

$$link = mysql_connect($server, $username, $password);

 

anyidea how to fix this? I still have the whole lot running on the other pc, let me know whats the easiest to do, I tried copying just the whole vertrigo file over to the new pc, and it comes up with errors saying I need to reinstal vertrigo. I have now reinstalled vertrigo, and copied the files across. however I get the above error when I attempt to go to the local host directory.

 

cheers

 

Phil

[Guest]

Most likely you have to change your configure.php files to the new DB. Try username "root" and leave the password blank. That is the standard setup for most local servers.

[philpop]

Most likely you have to change your configure.php files to the new DB. Try username "root" and leave the password blank. That is the standard setup for most local servers.

 

im not sure why i would need to change the password at all. shouldnt it be the same?

 

Can any one tell me how I can copy the whole lot from one pc to another? Im using vertrigo, which basicaly has mysql, phpmyadmin, apache etc, and the whole lot is stored in c/programs/Vertrigo. Can I just copy the whole file across to the new pc, or do i need to reinstall Vertrigo?

[philpop]

anyone? this should be an easy one for you peoples who know what your doing:)