How to export a database from phpmyadmin.
- Select the database you want to export
- Go to export
- Select custom instead of quick
- Format-Specific Options->Object creation options
- Select “Add CREATE DATABASE / USE statement
- Select “Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement”
- Then export the file
The is useful for searching the entire database, backing up the db and bulk find-replacing in the database.