|Join Nairaland / Login / Trending / Recent / New|
Stats: 1,350,571 members, 2,017,215 topics. Date: Tuesday, 28 April 2015 at 07:52 AM
Pls How Do I Use Wamp Server To View Joomla Templates / Help I Need A Local Server To Test Some Joomla 2.5 Template On My Computer / Setting Up Wamp Server To Run On Local Area Network (1) (2) (3) (4)
|Connecting External Server To Local Database by cmon(m): 2:36pm On Apr 16, 2008|
I'm just a website developer (well you can say a new one ). When I get web projects, I usually do the hosting on external servers. Now a client wants to run a database on his system (Connected to the internet) and be able to synchronize the database on his local server (computer system) with the one on his website. How do I accomplish that?
Here's my point:
I'm of fan of the popular XAMPP software. Even if I install the XAMPP on his local system, how do I get to synchronize the database system (MySQL) with that of his website or how do I get the website to use the database on his local system using PHP, enabling real-time contents of the database to reflect on the website?
|Re: Connecting External Server To Local Database by syskay(m): 2:43pm On Apr 16, 2008|
This can be implemented by using the "Remote Mysql" feature.
|Re: Connecting External Server To Local Database by cmon(m): 2:57pm On Apr 16, 2008|
|Re: Connecting External Server To Local Database by syskay(m): 3:27pm On Apr 16, 2008|
Since you are going to be accessing the database of your website remotely, you will need to set the appropriate host access permissions in the "Remote Mysql" section. You can then go ahead to install and configure your database synchronization application.
|Re: Connecting External Server To Local Database by cmon(m): 3:43pm On Apr 16, 2008|
so where's the file? remember I'm using XAMPP. If you can, you can just direct my using a url to where I can get the resource I need.
|Re: Connecting External Server To Local Database by smartsoft(m): 3:54pm On Apr 16, 2008|
What i understand on what you want is that your local server is installed, and u want to link an external database you have created together with that you have on your website. because i do n't really understand that part !
|Re: Connecting External Server To Local Database by Kobojunkie: 11:11am On Apr 17, 2008|
If what you want to do is sync the two databases, then check this out http://www.databasejournal.com/features/mysql/article.php/1584401
If however, you want to sort of backup the contents of the local to the remote, then I suggest you, maybe use a trigger to have the remote server get updated each time a change is made to the local database. Problem is in my opinion, this is a really bad idea. So how about you connect your app directly to the remote database so that changes are made available in the DB as soon as your client makes the change to the same Database and then he can always back up the remote database to his local machine like once a day.
|Re: Connecting External Server To Local Database by uspry1(f): 11:59am On Apr 17, 2008|
There are three ways you can do MySQL remote/local synchronization for your client working on your web project at below:
1.) You could use MySQL replication, with your laptop as a replication client. Each time you connect your laptop will pull all changes to your tables since the last time you connected.
The replication is about zero writes on the slave. It is used where you expect a slave to do nothing. Of course, you can use replication to get the source data into one database on your local server, then copy the data to a working schema using INSERT , SELECT queries and only make changes on the working schema.
2.) Under the website development contract where it is shown the agreeing with you and your client to furnish client's hosting server login system (username/password) to access the client's remote MySQL server, you can copy the data from your local server to remoted working schema using INSERT, SELECT queries and modify the working schema.
3.) You register the web-based remote access such as "GoToMyPC" (link: https://www.gotomypc.com/) or set up using Windows XP/Vista's "Remote Assistance" with Windows Live Messenger (formerly MSN Messenger) that allowing you to access remoted client's computer system to open client's local server to replicate source data into client's MySQL using INSERT, SELECT queries and modifying the working schema. Be sure you and your client must have Windows Live Messenger login on. Google how to use Windows' Remote Assistance or check with your Windows XP/Vista Help and Support.
It is usually for remote web developer for foreigner/remote client in the distance without driving or meeting in person.
** If you are LINUX OS, then I am bit rusty to answer MySQL remote/local synchronization with LINUX. . .it would be different LINUX syntax. I used to be familiarized with LINUX debian-based OS in the past. **
|Re: Connecting External Server To Local Database by uspry1(f): 12:09pm On Apr 17, 2008|
The most of time I deal with my clients working on MySQL database, I do replicate all my source data from my local server (not client's local server) to be copied into my client's remote MySQL server with client's hosting server username/password access according to my/client's website development agreement/contract.
Of course I code INSERT, SELECT on MySQL queries to modify the working schema in quality of database functionally the exactly the same as my local server.
I have no problem with that!
I used to have "GOTOMYPC" remote access to client's computer system in the distance only for COMPUTER REPAIR such as Virus attack, software upgrades, etc. as well as pick up document/pictures/external files need for my design project ONLY WITH CLIENT'S PERMISSION. Because my client is CLUELESS about computer, do not know nothing about it!
I terminated "GOTOMYPC", because it cost money per month!!!
|Re: Connecting External Server To Local Database by Kobojunkie: 12:10pm On Apr 17, 2008|
Check out LOGINME.com , it is free
|Re: Connecting External Server To Local Database by uspry1(f): 12:14pm On Apr 17, 2008|
It prompts saying service discontinued.
|Re: Connecting External Server To Local Database by Kobojunkie: 12:15pm On Apr 17, 2008|
|Re: Connecting External Server To Local Database by mambenanje(m): 12:44pm On Apr 17, 2008|
if I get you clearly you want your web application to read a local mysql instance hosted on your clients computer. it means you have to convert your clients computer into a web server.
All you need to do is make your clients computer have a PUBLIC IP ADDRESS, then you can login to the mysql on his computer by using the public IP address as the server host.
from there all what you want is possible, you can host the whole application within the clients computer and it will still serve the world. But one thing is that the clients computer must be on 24/7 which I dont think is possible in Africa
hope it helps
|Re: Connecting External Server To Local Database by AbidemiA: 10:58am On Apr 18, 2008|
I hv been following your contributions on this forum. I will like us to talk one on one. my contact is email@example.com
|Re: Connecting External Server To Local Database by mcneal: 6:33pm On Apr 18, 2008|
>> Using Windows:
You can place the command below in a batch script, and use the "at" command or Windows task scheduler to execute it at intervals.
\ , \xampp\mysql\bin\mysqldump --create-options -u [local_db_user] -p [local_db_password] -h localhost --add-drop-table [name_of_local_database] | \ , \xampp\mysql\bin\mysql -h [remote_MySQL_hostname_OR_IP_address] -u [remote_db_user] -p [remote_db_password] [name_of_remote_database]
"\ , \" - Replace with full path to where your XAMPP was installed, e.g F:\Program Files\
Values in squared-brackets "" are to be replaced with appropriate values and without the "".
Host on both sides (ISP & Web host) must allow remote access to MySQL port (default 3306)
You might need to allow remote access to your online (webhosts) DB - can be done using phpMyAdmin or host's control panel.
Loads of possible command line switches is available at http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Other refs: http://www.sitepoint.com/article/backing-up-mysqldump/2 (read Method 3)
You can also use the replication option, but you most likely will need to be in control of of the remote server as well.
>> Real-time Access
If your client have a public IP, enable TCP access to MySQL port (default 3306) from your webhost, grant access privilege to database user that will be connecting remotely, point your PHP app to connect to clients public IP and you should be fine.
Hope this helps
|Re: Connecting External Server To Local Database by mambenanje(m): 1:51am On Apr 20, 2008|
I am happy to read your request and I will get to you soon when I catch some time
|Re: Connecting External Server To Local Database by dhtml18(m): 10:16am On Feb 09, 2012|
Trigger fails on some server. U can synchronize 2 databases via a single php script on the local server. Configure windows task scheduler to run it.
I can't post da full steps here. If u nid help on dat lemme know.
|Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health |
religion celebs tv-movies music-radio literature webmasters programming techmarket
Nairaland - Copyright © 2005 - 2015 Oluwaseun Osewa. All rights reserved. See How To Advertise. 144