Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 What is the method of transfer Database: MySql

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
top Posted - 18 November 2011 : 18:32:26
What is the mode of transmission of Database: MySql

I am having a very big problem in large-scale transfer of records

strConnString1 ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=0000000; DATABASE=000000; USER=0000000; PASSWORD= 000000; OPTION=16387;"
strConnString2 ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=000; PORT=3306; DATABASE=000; USER=000; PASSWORD=000; OPTION=16387;"


set Conn1=server.createObject("ADODB.connection")
Conn1.open strConnString1

strSql1="SELECT TOPIC_ID from forum_topics order by TOPIC_ID LIMIT 11000,1000"
set rs1 = Conn1.Execute (strSql1)

Attempted transfer of subjects and I was there a line in the transfer of records
Is there a way of transfer of each section and pages of members and the responses, voting records, calendar

Thank you for your help in advance
8   L A T E S T    R E P L I E S    (Newest First)
top Posted - 22 December 2011 : 02:54:49
Is it possible to get the correct code to bar news from left to right with a way to block a specific department or category
ruirib Posted - 16 December 2011 : 07:04:36
You are using conn_active and you never assigned it a value.
top Posted - 15 December 2011 : 20:03:39
I did not know how had value to conn_active
ruirib Posted - 15 December 2011 : 18:21:35
Did you set a value to conn_active?
top Posted - 14 December 2011 : 22:41:04
Thank you to apologize for the delay but I know the Egyptian revolution thing for taking all the time in Mrklh election issue has been resolved and I me another question

I'm doing and I Newsflash: there is a mistake


	 <%
dim strConnString_active
dim conn_active
dim rs
dim topic_cnt,strSql

strConnString_active ="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=0000000; DATABASE=00000000; USER=000000; PASSWORD=000000; OPTION=16387;"


  set rs = Server.CreateObject("ADODB.Recordset")
		  
   strSql="SELECT FORUM_TOPICS.CAT_ID,FORUM_TOPICS.FORUM_ID,FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT FROM FORUM_TOPICS ORDER BY FORUM_TOPICS.T_LAST_POST DESC LIMIT 20"
  ' set rs = Conn.Execute (strSql)
  rs.cachesize = 20
  rs.open strSql, conn_active, adOpenForwardOnly, adLockReadOnly, adCmdText

topic_cnt=1

%><marquee direction="right" scrolldelay="150"> 
      <%	do until rs.EOF
       Response.Write "<a href='/forum/topic.asp?TOPIC_ID=" &  rs("TOPIC_ID") &  "' target='_blank' class='linkmid'> " & rs("T_SUBJECT") & "</a>" 
%>
      <font face=Webdings color=FF0000><</font> 
      <%		rs.MoveNext 
topic_cnt=topic_cnt + 1
	if  topic_cnt = 15 then 
	  exit Do
   end if
	loop 
	
	rs.Close
	set rs = nothing
	conn_active.close   
Set conn_active = Nothing
	 %>


ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

line 19
rs.open strSql, conn_active, adOpenForwardOnly, adLockReadOnly, adCmdText
ruirib Posted - 22 November 2011 : 04:58:58
My advice again is to download and install the free version of SQLYog. Use it to backup the "old" database and then use the backup to restore to the new one. When you backup, select the options to include DROP statements.
top Posted - 19 November 2011 : 19:47:45
There was an error when importing records text because the markup is there more than 5000 errors in the Register of mis threads forum_a_topics
forum_a_reply
forum_topics
forum_reply
forum_members
ruirib Posted - 19 November 2011 : 19:07:28
Use a tool such as SQLYog or use phpadmin to export the data as a text dump and then import it to the new database.

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07