Healthy Sandwich

Ingredients:

  1. red onion  – Medium size 1/2
  2. avocado – 1
  3. cucumber – 1
  4. tomato – 1
  5. bell pepper – 1
  6. salt
  7. olive oil
  8. black pepper
  9. Baby Spinach/Basil leaves
  10. Garlic – 2-3 cloves
  11. green chilli(optional) – 1-2

Step 1:

Wash the vegetables and cut them into thin slices as shown.

Step 2:

Spray olive oil. Sprinkle salt and pepper as per taste.

IMG_4794.JPG

Step3:

Grind spinach or basil leaves along with few garlic cloves and green chilli. Green chilli is optional based on your taste.

IMG_4802.JPG

Step 4:

Take 2 slices of fresh wheat bread. Apply the spinach paste on one of the slice.

IMG_4806.JPG

Arrange vegetables on it.

IMG_4827.JPG

You can sprinkle pepper and salt as per taste.

Step 5:

Sandwich is ready to have 🙂 You can grill it too using sandwich grill.

IMG_4829.JPG.jpegIMG_4822.JPG

 

 

Advertisements

Exporting data from Amazon RDS MySQL database to .csv or viewable in Excel sheet.

Amazon RDS do not allow to export table content to a csv file using mysql command.

select * from desired_table
INTO outfile "/path/to/csv file/file.csv"
fields terminated by ',';

gives an error: “Error Code:1045 Access denied for user ***@***.rds.amazonaws.com using password=YES”

As it said access denied I tried to grant access using:
grant all privileges
on YOUR_DATABASE.*
to 'username'@'***.rds.amazonaws.com'
identified by 'your_password';
>flush privileges;

But this did not work too.

There’s no issue from your end. MySQL creates the file on database server. It does not give permission to the client to create a file.

So a simple way to export the data to csv is by using unix sed command.
mysql -u username -p database_name -h ***.rds.amazonaws.com --port=3306 --batch -e "select * from desired_table"  |  sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv