mysqldump -u root --password=passwd databasename > db.sql mysql -u root --password=passwd databasename < db.sql echo "select * from column" | mysql -u root -p -A databasename > result.txt

1
2
3
4
5

#backup_mysql.rb
dbs=`mysql -u root --password=passwd -Bse 'show databases'`.split("\n")
dbs.each do |db|
  `mysqldump -u root --password=passwd #{db} > #{db}.sql`
end