sebastiaandraaisma Posted December 20, 2006 Share Posted December 20, 2006 Hi, I have a small question.Is there a program maybe that allowes the on line database to be synchronized with the off line version?The reason I'm asking is that I would like to take my laptop to clients, fill the database off line as there is not always a wifi area in the naibourhood, than in the evening when I'm connected press a button and transfer the data of the day into the on line database.I have an Apache server, MySQL and PHP installed on my laptop. I have our website off line (not working as I most likely mised something in one of the configuration settings) but it would be great to work off line and just place everything into the on line database as soon as I'm connected to the internet.Any sugestion is welcome!!!Kind regards,Sebastiaan Quote Link to comment Share on other sites More sharing options...
Vikas Jayna Posted December 20, 2006 Share Posted December 20, 2006 you can try mysql replication i.e. setup your laptop as the master and the online database as the slave of this master. You would need to start replication on the online database (by using "start slave" statement) once you are connected to the network and stop replication (by using "stop slave" statement) when you are to disconnect the laptop from the network. Quote Link to comment Share on other sites More sharing options...
sebastiaandraaisma Posted December 20, 2006 Author Share Posted December 20, 2006 Thank you for such a quick reply!If I put the on line version as a slave, can it still process data that other users put in on our on line website? Quote Link to comment Share on other sites More sharing options...
Vikas Jayna Posted December 22, 2006 Share Posted December 22, 2006 Yes it can! Quote Link to comment Share on other sites More sharing options...
sebastiaandraaisma Posted December 23, 2006 Author Share Posted December 23, 2006 Thank you for your help! :)How do I activate the start slave on the server if the server space I rent does not give me access to the config files? Can this be done trough a .htaccess file or does it require something else?Thanks in advance!Sebas Quote Link to comment Share on other sites More sharing options...
Vikas Jayna Posted December 23, 2006 Share Posted December 23, 2006 Well! You need the access to mysql configuration files in order to configure the slave Quote Link to comment Share on other sites More sharing options...
sebastiaandraaisma Posted December 24, 2006 Author Share Posted December 24, 2006 Hello and thank you for answering!Hm.. than I need a different solution I think as I do not have access to the php.ini, my.ini or the httpd.conf.Is there another way, for example can I make a template page ore something (on line) that is like a form, than the off line version just puts the data in the form and I press "send" and the database gets updated with the data I had off line?Any sugestion or advise is welcome as I'm just a beginner :)Kind regards,Sebastiaan Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.