To export a database use this command in terminal. #mysql#terminal
mysqldump -u [username] -p [database] > db_backup.sqlIf that does not work for you then you may have created a user in cPanel or some other website management application. You may have to use the --no-tablespaces tag. The syntax looks like this
mysqldump --no-tablespaces -h localhost -u database_name -p user_name > bd_backup.sql