查看完整版本: Z-BLOG转mysql(未测试)

Z-BLOG转mysql(未测试)

见过高人密陀僧 转mssql了([url]http://bbs.rainbowsoft.org/viewthread.php?tid=11771&extra=page%3D1).[/url]

但是mssql比较难找,价格也贵.
空间送了mysql的数据库,而且公司的服务器也有.
哪位高人能转mysql说一下.嘿嘿.我免费提供mysql空间.

[[i] 本帖最后由 Zx.MYS 于 2007-4-18 18:10 编辑 [/i]]

ASP空间提供MYSQL？还有这种事？哪有？我要？给我一个我帮你改。

呵呵.我那空间是php.asp.jsp都可以的.
买了空间送了50m的mysql数据库.

送50M的MYSQL，那是WINDOWS主机还是FREEBSD还是LINUX？

win2003主机.
linux的主机不能运行access数据库吖:(

公司就是换了linux服务器.

那服务器上要安装MYSQL ODBD

下载在[url]www.mysql.com[/url]上有。

应该有的.

把密陀僧修改方案里的
[code]
  Set objConn = Server.CreateObject("ADODB.Connection")
  'objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDbPath
  connstr="Provider=SqlOLEDB;Data Source=(local);initial catalog=database;user ID=username;password=password;"
  objConn.Open connstr
  OpenConnect=True
[/code]
改为
[code]
connstr = "driver={myodbd driver};server=localhost;uid=username;pwd=password;database=database"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open connstr
  OpenConnect=True
[/code]
其他的仍就照他的改法改

你先试试，不行再找我好了。

[[i] 本帖最后由 Zx.MYS 于 2007-5-21 18:08 编辑 [/i]]

哇咔咔.好.我这两天找时间试一下先.
;P .
anyway.先谢谢mys.

其实国外有很多空间都是ASP+MySQL的, 但国内的还真就没见到.

国内的全能空间一般就支持到 php ，的确没见过连mysql也支持的……

ASP+MYSQL我还真没见过

几年前我改过动网论坛，在Linux上破的，效率提升N倍，论坛的运行时间显示紧紧只有40-50毫秒。

有高人转过MYSQL吗？有的话请问按照上面的方法运行不会出错吧？

出错了来汇报~我给你排查~

请问大家转换成功了吗／:)

有可能您发现了 SQL 分析器的臭虫。请仔细检查您的查询，包括引号是否正确及是否匹配。其它可能的失败原因可能由于您上传了超过引用文本区域外的二进制数据。您还可以在 MySQL 命令行界面试一下您的查询。如果可能的话，以下会列出 MySQL 服务器的错误输出，这可能对您解决问题有一定的帮助作用。如果您仍然有问题，或者命令行界面执行成功而分析器出错，请将您的 SQL 查询缩减到导致问题的某一条语句，然后和下面剪切区中的数据一起提交一个臭虫报告：
----开始剪切----
eNrlWW1z2kYQvq/Vr7gPmWnSwRTh2HU10w9EUR1aWWBe3GY8Hg8vMqYBTEAkdn580+f2OCSBbQSW
hJiOkLiTdvfZ3dvbPZ2sWq1SM7ipc7PIbcsxeIHrXNd/OTrR6g08+a5p5kXd4K/KXYNPPw/GrcnU
neQH/XZ+fDvOfeHF/OExLxYKRz8XTvBD0ygWDV3nA3f4K7fux/yVdvZQP7cN/jav5/WTg8FdT2vW
a7xSz/HSqeU0cvzCAtRf/REvW/w4X9CqZyUDko/zbw/Gg0Ot+qEqSHKVuhACMdzuj2b3ml1yTg3+
7fZg5t0cQGEB8v3fPrthnLnsnvXZlHk4OXuNq8sGODu4w9lPOG/YhN2xIVpd1kYrD5oHnHfo/TOn
FLxf2S16E5wcEru4/oYzSHVN918zh/3ILufSriDvEq0B2j1QlCDBA12HtLgC5RtIabERSaywd+wP
ZjGTNViV1dCvoldD7yPkCuk5UAn5ZejUJGsmeNoiBHcuTeilo6Xh6JJ1Y9zxFlQ8snZCwim00OZH
Nn1qwjIP9D30J8DJmldX9dsXvwqsIThG4MieV8Pa7Y9PZ6SxkJVFnwa12w+f/gnaB8gSs6ubOZ8u
a7cfPj0D7RD9LEZpWLf98Kewvpc5Tyqt9sWHE+jbYZ/gNfmfPX+uargfvm3CRhvtVgYzaFi3ZX+K
w4Q2FlavDVw5riVobFM76kpXjIGQ9AOoFE2Zvacnl6CTawxO9yzY2kBL2C/4dLJfJysdaNag/yY0
sNHKrchV68HH5D/HV0Jt9jDaopJsymsD7wvF2CZcTSApjhH4W+h3oEGLMq+wvciOcAjLTVgu5KhR
MEEnUFyKh2uKHJOsL5Mt9TXYDXB7i9FJH79MHppQ7Eh8j2at9FrcaGLlJRHUuCSNWAbHc57VE/Jr
Ff8i74nxHS5GtzufE17g7jp/idW/gzkxhLxNovoCdC7y5ja8qxl+Oymy7u4mrqeQJLKvxG/TPLt6
NHcJ3jdUARyiFVhlrL9K+P9IPEKnvykbirun6F0/Sb2cuTfP2qtv0sG83Zk/jT9z+5IdtIZrctIR
K8Q6cj56hd4h3DnSumgL+mM5l6UTc74G/pvl05qvi7Y44ie8ZxCOHvksuboftWb7mmxT8R/nfn7c
445XpUF6Vc3HtHBtQcYg5Tmq8D9QywWnyPFu6jNO6fGyOhucDemuE4Lx20sscrJX2cI7b8uZSTxL
oq75kqup5wiJnOQoP4ZXA99NoIY+PTOTsnibmZm1eF3e1QzG6yd6Fn+0KrlR1mDxZ1bfqjTeCxVa
E/R2KpZmLcLCu7zB+BrSk/jjS8ndbK9EcUWLynhzisIWa40pjuB8fEqHQ2iRhA51mgUS2SNJDxE9
t5sVm0I/A4WzE+RzHLvA3e0K1Z9lLaqCF7QP3l/U/6grVD/uPOKYRdyD8eeMrMI25ZvteNX75Gbc
6VQQHy3d9bvCjeONP+2a4+/L+dXGo3vxVxsldzerGd+qNGJRoVXJJrnaj7qfoXjTWwmtYm+276a4
9nMGrH7BDM+GdgZ2yKQWu4mIduRvUzrqdyEB9Hdzf6W5dpDIFjJDh+bBOOH3dYn3sj0sFavp1j+J
+n/auwp/nw9mixlo4s8WUuo2e+OS83d613Dh1T77toiqTTh38RVIavCyGSFlnOP/jujTzZ0S/T2w
v4JbfjeN52vQfwpKPEE=
----结束剪切----
----开始原文----

ERROR: C1 C2 LEN: 0 1 11758
STR: ?VS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 4.1.18-log
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.6.4-pl3
PHP VER,OS: 4.4.1 Linux
LANG: zh-utf-8
SQL: ?f exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Article]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Article]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Category]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Comment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Comment]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Counter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Counter]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Keyword]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Keyword]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Member]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Member]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Tag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_Tag]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_TrackBack]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_TrackBack]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_UpLoad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[blog_UpLoad]

