What is the method of transfer Database: MySql

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/70045?pagenum=1
05 November 2025, 01:59

Topic

top
What is the method of transfer Database: MySql
18 November 2011, 18:32


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

 

Replies ...

ruirib
19 November 2011, 19:07


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.
top
19 November 2011, 19:47


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
22 November 2011, 04: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
14 December 2011, 22:41


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

Code:

	 <%
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
15 December 2011, 18:21


Did you set a value to conn_active?
top
15 December 2011, 20:03


I did not know how had value to conn_active
ruirib
16 December 2011, 07:04


You are using conn_active and you never assigned it a value.
top
22 December 2011, 02:54


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
© 2000-2021 Snitz™ Communications