|
查看: 1161|回复: 4
|
[求助]還原DATABASE的問題
[复制链接]
|
|
|
SQL Error : 1062 Duplicate entry '1' for key 1
INSERT INTO phpbb_banlist (ban_id, ban_userid, ban_ip, ban_email) VALUES('1', '0', '4136bc86', NULL)
Line : 980
File : admin_db_utilities.php
請問是什麽問題？
Warning: filesize(): Stat failed for phpbb_db_backup[1].sql (errno=2 - No such file or directory) in /home/bhl2138/public_html/game/restore_dump.php on line 48
Warning: fopen(phpbb_db_backup[1].sql): failed to open stream: No such file or directory in /home/bhl2138/public_html/game/restore_dump.php on line 55
Warning: fseek(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 69
Warning: feof(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 71
Warning: fread(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 75
Warning: feof(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 90
Warning: fread(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 75
Warning: feof(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 90
Warning: fread(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 75
Warning: feof(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 90
Warning: fread(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 75
Warning: feof(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 90
Warning: fread(): supplied argument is not a valid stream resource in /home/bhl2138/public_html/game/restore_dump.php on line 75
用RESTORE_DUMP.PHP
結果出現這個
我怎的不知道還可以怎樣
資料完了 ........... |
|
|
|
|
|
|
|
|
|
|
|
发表于 10-7-2005 11:44 PM
|
显示全部楼层
资料应该还有在，
需要检查 duplicate 的纪录，
如果你的 .sql file 太大， phpMyAdmin 是无法 restore 的，需要用 console. |
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 11-7-2005 04:57 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
发表于 11-7-2005 10:00 PM
|
显示全部楼层
原帖由 tn728202 于 11-7-2005 04:57 PM 发表
什麽是console
那裏可以下載
使用的方法？
console 也可以是 dos prompt 中的：
C:\Program Files\MySQL\MySQL Server 4.1\bin>
mysql -u root -p databasename < restore.sql
然后输入 root 的密码。
你可以用 mysql --help 来看其他的功能。 |
|
|
|
|
|
|
|
|
|
|
|
发表于 13-7-2005 07:02 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
| |
 本周最热论坛帖子
|
变色卡
千斤顶
1825 
50
