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.

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

报告相同问题?

悬赏问题

  • ¥50 深度学习运行代码直接中断
  • ¥15 关于#单片机#的问题,请各位专家解答!
  • ¥15 关于#单片机#的问题,请各位专家解答!
  • ¥20 需要完整的共散射点成像代码
  • ¥15 编写vba代码实现数据录入工作
  • ¥15 做过TCL海信电视小米电视相关影视会员软件私我
  • ¥15 Mapreduce是正常的,在运行其他jar包时并没有任何问题,只是在做LogCount.jar 时出的问题。如图所示
  • ¥15 ImportError: DLL load failed while importing _iterative: 找不到指定的模块。
  • ¥15 如何通过交互分析得出某高危患者对放疗获益更多
  • ¥15 相关性分析中,p<0.05, r=0.29,怎么评价相关性呢