Well, you could have the Canadian admin add your pakistan IP address/host to the "mysql" database in the "hosts" table, along with the proper "user" and "db" I'm sure. Then you can use any 3rd party mySQL client to connect and do whatever you want.
Something I just did recently is to install phpMyAdmin (http://www.phpmyadmin.net/) on the remote (canadian) server and use the built in export feature. This feature is incredibly slick, it even automatically .zip or .tgz the file for you and pushes it to you! The compressed version is significantly smaller than the full version of the .sql file. Then you simply login to your local mysql database (whichever you choose) using the 'mysql' command line client and use the "\." option to create the tables and all the data in one go from the unarchived .sql file you just created. It worked flawlessly for me. The other option is to have your ISP send (email/ftp) all the /var/lib/mysql/mydatabase files (archived I assume), put them in the same dir on your server, and restart mysqld. > I have MySQL 3.23.36 on my web server somewhere in Canada, > while I live in Pakistan. I want to connetc to my database > out there and use a query to download all the data from that > mysql db to my own mysql db. > > I know myql uses 3306 as the port and when i try telnet on my > own LAN it works fine, but out there it is not responding. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
