API tools faq
paste
Advertisement
Guest User

master

a guest
May 30th, 2011
237
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.28 KB | None | 0 0
raw download clone embed print report
  1. 110530 14:34:59 558 Connect root@192.168.34.34 on forum
  2. 558 Query set autocommit=0
  3. 558 Query SELECT @@SQL_MODE
  4. 558 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
  5. 558 Query SET wait_timeout=10000
  6. 558 Query /*!40101 SET @@SQL_MODE := CONCAT(@@SQL_MODE, ",NO_AUTO_VALUE_ON_ZERO")*/
  7. 558 Query /*!50105 SET @@binlog_format="STATEMENT"*/
  8. 558 Query SHOW MASTER STATUS
  9. 558 Query SELECT VERSION()
  10. 558 Query SHOW GRANTS FOR CURRENT_USER()
  11. 558 Query SHOW PROCESSLIST
  12. 558 Query SHOW VARIABLES LIKE "port"
  13. 110530 14:35:00 559 Connect root@192.168.1.182 on forum
  14. 559 Query set autocommit=0
  15. 559 Query SELECT @@SQL_MODE
  16. 559 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
  17. 559 Query SET wait_timeout=10000
  18. 559 Query /*!40101 SET @@SQL_MODE := CONCAT(@@SQL_MODE, ",NO_AUTO_VALUE_ON_ZERO")*/
  19. 559 Query /*!50105 SET @@binlog_format="STATEMENT"*/
  20. 558 Query SELECT NOW()
  21. 558 Query USE `forum`
  22. 558 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := REPLACE(REPLACE(@@SQL_MODE, 'ANSI_QUOTES', ''), ',,', ','), @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
  23. 558 Query USE `forum`
  24. 558 Query SHOW CREATE TABLE `forum`.`user`
  25. 558 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
  26. 558 Query SHOW FULL COLUMNS FROM `forum`.`user`
  27. 558 Query DELETE FROM `forum`.`user` LIMIT 0
  28. 558 Query set autocommit=1
  29. 559 Query set autocommit=1
  30. 558 Query SELECT MIN(`userid`), MAX(`userid`) FROM `forum`.`user` FORCE INDEX (`PRIMARY`)
  31. 558 Query EXPLAIN SELECT * FROM `forum`.`user` FORCE INDEX (`PRIMARY`)
  32. 558 Query SELECT CRC32('test-string')
  33. 558 Query SELECT CRC32('a')
  34. 558 Query SELECT CRC32('a')
  35. 558 Query USE `forum`
  36. 558 Query SET @crc := "", @cnt := 0
  37. 558 Query UNLOCK TABLES
  38. 558 Query LOCK TABLES `forum`.`user` WRITE
  39. 559 Query SHOW MASTER STATUS
  40. 558 Query SELECT /*forum.user:1/1*/ 0 AS chunk_num, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`)) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `forum`.`user` FORCE INDEX (`PRIMARY`) WHERE (1=1)
  41. 558 Query SET @crc := "", @cnt := 0
  42. 558 Query SELECT /*rows in chunk*/ `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`, CRC32(CONCAT_WS('#', `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`)) AS __crc FROM `forum`.`user` FORCE INDEX (`PRIMARY`) WHERE (1=1) ORDER BY `userid`
  43. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='1' LIMIT 1
  44. 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('1', '6', '', '0', '*************', '**************', '2011-04-21', '**************', '0', '', '', '', '', '', '', '', '2', '2', 'Administrator', '0', '1303374600', '0', '1306748527', '1306750710', '0', '0', '0', '10', '1', '0', '0', '0', '0', '0', '0', '11552855', '', '0000-00-00', '-1', '1', '', '0', '0', '0', '0', '-1', '0', '0', '****************', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=************,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:**********/
  45. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='2' LIMIT 1
  46. 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('2', '6', '2,7', '2', '*******', '******************', '2011-04-21', '*********', '0', '', '', '', '', '', '', '', '1', '0', 'Junior Member', '0', '1303381080', '0', '1303381133', '1303381080', '0', '0', '0', '10', '5', '1', '0', '0', '0', '0', '0', '45108567', '', '0000-00-00', '-1', '-1', '192.168.1.110', '0', '1', '0', '0', '-1', '0', '0', '******************', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=*******,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:*********/
  47. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='3' LIMIT 1
  48. 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('3', '6', '2,7', '2', '******', '**************', '2011-05-07', '************', '0', '', '', '', '', '', '', '', '1', '0', 'Junior Member', '0', '1303390500', '0', '1306240249', '1306248240', '0', '0', '0', '10', '5', '1', '0', '0', '0', '0', '0', '45108439', '', '0000-00-00', '-1', '-1', '**************', '0', '1', '0', '0', '-1', '0', '0', '***********************', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=*********,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:*****************/
  49. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='4' LIMIT 1
  50. 110530 14:35:01 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('4', '6', '5,7', '6', '*********', '*********************', '2011-04-27', '**************', '0', '', '', '', '', '', '', '', '1', '0', '***************', '0', '1303892460', '-1', '1306751858', '1306758264', '1306751564', '0', '7', '10', '5', '0', '0', '0', '0', '0', '0', '45108311', '', '0000-00-00', '-1', '-1', '', '0', '0', '0', '0', '-1', '0', '0', '******************', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=***********,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:********/
  51. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='5' LIMIT 1
  52. 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('5', '6', '2,7', '0', '*********', '******************', '2011-04-27', '***************', '0', '', '', '', '', '', '', '', '1', '0', '******', '1', '1303892520', '-1', '1303892570', '1303892520', '0', '0', '0', '10', '5', '0', '0', '0', '0', '0', '0', '45108311', '', '0000-00-00', '-1', '-1', '', '0', '0', '0', '0', '-1', '0', '0', '*********************', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=*************,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:**************/
  53. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='6' LIMIT 1
  54. 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('6', '6', '2,5,7', '6', '************', '**********************', '2011-05-07', '***************', '0', '', '', '', '', '', '', '', '1', '0', 'Administrator', '0', '1304754600', '0', '1306493179', '1306501921', '0', '0', '0', '10', '5', '1', '0', '0', '0', '0', '0', '45108439', '', '0000-00-00', '-1', '-1', '10.99.99.18', '0', '1', '0', '0', '-1', '0', '0', '**************', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=**************,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:***************/
  55. 558 Query SELECT `userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread` FROM `forum`.`user` WHERE `userid`='7' LIMIT 1
  56. 558 Query REPLACE INTO `forum`.`user`(`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES ('7', '3', '', '0', '***********', '*******************', '2011-05-30', '*************', '0', '', '', '', '', '', '', '', '1', '0', 'Junior Member', '0', '1306758426', '0', '1306758426', '1306758426', '0', '0', '0', '10', '5', '1', '0', '0', '0', '0', '0', '45108311', '', '0000-00-00', '-1', '-1', '************', '0', '1', '0', '0', '-1', '0', '0', '********************', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '0') /*maatkit src_db:forum src_tbl:user src_dsn:D=forum,P=3306,h=********,t=user dst_db:forum dst_tbl:user dst_dsn:D=forum,h=localhost,t=user lock:1 transaction:0 changing_src:1 replicate:0 bidirectional:0 pid:21283 user:root host:************/
  57. 558 Query UNLOCK TABLES
  58. 558 Query SELECT NOW()
  59. 559 Quit
  60. 558 Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!