in reply to mysql remote server query

As someone has already mentioned, you don't need a Perl script (I know; it's pure blasphemy to say that here, but...) The thing you're looking for is the 'mysqldump' command line syntax needed to do this. Here's an example:

mysqldump -h [remote_host] -u [user] -p [database] > out.sql

This will connect to the remote_host with the specified user name, and dump the database after you provide the password (you'll be prompted for one because of the '-p' option.) If you run this command on your local computer, you'll end up with a file called 'out.sql' containing all the mysql commands necessary to recreate that database.


--
"Language shapes the way we think, and determines what we can think about."
-- B. L. Whorf