yii-dump-db Follow @yiiframework

Another extension that allows to create backups of mysql database (structure and data)

Extension that allows to create backups of mysql database (structure, data and FK's)

Requirements ¶

Yii 1.1 or above.

Usage ¶

Download the extension on bitbucker: https://bitbucket.org/rodzadra/yii-dump-db/downloads
Extract yii-dump-db to extensions directory

On controller:

(to download the generated sql file)

Yii::import('ext.dumpDB.dumpDB');
  $dumper = new dumpDB();
  $dumper->getDump();

(to show the generated sql)

Yii::import('ext.dumpDB.dumpDB');
  $dumper = new dumpDB();
  echo $dumper->getDump(false);

Resources ¶

Total 4 comments

#10522

nucreativa at 2012/11/02 05:41am

$dumper->getDump(); not work

Hi, thanks for your extension. But I found there is something wrong. when I want to generate as sql file, it doesn't work. It always return 0 size file sql (without contain). but I made some changes to make it work.

public function getDump($download = TRUE)
    {
        ob_start();
        foreach($this->getTables() as $key=>$val)
            $this->dumpTable($key);
        $result = $this->setHeader();
        $result.= ob_get_contents();
        $result.= $this->getConstraints();
        $result.= $this->setFooter();
        ob_end_clean();
        if($download){
            header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
            header("Cache-Control: no-cache");
            header("Pragma: no-cache");
            header("Content-type:application/sql");
            header("Content-Disposition:attachment;filename=downloaded.sql");
        echo $result;exit;// I adding this line
        }
        return $result;
    }

sorry for my bad english :D

#8104

rodzadra at 2012/05/10 08:30am

Thank you, aidai524

Thank you, aidai524.

I have corrected it.

#8101

aidai524 at 2012/05/10 05:36am

The Usage has a error

the code '$dumper = new dbBackup();' is wrong, the correct code should be '$dumper = new dumpDB();'

#7906

bennouna at 2012/04/25 02:50pm

Can you explain the difference with database-dumper?

It has just been released 5 days ago, and you've listed it in "Resources" on this page. What's the difference between the two?

Please login to leave your comment.

yii-dump-db Follow @yiiframework

Requirements ¶

Usage ¶

Resources ¶

Total 4 comments

Leave a comment

Yii Supporters