Backup mysql database

How can I make a copy of the whole database with data? Or how can I make a copy of tables with data within the same database? I followed but it doesn't copy anything.

One more thing, how can I store same data from one column to another column in the same table?


I don't understand what you mean by "doesn't copy anything". Is it not creating the backup file? Is it empty?

If you have data in a column, why would you need it in another column? It's already there.