Re: Connecting LocalHost & Remote mySQL DB

Glory! Exactly.. that IS the problem. You see, my mySQL DB on the Server/Internet, on my website.. it DOES NOT allow Remote Host Connection. That's why i need to use a PHP page, that too based on the server. Because i need to move tabel data on my Client/My Computer to the Tables on my Website mySQL. Thanks, T. Edison Jr. --- Jason Wong <php-general@gremlins.com.hk> wrote: > On Saturday 13 July 2002 13:45, Thomas Edison Jr. > wrote: > > Glory! > > > > Let's say i got a bunch of Data in my mySQL Table > on > > my localhost. I need all this Data uploaded on my > > mySQL on the Server/Internet. > > > > Now one way is to use phpMyAdmin, Export the > original > > data on LocalHost to a .CSV file, then use the > Server > > phpMyAdmin to upload the same .CSV file to the > table > > on the server. > > > > What could be an alternate, in case we dont' want > to > > use this lengthy procedure. Can i make one page > which > > will do both these things? > > .OR. > > Can my PHP page on my server, directly pick up > data > > from my localHost mySQL, and feed it in the mySQL > > Table on the server? > > If all you want is to copy data from > ServerA/Database/Table to > ServerB/Database/Table you don't even need PHP. > > Providing that at least one of the server allows > remote access then the > easiest way is to use mysqldump. For details consult > mysql manual. > > -- > Jason Wong -> Gremlins Associates -> > www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet > Applications Development * > > /* > Love is in the offing. > -- The Homicidal Maniac > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastech@yahoo.com Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com