Ratheesh K J wrote:
> Ok.. Will it be secure if the data is encrypted. mysqldump will show
> encrypted data right.
mysqldump will show whatever the database table does - it just grabs
that info and puts it into a file. If it's encrypted in the table,
that's what mysqldump will show.
> Actually I want to know what is the best practice for such applications.
> Can I say that encryption alone is sufficient to secure my data. Or is
> there any other strategy used for data protection?
You could create views for the queries you need, revoke access to the
base table and only grant access to the views instead.
Whether that helps or not depends on what you're trying to protect, and
what you're trying to stop happening.