23 Jul 2011, 14:39
#1
New Zenner
- Join Date:
- Mar 2011
- Posts:
- 31
- Plugin Contributions:
- 0
Export CSV file error
I am trying to export products to a csv file but get the permissions error below.
Is there anyway to run this code?
(I don't want to use EasyPopuate or PHPadmin)
I run the code below in TOOLS>SQL Patches
SELECT *
INTO OUTFILE 'downloads/result.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM products, products_description;
Error message:-
1045 Access denied for user 'user_admin'@'localhost' (using password: YES)
in:
[SELECT * INTO OUTFILE 'downloads/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM products,products_description;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Is there anyway to run this code?
(I don't want to use EasyPopuate or PHPadmin)
I run the code below in TOOLS>SQL Patches
SELECT *
INTO OUTFILE 'downloads/result.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM products, products_description;
Error message:-
1045 Access denied for user 'user_admin'@'localhost' (using password: YES)
in:
[SELECT * INTO OUTFILE 'downloads/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM products,products_description;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.