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

BMcDonald · **Joined:** Mon Mar 23, 2009 3:37 am **Posts:** 39

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 · **Joined:** Wed Dec 28, 2005 9:13 pm **Posts:** 6732

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

BMcDonald · **Joined:** Mon Mar 23, 2009 3:37 am **Posts:** 39

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 · **Joined:** Mon Mar 23, 2009 3:37 am **Posts:** 39

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 · **Joined:** Mon Mar 23, 2009 3:37 am **Posts:** 39

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 · **Joined:** Wed Dec 28, 2005 9:13 pm **Posts:** 6732

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

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

Who is online