how do i extract values of a field in SQL using phpmyadmin when the host is not my localhost ?
The following commands work well on localhost:
SELECT NAME
INTO OUTFILE '/name.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM tablename
;
I've read it should run like this on another host, but it doesnt work:
mysql hostIP username password -e
SELECT name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM tablename databasename
> emails.txt
Do you know how you run this command in phpmyadmin ?