Export Database

How to export a database from phpmyadmin.

  1. SiteGround->cpanel->phpmyadmin
  2. Select the database you want to export
  3. Go to export
  4. Select custom instead of quick
  5. Format-Specific Options->Object creation options
  6. Select “Add CREATE DATABASE / USE statement
  7. Select “Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement”
  8. Then export the file

The is useful for searching the entire database, backing up the db and bulk find-replacing in the database.

Leave a Reply