# var/lib/mysql
# ll
# mysqldump Db_name > Db_name.sql

==============================

copy the backuped item to public_html

# cp var/lib/mysql/Db_name.sql /home/user/public_html.

=============================
Restoring it
# mysql Db_name.sql > Db_name

=========================
To check
# mysqlcheck Db_name