If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / What should I upload to the 'live' site?

What should I upload to the 'live' site?

Locked

Started by earthdoctor on 4 Oct 2006, 1:46 PM · Views: 1,868

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
4 Oct 2006, 1:46 PM
#1
earthdoctor avatar

earthdoctor

New Zenner

Join Date:
Oct 2006
Location:
mid Wales
Posts:
5
Plugin Contributions:
0

What should I upload to the 'live' site?

This is my first time, so please be gentle!

I have a new site on my development box at home, which is currently identical to the live hosted site. When I have made changes via the admin menus on the development box, I'm not sure which files I should upload to the live site to carry these changes across.

I don't want to make the changes directly to the live site via the admin log-in, as I don't want customers to see work-in-progress.

I'd prefer not to upload the whole site each time, as the configure.php files are different on the live and development sites, to reflect the different paths on the two computers.

8 Oct 2006, 1:32 PM
#2
earthdoctor avatar

earthdoctor

New Zenner

Join Date:
Oct 2006
Location:
mid Wales
Posts:
5
Plugin Contributions:
0

Re: What should I upload to the 'live' site?

I think I can now mostly answer my own query, but if I'm wrong or anyone can add anything useful to it, please continue this thread!

I need to export the development database, upload it to the live server, then import it. I'm using PHP MyAdmin for the export / import. Export is straightforward, though I'm not clear about import - I assume it's done via the 'SQL' tab in PHP MyAdmin, browsing to the uploaded file and then clicking 'Go'.

Do I need to 'drop' the tables from the live database before doing this import or will they be overwritten by the more recent imported data?

8 Oct 2006, 3:31 PM
#3
wickedklown avatar

wickedklown

Zen Follower

Join Date:
Aug 2005
Posts:
370
Plugin Contributions:
0

Re: What should I upload to the 'live' site?

earthdoctor:

I think I can now mostly answer my own query, but if I'm wrong or anyone can add anything useful to it, please continue this thread!

I need to export the development database, upload it to the live server, then import it. I'm using PHP MyAdmin for the export / import. Export is straightforward, though I'm not clear about import - I assume it's done via the 'SQL' tab in PHP MyAdmin, browsing to the uploaded file and then clicking 'Go'.

Do I need to 'drop' the tables from the live database before doing this import or will they be overwritten by the more recent imported data?

yes, your going to need to drop those tables from your live database and put an export of your other database into it. otherwise it will just tell you that the data is already there, unless there are new customers/order and such.

you are correct on how to import the data. if your db sql file gets too big, you may want to command line it to the database. depending on weather you timeout or not while importing. (this is only for larger databases)

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order Tracking
Tabbed products lite - admin edition
Hosted with sashbox.net <- best host around...

8 Oct 2006, 3:35 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: What should I upload to the 'live' site?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

9 Oct 2006, 8:15 PM
#5
earthdoctor avatar

earthdoctor

New Zenner

Join Date:
Oct 2006
Location:
mid Wales
Posts:
5
Plugin Contributions:
0

Re: What should I upload to the 'live' site?

Thanks for the help - the Wiki link put it very clearly.