Results 1 to 2 of 2

Thread: Remote sql

  1. #1
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253

    Unanswered: Remote sql

    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

  2. #2
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161
    But you can initiate this remotely in the command prompt.

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •