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

 找回密码
 立即注册
搜索

[疑问] 请教数据库问题

[复制链接]
阿代 发表于 2007-4-14 22:14:34 | 显示全部楼层 |阅读模式
请教一下,我用以前备份的数据恢复论坛时出现以下提示。不知道该怎么弄,那位指教一下!!!

备份的数据一共有两个分卷,我试过如果只恢复第一分卷的话就不会出现以下提示。如果两个分卷一起到入就出现提示了。

我对数据库不太熟悉,想请问一下如果只用第一分卷恢复不导入第2分卷会出现什么问题吗?


Discuz! info: MySQL Query Error

User: 酷酷
Time: 2007-4-14 9:55pm
Script: /admincp.php

SQL: SELECT uid, username FROM supe_userspaces WHERE islock=0 ORDER BY lastpost DESC LIMIT 100
Error: Table 'a12261756296.supe_userspaces' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.
回复

使用道具 举报

快乐崇拜 发表于 2007-4-15 01:16:04 | 显示全部楼层
请确认是完全备份???
回复

使用道具 举报

织羽 发表于 2007-4-15 11:07:15 | 显示全部楼层
Discuz! info: MySQL Query Error

User: admin
Time: 2007-4-15 11:00am
Script: /bbs/admincp.php

SQL: CREATE TABLE [Table]albumcla ( id int(10) unsigned NOT NULL auto_increment, parentid int(10) unsigned NOT NULL default '0', claname char(30) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', photoname char(100) NOT NULL default '', createtime int(10) unsigned NOT NULL default '0', updatetime int(10) unsigned NOT NULL default '0', sortid int(10) unsigned NOT NULL default '0', clatype tinyint(1) unsigned NOT NULL default '0', photocount smallint(5) unsigned NOT NULL default '0', viewtype tinyint(1) unsigned NOT NULL default '1', passwd char(16) NOT NULL default '111111', clicktimes mediumint(8) unsigned NOT NULL default '0', describe char(50) NOT NULL default '', KEY id (id), KEY uid (uid), KEY parentid (parentid), KEY viewtype (viewtype), KEY photocount (photocount), KEY sortid (sortid)) TYPE=MyISAM AUTO_INCREMENT=21
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'describe char(50) NOT NULL default '', KEY id (id), KEY uid (
Errno.: 1064

Similar error report has beed dispatched to administrator before.
回复

使用道具 举报

织羽 发表于 2007-4-15 13:17:44 | 显示全部楼层
以上是导入数据的问题请大家帮帮忙
回复

使用道具 举报

whiov 发表于 2007-4-18 01:14:17 | 显示全部楼层
如果没有备份,那什么办??
回复

使用道具 举报

紫琼 发表于 2007-4-18 10:25:54 | 显示全部楼层
数据的备份和恢复可以参考下面的教程:
论坛搬家视频教程:https://discuz.dismall.com/viewthread.php?tid=384782
论坛后台备份完全规范:https://discuz.dismall.com/thread-505428-1-1.html
SupeSite 5.0 搬家图文教程:https://discuz.dismall.com/thread-484051-1-1.html

如果没有了备份数据,出了严重的问题就没有办法恢复了,所以进行任何操作前请先备份数据,否则到时候出问题了就后悔晚已
回复

使用道具 举报

faerieisland 发表于 2007-5-1 16:38:17 | 显示全部楼层
跟三楼一样的问题……

Discuz! info: MySQL Query Error

User: faerieisland
Time: 2007-5-1 4:05pm
Script: /BBS/admincp.php

SQL: CREATE TABLE [Table]albumcla ( id int(10) unsigned NOT NULL auto_increment, parentid int(10) unsigned NOT NULL default '0', claname char(30) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', photoname char(100) NOT NULL default '', createtime int(10) unsigned NOT NULL default '0', updatetime int(10) unsigned NOT NULL default '0', sortid int(10) unsigned NOT NULL default '0', clatype tinyint(1) unsigned NOT NULL default '0', photocount smallint(5) unsigned NOT NULL default '0', viewtype tinyint(1) unsigned NOT NULL default '1', passwd char(16) NOT NULL default '111111', clicktimes mediumint(8) unsigned NOT NULL default '0', describe char(50) NOT NULL default '', KEY id (id), KEY uid (uid), KEY parentid (parentid), KEY viewtype (viewtype), KEY photocount (photocount), KEY sortid (sortid)) TYPE=MyISAM AUTO_INCREMENT=1
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'describe char(50) NOT NULL default '', KEY id (id), KEY uid (
Errno.: 1064
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-9-12 09:08 , Processed in 0.122041 second(s), 14 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

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