take live site database backup to work on local machine
Development and Programming
This question may be related to a resolved thread.
Hi guys,
I also need to be reassured as to how I can develop a site further after it’s online…
Currently I’m working on a MAMP local site (EE 2.5.3) and am considering putting an early version online before some additional features are in place. As it’s an ecommerce site, once online there will be changes occurring on the live database as orders come in.
I don’t want to go down the route of comparing schema/data with NaviCat at this point. I’m thinking about this route:
- take ordering offline (no live database changes to take place)
- export whole live database
- import database to local
- develop, with database updates
- export database and import to live site
- reinstate ordering (EE files also to be backed up / restored separately)
Any problems anyone can foresee with this?
I’m considering using Backup Pro for the exports/imports, should this do the job of swapping out databases between servers?
I realise that development while the site is offline would take hours, but the length of temporary downtime isn’t an issue at present. I know this is a simple approach, but my aim is to keep the database intact but avoid having to work on the live site.
Thanks for any help you can give!
Can anyone point me to any resources on swapping databases between development/live servers? Thanks.
Hi Kenny,
Ah… The Big Question™ 😉
I don’t want to go down the route of comparing schema/data with NaviCat at this point.
Well, NaviCat handles all the leg work for you, so that is the simplest way. But your plan - let me point you to something that might make your life a bit less hectic: Site Manager.
With Site Manager, you can compare 2 EE installs and move the changes between the 2. It’s free, but it is also alpha.
What you describe would be technically accurate though. In the end, you would have your changes in both places and your live site would be up-to-date.
I’m going to move this on over to Development and Programming, where it’s a bit better fit.
Thanks!
OK thanks Dan - I’ll check out Site Manager.
Success with transferring installations between local and remote which I’ve commented on in another thread. Just used PHPMyAdmin to swap out .sql database files.
I’m told that MySQL Replication is the best way to sync multiple databases, for those comfortable with this level of MySQL …