I have a Mysql database running on amazon-ec2. I doubt if I can use workbench or something. In that case, how can I safely backup my database.
I want something portable, like some command I hit and I get a file or zip that I can carry anywhere with easy.
I know about mysqldump. But it gives me set of INSERT/CREATE queries. Can I create backup as a database object?