Best XAMPP sync with Host strategy?
Posted: 22. August 2011 03:04
Hi.
New to XAMPP and very enthusiastic about the potential.
I get the impression that it's ideal for a local site implementation for development and testing purposes which is exactly what I wanted to avoid inherent internet lag. Also additionaly security of a locally stored backup.
Questions -
Q1.1: What's the best strategy for having local XAMPP sites based on apps such as Joomla, Drupal, SugarCRM etc. and have an easy methodology to quickly sync them with remote shared Internet Hosts such as HostMonster? - is there a straightforward system to do this? Is it just the HTML folder and MySQL database that need to be synced or am I missing something?
Q1.2: How do you sync only changed HTML folders and directories so you don't waste a lot of time overwriting everything? - an FTP queue rewriting hundreds or thousands of files unecessarily could take hours or days.
Q1.3: Is it safe to upload or sync a XAMPP versin SQL database to a production shared host or am I importing security holes I'm not aware of?
Q2.1: I was delighted to see how easy it seemed to be to create a local XAMPP copy of a production hosted Joomla install. I downloaded the HTML folder (copy to htdocs) and the SQL db. I got the database username and password from the configuartion.php file and was able to import the data using PHPMyAdmin and voila an exact local high speed copy of my Joomla site - perfect, almost. Only problem is the administration section of the site does not accept my login name and password that work on the live site so I can't login and make any changes on the local XAMPP version of the site. What am I missing here? - if it's a copy of the same database why doesn't it have the username and password of the Joomla admin?
There must be heaps of clever people doing exactly what I'm talking about. I just haven't quite worked out the most elegant and efficient way to do it.
Please help.
Thanks
Sean
New to XAMPP and very enthusiastic about the potential.
I get the impression that it's ideal for a local site implementation for development and testing purposes which is exactly what I wanted to avoid inherent internet lag. Also additionaly security of a locally stored backup.
Questions -
Q1.1: What's the best strategy for having local XAMPP sites based on apps such as Joomla, Drupal, SugarCRM etc. and have an easy methodology to quickly sync them with remote shared Internet Hosts such as HostMonster? - is there a straightforward system to do this? Is it just the HTML folder and MySQL database that need to be synced or am I missing something?
Q1.2: How do you sync only changed HTML folders and directories so you don't waste a lot of time overwriting everything? - an FTP queue rewriting hundreds or thousands of files unecessarily could take hours or days.
Q1.3: Is it safe to upload or sync a XAMPP versin SQL database to a production shared host or am I importing security holes I'm not aware of?
Q2.1: I was delighted to see how easy it seemed to be to create a local XAMPP copy of a production hosted Joomla install. I downloaded the HTML folder (copy to htdocs) and the SQL db. I got the database username and password from the configuartion.php file and was able to import the data using PHPMyAdmin and voila an exact local high speed copy of my Joomla site - perfect, almost. Only problem is the administration section of the site does not accept my login name and password that work on the live site so I can't login and make any changes on the local XAMPP version of the site. What am I missing here? - if it's a copy of the same database why doesn't it have the username and password of the Joomla admin?
There must be heaps of clever people doing exactly what I'm talking about. I just haven't quite worked out the most elegant and efficient way to do it.
Please help.
Thanks
Sean