Example of a SQL Query for Importing a remote SQL List Pleas

[BMcDonald]

Well I figured out how to get into my mySQL database for importing a list but I don't understand how to write a proper query. All I want to do is download the basic, firstname, last name, company and email address from the database bgcan_mlm from the list KTAO_enews

 

[stanbusk]

Re: Example of a SQL Query for Importing a remote SQL List P

Why don't you use the 'Remote Lists' menu in the list pull-down menu? It is just for downloading MLM lists.

 

[BMcDonald]

Re: Example of a SQL Query for Importing a remote SQL List P

When I select the remote list, it doesn't download. It seems to check, but nothing acatually download. Not sure why. This has been exceptionally frustrating.

 

[BMcDonald]

Re: Example of a SQL Query for Importing a remote SQL List P

Actually, I just figured that problem out myself. I had a command in the remote list URL in my preferences when all I need was the URL to the lm.php file.

So now I'm able to access the database on the server, but how do I save that list to my local list so it's update?

 

[BMcDonald]

Re: Example of a SQL Query for Importing a remote SQL List P

Never mind. I shouldn't ask you questions until I'm done messing with it. I figured that question out too. Not sure why this is such a pain, but luckily, I'm able to figure it out. All's good now.

 

[stanbusk]

Re: Example of a SQL Query for Importing a remote SQL List P

Yes indeed, the MLM URL has to be the URL of the 'lm.php' file on your server.