doujun5009 2016-12-30 04:45
浏览 47
已采纳

使用php Codeigniter的mysql转储,与godaddy的服务器问题

I am using php to get backup of mysql database. On localhost it's working fine and the command is run as following:

$cmd = 'D:\xampp\mysql\bin\mysqldump --user=' .$db['username'].' --password=  '. $db['password'] .'     --host='.$db['host'].'  '.$db['database'].' > '.FCPATH.$filename;
system($cmd,$return);

This works perfect when at localhost, but I want to this at godaddy hosting, so I don't know how to find the mysqldump path or how to store the .sql file.

at local my app directory is this http://localhost/backup_app/ and folder i am using to store is http://localhost/backup_app/DB_Backup but actual path that i given to store .sql file is using FCPATH i.e D:\xampp\htdocs\backup_app and I don't know how to generate this path on godaddy.

Can anyone help?

  • 写回答

1条回答 默认 最新

  • dongsu3138 2016-12-30 05:06
    关注

    You tagged to question with codeigniter. Once I done this. I am sharing the code with you, lets hope it will work for your version of CI.

    In version 2.x, CI dbforge class not supporting to mysqli driver, so I set the driver to mysql.

    $db['group_one']['dbdriver'] = 'mysql';
    

    Define the path in constants to store the file.

    define('ADMIN_DOCS_PATH','adminDocs/');
    

    The code to take backup and store the file on disk.

    public function getDatabaseBackup()
    {
        $this->db = $this->load->database('group_one', TRUE);
        $this->load->dbutil();
        $doc_name = 'DatabaseBackup'.date('YmdHis').'.sql.zip';
        $prefs = array(
                'tables'      => array(),           // Array of tables to backup.
                'ignore'      => array(),           // List of tables to omit from the backup
                'format'      => 'zip',             // gzip, zip, txt
                'filename'    => $doc_name,         // File name - NEEDED ONLY WITH ZIP FILES
                'add_drop'    => TRUE,              // Whether to add DROP TABLE statements to backup file
                'add_insert'  => TRUE,              // Whether to add INSERT data to backup file
                'newline'     => "
    "               // Newline character used in backup file
              );
        $backup =& $this->dbutil->backup($prefs);
        $this->load->helper('file');
        write_file('./'.ADMIN_DOCS_PATH.$doc_name, $backup);
    }
    

    Try this, also confirm your CI version and its support to dbforge class to download the database dump.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 我想通过python处理sybase IQ库的一些数据,但是不知道sybase IQ库怎么连接,之前连接都是用linux上的 dbisql
  • ¥15 安装llama-cpp-python==0.1.83失败
  • ¥20 管道轴向耦合水击问题
  • ¥60 补全networkx TODO部分。
  • ¥15 有内推吗,云计算linux运维方向
  • ¥30 sort cuteSV.vcf by bcftools用IGV可视化出现报错
  • ¥100 SOS!对STK中导出的天体图像进行质心提取有没有人做过啊
  • ¥15 python 欧式距离
  • ¥15 遗传算法解决有工序顺序约束的大规模FJSP问题
  • ¥15 企业消防水炮塔设计方案