Log in

View Full Version : HeidiSQL > Import Query?


Chanus
11-15-2010, 11:03 AM
So, I'm on Step 10 of This Setup Guide (http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ) and it says:


10) Here's an SQL file to make accounts. Make sure your PEQLoginDB is selected, and import this query.
You can save this as an .sql file, or copy/paste it in the Query window in HeidiSQL and import it.
INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');



But it's not really clear where I'm supposed to paste it (possibly because I've never used Heidi before). The way I have it now it's just one line in Query #1, but I don't know what I should name it... or am I supposed to add it on to the end of something else?

Chanus
11-15-2010, 12:41 PM
Okay, so apparently it's my ineptitude with Heidi that's the culprit here.

Figured it out.

Thanks.