action_copy_mysql_to_mysql.php
上传用户:feiyaoda
上传日期:2016-11-21
资源大小:9556k
文件大小:2k
源码类别:
WEB邮件程序
开发平台:
PHP
- <?php
- include('./extensions/xtdump.lib.php');
- include('./pat_mysql_connect.php');
- /*
- if (FALSE == count($buffer_copy_files))
- {
- die ($get_string->get('no_db_to_dump'));
- }
- if ($_POST['export_format'])
- {
- // xt dump variables
- $sv_s = 1;
- $sv_d = 1;
- $drp_tbl = 1;
- $export_path = $_POST['export_path'];
- echo "<p class="big_text">".$get_string->get('copy_from_db')." $source_folder</p>n";
- mysql_select_db($source_folder);
- echo mysql_error() ;
- $wrapper['database'] = $source_folder;
- foreach ($buffer_copy_files as $id => $table)
- {
- // generating final path
- $wrapper['table'] = $table;
- $path = $target_folder.$newpath->wrap($export_path,$wrapper);
- $thefolder = dirname($path);
- rmkdir($thefolder);
- if ($_POST['auto_ext']) $path = $path.'.'.$_POST['export_format'];
- echo "<b>".$get_string->get('table')." $table</b><br>n";
- switch ($_POST['export_format'])
- {
- case 'csv' :
- {
- $content = csvdumptable($table);
- break;
- }
- case 'sql' :
- {
- $content = sqldumptable($table);
- break;
- }
- case 'xml' :
- {
- $content = xmldumptable($table,$fp,$write_datas);
- break;
- }
- }
- echo ' saving to '.$path."<br>n";
- open_file($path);
- write_file($content);
- close_file();
- }
- }
- /*
- CREATE TABLE `test`.`testssss` (
- `name` varchar(150) NOT NULL default '',
- `pass` varchar(100) NOT NULL default '',
- `forum_id` int(11) NOT NULL default '0',
- PRIMARY KEY (`name`,`pass`)
- ) TYPE=MyISAM;
- INSERT INTO `test`.`testssss` SELECT * FROM `filou`.`auth_members`
- */
English
