Need Yii 1 Extension For Dump Of My Mysql Database With Funcs And Views

Yii 1.1 General Discussion
1

Hi All,

I found and installed extension http://www.yiiframework.com/extension/yii-dump-db/ for making dump of my mysql database. It works, but it does not make dumps of funcs and views.

I just entered several "functions" and "views" and they are visible in phpmyadmin and HeidiSQL.

If there is some convinient tool for this, maybe not native yii, but easy to install in yii 1.1.15 app?

Thanks!

2

One line code that will do all this for you, you don’t need an extension:




exec('mysqldump -u USER -pPASSWORD DATABASE_NAME > /var/www/backups/database-' . time() . '.sql');