Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 What is the method of transfer Database: MySql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

top
Junior Member

150 Posts

Posted - 18 November 2011 :  18:32:26  Show Profile  Reply with Quote
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

Edited by - top on 18 November 2011 18:38:29

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 November 2011 :  19:07:28  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

top
Junior Member

150 Posts

Posted - 19 November 2011 :  19:47:45  Show Profile  Reply with Quote
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
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 22 November 2011 :  04:58:58  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

top
Junior Member

150 Posts

Posted - 14 December 2011 :  22:41:04  Show Profile  Reply with Quote
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
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 15 December 2011 :  18:21:35  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Did you set a value to conn_active?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

top
Junior Member

150 Posts

Posted - 15 December 2011 :  20:03:39  Show Profile  Reply with Quote
I did not know how had value to conn_active
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 December 2011 :  07:04:36  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
You are using conn_active and you never assigned it a value.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

top
Junior Member

150 Posts

Posted - 22 December 2011 :  02:54:49  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000 Version 3.4.07