How do I output the result to a .csv file format if I telnet to the MySQL database?
ljCharlie
How to output result to .csv file format?
Moderator: General Moderators
Again, thanks! However, it didn't work. I received an error. Here's what I did.
The error from the above command is:
ERROR 1045: Access denied for user: 'alumni@localhost' (Using Password: YES)
Any idea on what I did wrong or what's going on? The user name and password I used to logon to the mysql database does have full right. The reason I know this is that the Administrator who gave me this account say so and I was able to do anything using phpMyAdmin to edit/change/delete/add.
Another question, is there a way to do the same thing within phpMyAdmin?
ljCharlie
Code: Select all
mysql> SELECT * INTO OUTFILE 'emailDirectory.csv' FROM email;ERROR 1045: Access denied for user: 'alumni@localhost' (Using Password: YES)
Any idea on what I did wrong or what's going on? The user name and password I used to logon to the mysql database does have full right. The reason I know this is that the Administrator who gave me this account say so and I was able to do anything using phpMyAdmin to edit/change/delete/add.
Another question, is there a way to do the same thing within phpMyAdmin?
ljCharlie
export
look for the export tab and in there you should find all the things neccessary including saving the file somewhere of even printing it to the screen in case you don't hava access to the file structure.