GO





CREATE TABLE [dbo].[blog_Article] (

        [log_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [log_CateID] [int] NULL ,

        [log_AuthorID] [int] NULL ,

        [log_Level] [int] NULL ,

        [log_Url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [log_Title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [log_Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [log_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [log_IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

        [log_PostTime] [datetime] NULL ,

        [log_CommNums] [int] NULL ,

        [log_ViewNums] [int] NULL ,

        [log_TrackBackNums] [int] NULL ,

        [log_Tag] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [log_IsTop] [bit] NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_Category] (

        [cate_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [cate_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [cate_Order] [int] NULL ,

        [cate_Intro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [cate_Count] [int] NULL

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_Comment] (

        [comm_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [log_ID] [int] NULL ,

        [comm_AuthorID] [int] NULL ,

        [comm_Author] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

        [comm_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [comm_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [comm_HomePage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [comm_PostTime] [datetime] NULL ,

        [comm_IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

        [comm_Agent] [ntext] COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_Counter] (

        [coun_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [coun_IP] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

        [coun_Agent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [coun_Refer] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,

        [coun_PostTime] [datetime] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_Keyword] (

        [key_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [key_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [key_Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [key_URL] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_Member] (

        [mem_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [mem_Level] [int] NULL ,

        [mem_Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_Password] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_Sex] [tinyint] NULL ,

        [mem_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_MSN] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_QQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_HomePage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_LastVisit] [datetime] NULL ,

        [mem_Status] [int] NULL ,

        [mem_PostLogs] [int] NULL ,

        [mem_PostComms] [int] NULL ,

        [mem_Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

        [mem_Count] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_Tag] (

        [tag_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [tag_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [tag_Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [tag_ParentID] [int] NULL ,

        [tag_URL] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [tag_Order] [int] NULL ,

        [tag_Count] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_TrackBack] (

        [tb_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [log_ID] [int] NULL ,

        [tb_URL] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [tb_Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,

        [tb_Blog] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [tb_Excerpt] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

        [tb_PostTime] [datetime] NULL ,

        [tb_IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

        [tb_Agent] [ntext] COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[blog_UpLoad] (

        [ul_ID] [int] IDENTITY (1, 1) NOT NULL ,

        [ul_AuthorID] [int] NULL ,

        [ul_FileSize] [int] NULL ,

        [ul_FileName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

        [ul_PostTime] [datetime] NULL ,

        [ul_Quote] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

        [ul_DownNum] [int] NULL

) ON [PRIMARY]

GO

我的空间是ASP+PHP+ASP.NET
MYSQL+MSSQL
哈哈,支持的

[quote]原帖由 [i]Zx.MYS[/i] 于 2007-4-13 21:38 发表 [url=http://bbs.rainbowsoft.org/redirect.php?goto=findpost&pid=23979&ptid=12609][img]http://bbs.rainbowsoft.org/images/common/back.gif[/img][/url]
把密陀僧修改方案里的
  Set objConn = Server.CreateObject("ADODB.Connection")
  'objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDbPath
  connstr="Provider=SqlOLEDB;Data Source=(local);initial catalog=database;user ID=username;password=password;"
  objConn.Open connstr
  OpenConnect=True

改为
connstr = "driver={myodbd driver};server=localhost;uid=username;pwd=password;database=database"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open connstr
  OpenConnect=True
[/quote]
使用odbd驱动？还是直接读mysql数据库里的数据？