Re: [PHP] Connecting LocalHost Remote mySQL DB
On Saturday 13 July 2002 14:11, Thomas Edison Jr. wrote: 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. Allow remote access to your local mysql (read up on the security chapter of manual). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* It is easier to fight for principles than to live up to them. -- Alfred Adler */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Connecting LocalHost Remote mySQL DB
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. Just use mysqldump, like someone else suggested. Dump your local database, upload it, and import it. Any PHP solution isn't going to be 100% dependable, because you will run into the 30 second time limit on scripts. You can't really get that many queries done in 30 seconds... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Connecting LocalHost Remote mySQL DB
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
Re: [PHP] 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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
