Wednesday, July 29, 2009

DataBase Tips

Grant all permission for user
grant all privileges on DBNAME.* to root@IPAddress identified by 'Pasword' with grant option

Get
mysql -USER -PAssword DBNAME -B -e "SQL Query;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > FileName.csv