Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 19th, 2003, 11:07 PM
Registered User
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Remote connection to a MySql database.

Hi. I would like to get some help from anyone who knows how to perform a remote connection to a mysql database. My mysql database is located at a web hosting company. I tried using their phpMyAdmin interface to load the data file (in .csv) format, but failed. My current system doesn't have Microsoft Access, but I have installed MyODBC. How can I upload a .csv file too the remote database?


Old July 4th, 2003, 08:43 AM
Authorized User
Join Date: Jun 2003
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts

Not really sure how to connecvt using MyODBC. But the query your lookig for to load up your csv file is a LOAD DATA INFILE one try

If that looks a mess here is an example

LOAD DATA INFILE 'file/location.csv' INTO TABLE phone_main FIELDS TERMINATED BY ','

That will load a file called location.csv into a table called phone_main and is telling it that the values are seperated by commas.

Perhaps if you look around on that website some you might find some MyODBC stuff.

Hope that helps you
Old May 14th, 2005, 06:09 AM
Registered User
Join Date: May 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

try http://www.webyog.com/
As in everything you get what you pay for and it has a sync tool.
costs around $99

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to connect a PDA to a remote mysql database? baburman .NET Framework 2.0 2 November 24th, 2008 12:59 PM
Remote connection to DB2 database from PHP gouree Pro PHP 2 August 11th, 2006 05:09 PM
Remote database connection tdaustin Classic ASP Databases 0 November 28th, 2005 11:28 PM
MySQL Database Connection jayteee Dreamweaver (all versions) 0 December 11th, 2004 11:27 PM
Remote connection to a MySQL database. Major Sahimi PHP How-To 2 July 9th, 2003 10:01 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.