I am trying to backup mysql using the command
mysqldump -u root -p database_name > backup.sql
but it is throwing an error:
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Also, i wanted to make a backup my database with all tables saperately sotored as a file. How can i do it?
Solution:
use --no-tablespaces
CNERIS is a company formed by young entrepreneurs from different sectors of the world of information. Our team consists of programmers, system administrators, graphic designers.