Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
12
返回列表 发新帖

换服务器:SQL版本不同导致数据恢复不了

[复制链接]
 楼主| `某房某床某人` 发表于 2008-4-11 20:47:40 | 显示全部楼层
这回是按4.0备份的,提示
从47497开始删,一个一个删,删完这个提示下一下,。。。。这样一直删下去数据会少吗?
SQL: INSERT INTO [Table]posts VALUES ('47499','32','2107','0',0x61796131343132,'5891',0xa1be332e3135a1bfceacc8a820d0d0bbf5beadd3aabacdd0b3cffbb7d15f5fd2d7cffacdf8d7a8b7c3,'1204789926',0xa1a1a1a1332e3135cac7d2bbb8f6c9eec8ebc8cbd0c4b5c4cafdd7d6a1a3d3a6b8c3d3d0c0edd3c9cfe0d0c5cfd6d4dab5c4332e3135d2d1beadb2bbcff3b5b1b3f5c4c7d1f9b5c4c0edc2dbbbafa3acd6bbd2aac0cfb0d9d0d5d4dab9baceefbecdbbe1bacdcbfcc0adc9cfb9d8cfb5a1a3cbb5c6f0cad6bbfaa3acd4dac6bdcab1b5c4c9fabbeed6d0a3acd7dcc4dcbdd3b4a5b5bdd2bbd0a9b9d8d3dad6cac1bfcdb6cbdfbacdb7fecef1cdb6cbdfb7bdc3e6b5c4cecacce2a1a3c4bfc7b0cad6bbfacad0b3a1d6d0a3acb5bdb4a6b6bcd3d0cbaebbf5cad6bbfad4dab9abbfaabdd0cff9a3acb5cdc1d3b5c4d6cac1bfc5e4c9cfcedec1bcb5c4cadbbaf3a3acc9edb1dfceaacbaebbf5cad6bbfab4f3b5b9bfe0cbaeb5c4c9f9d2f4cac7b2bbbef8d3dab6faa1a3b6f8d3d6ceaabacebbb9d3d0c4c7c3b4b6e0c8cbb6d4cbfccac7c0d6b4cbb2bbc6a3c4d8a3bfd5e2b4ced4dad3eb5043484f4d45bacfd7f7b6e0c4ead6f7d3aad0d0bbf5cad6bbfab5c45b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5dd6d0d7f6c1cbd2bbb7acb5f7b2e9a1a30d0a0d0a5b625dcbaebbf5cad6bbfabcdbb8f1ceaacab2c3b4b5cdc1aea3bf5b2f625d0d0aa1a1a1a1d4dab4f3b2bfb7d6c8cbb5c4cbbccfebd6d02ccbaebbf5cac7b1c8d0d0bbf5b1e3d2cbb5c4a1a3c1f7d0d0d2d1bec3b5c4c5b5bbf9d1c7204e37334945c4bfc7b0d0d0cbaebbf5b2eebcdbb4f3b8c5d4da333030d4aad7f3d3d2a1a3d6b1b9dbc9cfcbaebbf5b1c8d0d0bbf5b1e3d2cbbdabbdfc333030d4aaa3acd5e2d7e3d2d4c8c3badcb6e0c8cbd0c4b6afa3a1b5abcac7a3acbaf3c3e6c8b4b6bcb8fad7c5a1b0cedeb1a3d0dea1b1a1b0cedeb7a2c6b1a1b1b5c4d2feb2d8cecacce2a1a3b5b1c8bbd2b2d3d0d2bbd0a9b3d0c5b5d3d0ceacd0deb5c4cbaebbf5beadcffac9cca3acc8b4d2b2cdacd1f9c3bbd3d0d5fdb9e6c5e4bcfeb5c4b1a3d6a4a3acc3bbd3d0d5fdb9e6ceacd0deb5c4c7feb5c0a1a3d0a1c3abb2a1bfaad2bbb4cebfc7ceacd0ded2bbcfc2c3bbd3d0313030d4aacac7c4c3b2bbcfc2c0b4b5c4a1a3bfb4b5bdd5e2c0efa3acc4fabbb9d4b8d2e2b5a3d5e2b8f6b2eebcdbb5c4b7e7cfd5c3b4a3bf0d0aa1a1a1a1c1edcde2a3acb4d35b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5dd6b1cffab2bfd7dcbce0b4a6c1cbbde2b5bda3acd3c9d3dab2c9b9bac7feb5c0c9cfb5cdb3c9b1bea1a2b8dfd0a7a1a2bfecbdddb5c4ccd8b5e3a3acd2d7cffacdf8d7f7ceaad2bbbcd2cad6bbfa423243d6b1cffacdf8d5bea3acd4dab8f7b4f3c0e0c6b7c5c6cad6bbfabcdbb8f1c9cfb6bcd3d0d7c5c7bfb4f3b5c4d3c5cac6a1a3d3c9b4cbcadcd2e6d3dacffbb7d1d5dfb5c4cac7a3accad6bbfad0d0bbf5d3ebcbaebbf5bcdbb8f1b2eed2ecc3f7cfd4cbf5d0a1a3acb6f8d6cac1bfb2eeb1f0c8b4d4dad6f0b2bdd4f6b4f3a1a30d0a0d0a5b625dd2b5c4dad0d0bcd2b6d4d3dacbaebbf5b5c4c4dac4bbc6d8b9e25b2f625d0d0aa1a1a1a1d4dab2c9b7c3d6d0b6d4d3dac4bfc7b0cbaebbf5cad6bbfad3d0c1cbb8fcbdf8d2bbb2bdb5c4c1cbbde2a3accbaebbf5cad0b3a1cfd6d4dad6aecbf9d2d4c4dcb9bbb5c3d2d4b3a4c6dad4cbd7aaa3accac7d2f2ceaad3d0a1b0c7b1b9e6d4f2a1b1b5c4b4e6d4daa3acc3bfb8f6c9ccbcd2c3c7b6bcd4dad7f1d1add5e2b8f6a1b0c7b1b9e6d4f2a1b1a1a320cbaebbf5cad6bbfab4f3b6bcbbe1d3c3a1b0b8dbd0d0a1b1a1b0c5b7d0d0a1b1a1b0d1c7ccabb0e6a1b1d5e2d0a9c3fbb4cac0b4d1dacaced7dfcbbdc8ebbeb3b5c4c9edb7dda1a30d0aa1a1a1a1b2c9b7c3d6d05b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5d43454fd1a6bfa1cfc8c9fad2b2c3e8caf6c1cbd5e2d1f9d2bbb8f6b4cad3efa1b0cbaebbf5d6d0b5c4d0d0bbf5a1b1a1a320cfd6d4dad3d0cfe0b5b1d2bbb2bfb7d6c9ccbcd2c9f9b3c6d7d4bcbacbf9b3f6cadbb5c4cad6bbfaceaab8dbd0d0bbf5a3accac7cbf9d3d0cbaebbf5d6d0d7eebac3b5c4d2bbd6d6a1a3a1b0b6d4d3dab8dbd0d0a3acd0edb6e0cffbb7d1d5dfb6bccac7c3a4c4bfd7b7c5f5a3aca1b1d1a6bfa1b1edcabec1cbd7d4bcbab5c4bfb4b7a8a3aca1b0cffbb7d1d5dfd2b2cdeac8abc3bbd3d0bfbcc2c7b5bdcba2bbfaa1a2b8c4bcf2cce5cfb5cdb3a1a2ceded4adb3a7cadbbaf3cbf9b4f8c0b4b5c4c7b1d4dab7e7cfd5a1a3a1b1cfebd2aacad6bbfac4dcb9bbcfedcadcb5bdd7a8d2b5a1a2d5fdb9e6b5c4c8abb9fac1aab1a3b7fecef1a3acc4c7c3b4b9bac2f2cab1cbf7d2aad5fdb9e6c9ccd2b5b7a2c6b1bacdd4adb3a7b1a3d0debfa8cac7b1d8b2bbbfc9c9d9b5c4a1a30d0a200d0a5b625dcab2c3b4c7feb5c0bfc9d2d4c2f2b5bdb7c5d0c4cad6bbfaa3bf5b2f625d0d0aa1a1a1a1bfb4c1cbd2d4c9cfb5c4b1a8b5c0d6aebaf3a3acb7eec8b0b8f7cebbb6d4d3dacbaebbf5cad6bbfabbb9cac7beb4b6f8d4b6d6aea1a3b5b1c4fad7bcb1b8d1a1b9bacad6bbfacab1a3accad7cfc8becdd2aac8b7b6a8c9ccbcd2cac7b7f1c4dcbfaab3f6d5fdb9e6b7a2c6b1a3acc2f4b3f6b5c4cad6bbfad3d0c3bbd3d0b1a3d0debfa8a1a3c8e7b9fbcfebd2aad0d4bcdbb1c8bce6b9cba3acc4c7becdcdc6bcf6c4faccf4d1a1d2bbbcd2d0c5d3febfc9bcd1b5c4423243cdf8d5bea1a30d0aa1a1a1a15b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5dd7f7ceaad2bbbcd2d3eb5043484f4d45bacfd7f7b6e0c4eab5c4d0d0bbf5cad6bbfabeadcffac9cca3acb6e0c4eac0b4d2bbd6b1b4f2b3f6a1b0caa1c8a5cbf9d3d0d6d0bce4bbb7bddaa3acbcdbb8f1d4b6b1c8c2f4b3a1b5cda1b1b5c4bfdabac5a3acd5fdb9e6a1a2b1ead7bcbbafb5c4c9ccc6b7a3acb8fccce5ccf9b5c4b7fecef1a3acd3c3ceefb3accbf9d6b5b5c4d3c5d6cad6b1cffacce5d1e9b8f8d3e8b9cbbfcdd7eec2fad2e2b5c4bbd8b1a8a1a3d4dab4cbb4ceb2c9b7c3d6d0d2b2b7a2cfd6a3ac5b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5dbfcdb7feb5e7bbb0cac7b7c7b3a3c3a6c2b5a3acd4dab2c9b7c3d6d0bbb9b7a2cfd6bfcdb7fe31bac5cfdfc9dbd0a1bde3a3accbfdb3fdc1cbc3a6c2b5bdd3ccfdcad6bbfab6a9b9bab5e7bbb0d6aecde2a3accdaccab1d2b2c4cdd0c4bde2b4f0b8f7d6d6b9bac2f2c7b0b6d4d0d0a1a2cbaebbf5cad6bbfab5c4d7c9d1afcecacce2a1a3cbfdb1edcabea3bac3bfccecb5c4b5e7bbb0bfcdb7feb6bccac7badcc3a6a3acd3d0cab1baf2cee7b7b9d2aab5bdcfc2cee7b3d4a3accdedb7b9cab1bbb9d4dabcd3b0e0a1a3b2bbb9fdc5acc1a6c8c3d3c3bba7bbf1b5c3d7eed3e4d4c3b5c4b9baceefbeadc0faa3acd2b2d5fdcac7c9dbd0a1bde3bacd5b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5dc8abcce5d4b1b9a4b5c4b7dcb6b7c4bfb1eaa1a30d0a0d0aa1a1a1a1d4dab2c9b7c3bde1caf8cab1a3ac5b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5d43454fd1a6bfa1cfc8c9fad2b2d4d9d2bbb4ceb1edb4efc1cb5b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5dbce1b3d6d0d0bbf5beadd3aab5c4b2bbb1e4d0c5c4eea1a3d4dacad6bbfad0d0d2b5b9a4d7f7d2d1b4ef3132c4ead6aebec3b5c4cbfba3acc8cfb6a8a1b0d7f0d6d8bfcdbba7cce5d1e9a3acb9d8d7a2bfcdbba7d0e8c7f3a3acbeabd0c4bfcdbba7b7fecef1a1b1cac75b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5db5c4b7fecef1c4bfb1eaa3acd2b2cac75b75726c3d687474703a2f2f7777772e3531376573686f702e636f6d2f6573686f702f696e646578352e7068703f453554555f474b4c73504e2e68746d6c5d5b625d5b73697a653d365d5b636f6c6f723d7265645dd2d7cffacdf85b2f636f6c6f725d5b2f73697a655d5b2f625d5b2f75726c5db4b4d4ecd0c2d2bbb4fad6b1cffac6f3d2b5bacbd0c4bebad5f9c1a6b5c4c9fab4e6d6aeb1bea1a3cdaccab1a3accbfbd2b2cfe0d0c5cbe6d7c53347b5c4d6f0b2bdc1d9bdfca3acd5fdb9e6b5c4d0d0bbf5cad6bbfad5bcbeddd5fbb8f6d2c6b6afcda8d1b6cad0b3a1bdabcac7d6b8c8d5bfc9b4fda3a1,0x3231382e37392e3131372e32,'0','0','0','0','0','-1','0','0','0','0','0')
Error: Duplicate entry '47499' for key 1
Errno.: 1062
回复

使用道具 举报

白乐天 发表于 2008-4-11 21:49:34 | 显示全部楼层
不会,删的是重复数据
回复

使用道具 举报

hbsb2007 发表于 2008-4-11 23:57:26 | 显示全部楼层
/..
回复

使用道具 举报

 楼主| `某房某床某人` 发表于 2008-4-12 19:14:43 | 显示全部楼层
我发现一个问题,出现错误我改过后,刷新一下恢复页面又出现错误,但是我从新导入就没错误了。。。昨天16卷出现错误,改了后还是错误,今天上线后我重新导入的,一直到25卷才有错误。。
回复

使用道具 举报

 楼主| `某房某床某人` 发表于 2008-4-12 21:21:22 | 显示全部楼层
老大,还有其他方法吗?今天的25卷数据文件中,从开头都是提示重复,我删了第一个就提示第二个。。我今天删的有几十条,删一条重新上传一次,好累。。。
请问在数据文件中怎么才能看出这条数据是重复的?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-12-25 12:32 , Processed in 0.023627 second(s), 3 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表