php实现redis数据库指定库号迁移

[root@localhost ~]# php 1.php
1/407
101/407
201/407
301/407
401/407

<?php
$from = '10.0.2.52:6379/7';
$to   = '127.0.0.1:6379/7';
$from_redis = redis_init($from);
$to_redis   = redis_init($to);
$keys  = $from_redis->keys('*');
$count = 0;
$total = count($keys);
foreach($keys as $key){
    if(++$count % 100 == 1){
        echo "$count/$total＼n";
    }
    $type = $from_redis->type($key);
    switch($type){
        case Redis::REDIS_STRING:
            $val = $from_redis->get($key);
            $to_redis->set($key, $val);
            break;
        case Redis::REDIS_LIST:
            $list = $from_redis->lRange($key, 0, -1);
            foreach($list as $val){
                $to_redis->rPush($key, $val);
            }
            break;
        case Redis::REDIS_HASH:
            $hash = $from_redis->hGetAll($key);
            $to_redis->hMSet($key, $hash);
            break;
        case Redis::REDIS_ZSET:
            $zset = $from_redis->zRange($key, 0, -1, true);
            foreach($zset as $val=>$score){
                $to_redis->zAdd($key, $score, $val);
            }
            break;
    }
}

function redis_init($conf){
    $redis = new Redis();
    preg_match('/^([^:]+)(:[0-9]+)?＼＼/(.+)?/', $conf, $ms);
    $host = $ms[1];
    $port = trim($ms[2], ':');
    $db = $ms[3];
    $redis->connect($host, $port);
    $redis->select($db);
    return $redis;
}
 

<?php
mysql_connect("localhost","root","");//连接MySQL
mysql_select_db("hello");//选择数据库
?>

<?php
require_once("conn.php");//引用数据库链接文件

$uname = $_GET['n'];//GET方法为URL参数传递
$psw = $_GET['p'];
$psw=md5($psw);//直接使用MD5加密

$sql = "insert into members(username,password) values ('$uname','$psw')";
mysql_query($sql);//借SQL语句插入数据

mysql_close();//关闭MySQL连接
echo "成功录入数据";
?>

while($row = mysql_fetch_array($result))
{
echo "<div style="height:24px; line-height:24px; font-weight:bold;">"; //排版代码
echo $row['Topic'] . "<br/>";
echo "</div>"; //排版代码
}

<?php
 $con=mysql_connect("localhost","root","gl");
 mysql_select_db("happysea");

 $name=$_POST['name'];
 $password=$_POST['password'];
 $sex=$_POST['sex'];
 $e_mail=$_POST['e_mail'];
 $question=$_POST['question'];
 $answer=$_POST['answer'];

 $sql="insert into userinfo(name,password,sex,e_mail,question,answer)
  values('$name','$password','$sex','$e_mail','$question','$answer')";
 
 if(!$sql)
 {
  echo('注册失败!');
 }
 else
 {
  echo('注册成功!');
 }

?>

这是数据库。

mysql> describe userinfo;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id             | int(11)         | NO    | PRI | NULL    | auto_increment |
| name       | text              | YES  |        | NULL    |                |
| password | varchar(20) | YES  |        | NULL    |                |
| sex           | char(4)         | YES  |        | NULL   |                |
| e_mail      | varchar(30)  | YES  |        | NULL    |                |
| question   | text               | YES  |        | NULL    |                |
| answer     | text               | YES  |        | NULL    |                |
+----------+-------------+------+-----+---------+----------------+

/*
Navicat MySQL Data Transfer

Source Server         : www.111cn.net localhost
Source Server Version : 50133
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50133
File Encoding         : 65001

Date: 2011-10-11 14:11:38
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `execl`
-- ----------------------------
DROP TABLE IF EXISTS `execl`;
CREATE TABLE `execl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of execl
-- ----------------------------
INSERT INTO `execl` VALUES ('14', 'jim');
INSERT INTO `execl` VALUES ('15', 'taurus');

<?php
if($_FILES['execl']['name']){
 $db = mysql_connect('localhost','root','');
  mysql_select_db('test');
  mysql_query('set names gbk');
  require_once 'reader.php';
  $data = new Spreadsheet_Excel_Reader();
  $data->setOutputEncoding('CP936');
  $data->read($_FILES['execl']['name']);
 error_reporting(E_ALL ^ E_NOTICE);
 $sql   = "";
 for($i=1;$i<=$data->sheets[0]['numRows'];$i++)
 {
  if($data->sheets[0]['cells'][$i][1]!=""){
   $sql = "INSERT INTO `execl`(`name`)values('".$data->sheets[0]['cells'][$i][2]."');";
   if(mysql_query($sql)){
    
    echo '成功';
   }else{
    die('失败');
   }
  } 
 }
}
?>
<head>
</head>
<body>
  <form action="" method="post" enctype="multipart/form-data">
      <input type="file" name="execl" />
      <input type="submit" value="导入数据" />
  </form>
</body>