Hi there,

I was wondering if MySQL was able to make remote sql calls like the way Oracle can with database links?

I would like to have a stored proc which selects data from the local db and inserts the data into a remote db at another site. Has anyone done this inside the MySQL db?

Any help/comments appreciated..

DayneO

But you can initiate this remotely in the command prompt.

mysql --user=host_username --host=xx.xx.xx.xx -p < local_file.sql