Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Cannot connect to ISP mysql

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Cannot connect to ISP mysql

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • October 12, 2004 at 7:44 pm #8607
      deanquin
      Member

      I am trying to sync my test database running in my linux box with my database running in my ISP (both mysql and linux).

      I've edited the sample xml file to include the IP, user, pwd and port of my ISP. I am getting an error “Could not connect to target mySQL server”.

      Is the IP for mysql the same as my domain's IP, but with a different port: 3306? my domain is premierpower.com.

      Any ideas?

      thanks,

    • October 12, 2004 at 8:33 pm #16389
      Shadow
      Member

      It is up to your ISP to answer this question! Do you have any “traditional” PHP scripts running that use MySql backend? If yes, then check out the connection parameters and enter the same in the config file.

    • October 12, 2004 at 9:02 pm #16390
      deanquin
      Member

      Yes. I have php/mysql applications running in the ISP server without problem.

      The question is if I can access the database from outside that ISP server.

      in the xml HOST parameter I only need to put the IP of my domiain, is it correct?

      the port is always 3306 and then the database name and user/pwd.

      The string Localhost in the HOST parameter is only used with my local database, is this correct?

      thanks.

    • October 13, 2004 at 11:18 am #16391
      Shadow
      Member

      Sorry, must have overlooked something in your first post. Never mind about your PHP scripts, as they run locally on the ISP's servers.

      Ask your provider if they allow direct connections to be made to their MySql server and if yes, then what parameters must be used. Many ISPs do not allow remote connections… As far as I'm concerned, HTTP tunneling cannot be used with SJA yet. (Ritesh may correct me on this issue if I don't figure it out myself)

    • October 13, 2004 at 11:29 am #16392
      Shadow
      Member

      Sorry once again, SJA bundled with 4.0 beta may use HTTP tunneling.

      So, if your ISP does not allow direct connection from remote hosts, then you have to copy SQLyogTunnel.php to ISP's server and use tunneling features in the connection.

    • October 13, 2004 at 12:14 pm #16393
      Ritesh
      Member

      SJA 4.0 bundled with SQLyog 4.0 BETA can use HTTP Tunneling.

      You can sync data to your ISPs server even if direct access is not provided 🙂

    • October 13, 2004 at 1:23 pm #16394
      Shadow
      Member

      I figured that out by starting SQLyog…

  • Author
    Posts
Viewing 6 reply threads
  • You must be logged in to reply to this topic.