MySQL数据库Drop Down后的紧急处置

作者：网络转载发布时间：[ 2013/6/24 9:53:35 ] 推荐标签：

　　于是我zip了所有bin文件，回传到本地，用c#写了个过滤代码，找到 use darok2_2，知道这段内容都是达洛克战记2服的数据。

    public void test()
    {
        FileStream stream = File.OpenRead(@"E:玩转中国程序设计达洛克战记xtar-backupsvn达洛克战记2xsvnserver-deploymysql-bin.000027.txtmysql-bin.000027.txt");
        StreamReader reader = new StreamReader(stream， Encoding.GetEncoding("GBK"));

        FileStream streamO = File.Create(@"E:玩转中国程序设计达洛克战记xtar-backupsvn达洛克战记2xsvnserver-deploymysql-bin.000027.txt00027.out.txt");
        StreamWriter writer = new StreamWriter(streamO， Encoding.GetEncoding("GBK"));

        Encoding gbk = Encoding.GetEncoding("GBK");
        Encoding utf = Encoding.Default;

        string strLine = reader.ReadLine();

        while (strLine != null)
        {

            if (!strLine.StartsWith("use darok2_2"， StringComparison.OrdinalIgnoreCase))
            {
                strLine = reader.ReadLine();
                continue;
            }

            do
            {
                if (strLine == null)
                    break;

                if (strLine.StartsWith("use"， StringComparison.OrdinalIgnoreCase) && !strLine.StartsWith("use darok2_2"， StringComparison.OrdinalIgnoreCase))
                {
                    strLine = reader.ReadLine();
                    break;
                }

                if (strLine.StartsWith("INSERT"， StringComparison.OrdinalIgnoreCase) || strLine.StartsWith("DELETE"， StringComparison.OrdinalIgnoreCase) || strLine.StartsWith("UPDATE"， StringComparison.OrdinalIgnoreCase))
                {
                    writer.Write(strLine);
                    writer.WriteLine(";");
                }
                else
                {
                }
                strLine = reader.ReadLine();

            }
            while (true);
        }

        writer.Flush();
        writer.Close();

        reader.Close();
    }