Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Exporting table from Amazon RDS into a csv file

    • 0
    • 3
    • 3
    • 1
    • 0
    • 0
    • 0
    • 0
    • 1.19k
    Comment on it

    A simple command to export tables from Amazon RDS into a csv file

    mysql -uroot -ptest123 --database=test -e "select concat(id,',',login) FROM users" > userdata.csv
    

    This command will simply connect to mysql from terminal using root as username , test123 as password and will concat data of id and login columns as comma separated values from table users and will export it as a csv format file having name userdata.csv

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: