How to export/import Civi CRM all database (profile, custom field, contacts etc) with same setting in WordPress?
If you are switching your cms from drupal/joomla to wordpress then there are instructions here. https://docs.civicrm.org/sysadmin/en/latest/misc/switch-cms/
If you are wanting to "clone" an existing set up using mysqldump there is a perl script that you will want to run to remove the "definer": statements.
perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g' /path/to/mysqldump.sql
More info on this thread.