how to create backup database

Probably 2.x, but the result doesn't change in 3.0.

The backup feature as implemented in MySQLi (and maybe some of the other drivers) reads the structure and data of the tables and outputs very specific text to a .sql file to recreate that structure and insert the data. If this could be implemented for PDO, it would have to be implemented on the sub-driver level, since the backup is raw SQL, and can't be abstracted.

You might be able to create your own backup method which generates a migration file to recreate the database using dbforge and query builder (or active record in 2.x).

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide