Nairaland Forum

Welcome, Guest: Join Nairaland / Login / Trending / Recent / New
Stats: 1262168 members, 1709937 topics. Date: Thursday, 30 October 2014 at 03:30 PM

Connecting External Server To Local Database - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Connecting External Server To Local Database (2973 Views)

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)

(0) (Reply) (Go Down)

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 grin). 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
go on
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

http://lists.mysql.com/mysql/49

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
Kobojunkie:

Check out LOGINME.com , it is free

@kobojunkie

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
@cmon
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
@mambenanje,

I hv been following your contributions on this forum. I will like us to talk one on one. my contact is info@adten.net
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]


N.B
"\ , \" - 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
@Abidemi_A
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.

(0) (Reply)

How Do I Obtain Interswitch Webpay / Best Web Hosting Company In Lagos? / Wordpress

(Go Up)

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

Links: (0) (1) (2) (3) (4) (5) (6) (7) (8) (9)

Nairaland - Copyright © 2005 - 2014 Oluwaseun Osewa. All rights reserved. See Nairalist and How To Advertise. 61
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.