just a question...

Bored_Student

im running a perl script on my home machine, retrieving information. I wanted to know if their was a way to upload this information to a remote MYSQL server?

if so, how?

herve

If the MySQL server is accessible via Internet, yes you can do that.

MySQL server is listening on port 3306 by default. So the idea is to connect
to this port and then run an UPDATE query on the database with the data collected by your PERL script.

In PERL, you should use the DBI package (CPAN).

Example :
http://64.233.179.104/search?q=cache:4nk9zc_c1hQJ:www.synnottsoftware.com/tutorials/perlmysql.php+%2BPERL+%2BMysql+%2BDBI+%2B3306&hl=fr&gl=fr&ct=clnk&cd=10

Bored_Student

ok...so if say this is my sql line

#Connects to the MYSQL Database
$SystemDB = DBI->connect ("DBI:mysql:database=$DBNAME:host=$DBHOST",$DBUSER,$DBPASS) or die "Can't connect to database\n";

(using DBI)

i should have said also, im running mysql locally on my machine at the mo, so $DBNAME is set to localhost, but i want it to be able to upload to a mysql server remotely

so what changes would i need to make to the DBNAME to allow this to occur?

on the remote websever it is telling me that its DBNAME is <databasename>:localhost, so would i just add the port number on the end??

herve

Yes, look at the link above.

Extract :

my $dbh = DBI->connect("DBI:mysql:database=demodb;host=localhost;port=3306", "demo", "demo");

and of course "host=localhost" is replaced by a "host=your_server.com",
where your remote MySQL server is set up.