Change MySQL Server Host Address

jules22's profile image jules22 posted 3 years ago in General Permalink

Seasonal Greetings.

First of all I have almost no knowledge of SQL, but am hoping some wise-one can help me.

I inherited a problem with SQL as a link in a chain for an internet radio station. As far as i can gather SQL dispays a history table of the output content of the stations computer program. This then, in remote history, requests connection to the station website in order that images for the corresponding artist, stored with Filezilla, can be displayed on the website. Basically the whole thing crashed and since the technician who set it up a few years ago is no longer available, a "helpful" person restored the SQL link, but unfortunately it was an old one of the station's previous web address which is no longer operational.

Remote history is therefore giving me "Error [1429] Unable to connect to a foreign data source. Unknown MySQL data source", as it is tryng to connect to the old website. Please can someone advise me on how to change it to the current correct website address, so that the images should come back on line.

Any help or advice would be greatly appreciated.
Thanks Jules

ansgar's profile image ansgar posted 3 years ago Permalink

The error message sounds as if you have some federated tables running in MySQL. At least the Google results give me the impression. Apart from that I have no clue about your server. You will probably need someone looking at the server setup.

jules22's profile image jules22 posted 3 years ago Permalink

Sorry if I'm not getting this, but it says that SQL remote history is looking for www.comedyrokk.com, when it should be looking for www.comedy-rock.com Is this not changed in SQL?

Please login to leave a reply, or register at first.