Many-much-thanks to Zejan
From my brain
Conversation started: (12/1/2006 9:10:50 AM)
Me (12/1/2006 9:11:08 AM) btw: i might have to upgrade
Zejan (12/1/2006 9:11:14 AM) what for?
Me (12/1/2006 9:11:56 AM) http://faq.1and1.com//scripting_languages_supported/ssh_secure_shell/2.html
Zejan (12/1/2006 9:15:59 AM) whatchoo need that for?
Me (12/1/2006 9:16:16 AM) don't have any upload tools otherwise
Me (12/1/2006 9:16:26 AM) not that i saw
Zejan (12/1/2006 9:16:31 AM) er? You mean for the sql?
Me (12/1/2006 9:16:36 AM) yeah
Zejan (12/1/2006 9:16:45 AM) I can make with the working around
Zejan (12/1/2006 9:16:49 AM) gimmy a sec
Zejan (12/1/2006 9:19:16 AM) http://as400team.pacerglobal.com/phpMyAdmin-2.9.1.1-english.zip
Zejan (12/1/2006 9:19:50 AM) install that. Then you can upload... and even if you can't you can cut/paste queries
Me (12/1/2006 9:24:10 AM) n00bn3ss: install? local PC or on webspace?
Zejan (12/1/2006 9:24:19 AM) web space :)
Zejan (12/1/2006 9:24:28 AM) j00 Unca' Zej to do it?
Zejan (12/1/2006 9:24:41 AM) er.. j00 *want* Unca' Zej to do it....
Me (12/1/2006 9:25:06 AM) just plunk it into a folder right?
Zejan (12/1/2006 9:25:11 AM) dunno
Zejan (12/1/2006 9:25:19 AM) gimmy a sec
Me (12/1/2006 9:25:31 AM) there's a phpMyAdmin built into their site...
Zejan (12/1/2006 9:25:38 AM) eh?
Zejan (12/1/2006 9:25:47 AM) And it won't let you upload?
Me (12/1/2006 9:26:12 AM) didn't like me...lemme try it again...just a sec
Zejan (12/1/2006 9:26:44 AM) where do you see phpmyadmin? I don't have it...
Me (12/1/2006 9:27:16 AM) which package do you have?
Zejan (12/1/2006 9:27:58 AM) Bidness
Me (12/1/2006 9:28:34 AM) go to "Websites & Applications" and then "MySQL Adminstration"
Me (12/1/2006 9:29:02 AM) where your dbs are listed (once you set them up), you get a phpMyAdmin button
Zejan (12/1/2006 9:29:37 AM) Ahh...
Zejan (12/1/2006 9:31:17 AM) You made your previous backup with phpmyadmin right?
Me (12/1/2006 9:31:40 AM) yup
Zejan (12/1/2006 9:32:02 AM) I don't have the phpmyadmin button... it just says "setup started"
Me (12/1/2006 9:32:11 AM) did you just create it now?
Zejan (12/1/2006 9:32:16 AM) yup
Me (12/1/2006 9:32:25 AM) takes a few minutes
Me (12/1/2006 9:32:33 AM) i think it was up in about 15 mins for me
Zejan (12/1/2006 9:32:38 AM) damn
Me (12/1/2006 9:34:27 AM) uploading...
Zejan (12/1/2006 9:35:25 AM) /me crosses appendages
Me (12/1/2006 9:36:51 AM) emailz
Me (12/1/2006 9:36:59 AM) boob
Me (12/1/2006 9:37:01 AM) boom
Me (12/1/2006 9:37:02 AM) rofl
Zejan (12/1/2006 9:37:59 AM) I don't see ar_text mediumblob
Zejan (12/1/2006 9:38:51 AM) oh!
Zejan (12/1/2006 9:38:53 AM) I get it!
Zejan (12/1/2006 9:39:35 AM) Cut/paste just that query. Remove COLLATE latin1_bin from all lines. It'll work.
Me (12/1/2006 9:40:32 AM) the full dump file is 10 MB...sheesh
Zejan (12/1/2006 9:40:46 AM) Yeah, that's why I do my backups in small groups :)
Me (12/1/2006 9:41:40 AM) so, remove that from ANY line anywhere in the file?
Zejan (12/1/2006 9:41:53 AM) well... just try one query first
Me (12/1/2006 9:42:27 AM) okies...cuz it's in there A LOT
Zejan (12/1/2006 9:42:43 AM) Well, if it does work, then you'll have to do that for all of 'em
Zejan (12/1/2006 9:43:14 AM) j00 R doofus
Zejan (12/1/2006 9:43:23 AM) Did you see the "(Max: 2,048KB)" for the upload?
Me (12/1/2006 9:44:00 AM) yeah
Me (12/1/2006 9:44:16 AM) the zip is 1.5 :)
Me (12/1/2006 9:44:33 AM) so, split the dump into separate file then?
Zejan (12/1/2006 9:44:48 AM) Well, try the first thing I said with the collate...
Zejan (12/1/2006 9:45:09 AM) Smokle
Me (12/1/2006 9:45:13 AM) There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
BEGIN CUT----
Me (12/1/2006 9:45:20 AM) okay...i smoke
Me (12/1/2006 10:07:11 AM) i dumped you
Zejan (12/1/2006 10:10:26 AM)
- CREATE TABLE `archive` (
`ar_namespace` int( 11 ) NOT NULL default '0', `ar_title` varchar( 255 ) CHARACTER SET latin1 NOT NULL default , `ar_text` mediumblob NOT NULL , `ar_comment` tinyblob NOT NULL , `ar_user` int( 5 ) unsigned NOT NULL default '0', `ar_user_text` varchar( 255 ) CHARACTER SET latin1 NOT NULL default , `ar_timestamp` varchar( 14 ) CHARACTER SET latin1 NOT NULL default , `ar_minor_edit` tinyint( 1 ) NOT NULL default '0', `ar_flags` tinyblob NOT NULL , `ar_rev_id` int( 8 ) unsigned default NULL , `ar_text_id` int( 8 ) unsigned default NULL , KEY `name_title_timestamp` ( `ar_namespace` , `ar_title` , `ar_timestamp` ) )
Zejan (12/1/2006 10:10:28 AM) That worked
Zejan (12/1/2006 10:10:48 AM) I fix and send back.
Zejan (12/1/2006 10:18:21 AM) ok, gonna' need a lot more fixing.
Me (12/1/2006 10:18:30 AM) o.O
Zejan (12/1/2006 10:18:31 AM) DU's backup utility is useless
Me (12/1/2006 10:18:38 AM) great!
Zejan (12/1/2006 10:18:54 AM) I'm having to hand edit the file :)
Me (12/1/2006 10:19:51 AM) <3 Zejan
Me (12/1/2006 10:20:03 AM) /manbabies
Me (12/1/2006 10:28:50 AM) can u get on aim?
Me (12/1/2006 10:29:02 AM) mine just broke
Me (12/1/2006 10:29:55 AM) nvm
Zejan (12/1/2006 10:43:40 AM) BTW, I don't like you nomore
Me (12/1/2006 10:43:55 AM) cuz my db is crazy nutso?
Zejan (12/1/2006 10:44:09 AM) yup
Me (12/1/2006 10:48:21 AM) but me likey...me likey u too
Zejan (12/1/2006 11:25:16 AM) http://www.youtube.com/watch?v=x9kC2lYDzRg&mode=related&search=
Zejan (12/1/2006 11:25:25 AM) I know you've seen it.. but is good
Zejan (12/1/2006 11:25:29 AM) (still working on file BTW)
Me (12/1/2006 11:25:37 AM) classics!
Me (12/1/2006 11:26:10 AM) i am love u for this
Me (12/1/2006 11:34:45 AM) "Yep. Yep. Yep. Yep. Damn shame."
Zejan (12/1/2006 11:35:12 AM) This is correct.. but no work "`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,"
Me (12/1/2006 11:35:28 AM) fuck
Zejan (12/1/2006 11:36:32 AM) I'll fix it :)
Zejan (12/1/2006 11:36:35 AM) No worries
Zejan (12/1/2006 11:36:44 AM) I've been doing this kinda' shit for years now
Me (12/1/2006 11:36:50 AM) from techies: The only option to import your MySQl DB through your 1&1 control panel under MySQL DB administration and click on phpmyadmin button, after click on the SQL logo at the left hand portion below 1&1 logo and click on import files tab but there's a limit size to import a Db using phpmyadmin.
Zejan (12/1/2006 11:37:11 AM) specifically dealing with differences in sql dumps and imports
Zejan (12/1/2006 11:51:14 AM) Dude.. do you still have the install files for the wiki?
Zejan (12/1/2006 12:05:32 PM) fsck... it's looking like they don't support on update
Zejan (12/1/2006 12:05:34 PM) alksd jalskd jalskdjal
Zejan (12/1/2006 1:20:37 PM) j00 there?
Zejan (12/1/2006 1:21:47 PM) I make fixed except for one table.
Me (12/1/2006 1:31:50 PM) which?
Zejan (12/1/2006 1:31:57 PM) sec
Zejan (12/1/2006 1:32:29 PM) table is page. Keeps saying duplicate key
Me (12/1/2006 1:35:43 PM) that is ungood
Zejan (12/1/2006 1:36:08 PM) It gets most of the data though
Zejan (12/1/2006 1:36:13 PM) I'm trying to fix now
Me (12/1/2006 1:45:42 PM) yeah, that's like table definition and pointer whatnot
Zejan (12/1/2006 1:45:55 PM) working on it :)
Me (12/1/2006 1:46:06 PM) oh, no biggie
Me (12/1/2006 1:46:12 PM) i know you'll figure it out
Me (12/1/2006 1:46:38 PM) no pressure
Me (12/1/2006 1:46:42 PM) really
Me (12/1/2006 1:46:44 PM) /cry
Me (12/1/2006 1:49:15 PM) so, upload the zip, or upload 1, 2, 3, 4 each one at a time
Zejan (12/1/2006 1:49:29 PM) One at a time
Zejan (12/1/2006 1:51:47 PM) Hmm.. I can get it to inser 1,706 rows... but I don't know if that's all of 'em
Me (12/1/2006 1:51:58 PM)
- 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '----
-- Table structure for table `searchindex` --
DROP TA
Me (12/1/2006 1:52:03 PM) that was on #4
Zejan (12/1/2006 1:52:08 PM) oh.. wait
Me (12/1/2006 1:53:40 PM) btw: i did the 1.sql through 4.sql...do i upload the table_text.sql files too?
Zejan (12/1/2006 1:54:20 PM) yes... start with table_text and then do table_text2 through 4 or 5 or however many of them there are....
Me (12/1/2006 1:56:07 PM) but i was supposed to start with the just plain number ones first right?
Zejan (12/1/2006 1:56:49 PM) yes
Zejan (12/1/2006 1:59:17 PM) j00 have page.
Zejan (12/1/2006 2:00:31 PM) also, I modified the "job" table... the keys were too long.. max key size is 500 This is how it was when I got it.... just in case.
DROP TABLE IF EXISTS `job`; CREATE TABLE `job` (
`job_id` int(9) unsigned NOT NULL auto_increment, `job_cmd` varchar(255) NOT NULL default , `job_namespace` int(11) NOT NULL default '0', `job_title` varchar(255) character set latin1 NOT NULL default , `job_params` blob NOT NULL, PRIMARY KEY (`job_id`), KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`)
);
Zejan (12/1/2006 2:00:52 PM) I changed job_cmd to a varchar(225)
Me (12/1/2006 2:14:45 PM)
- 1062 - Duplicate entry '0-Lawgirl' for key 2
Me (12/1/2006 2:14:47 PM) that's the one
Zejan (12/1/2006 2:14:51 PM) yup
Zejan (12/1/2006 2:15:16 PM) I think it's just a warning and not a halt error
Me (12/1/2006 2:20:06 PM) i can't re-run those files can i, or will they overwrite whatever's there?
Me (12/1/2006 2:20:24 PM) i'm near-certain i ran them in the right order, but the site is still borked
Zejan (12/1/2006 2:28:03 PM) Is your wiki config set up to access this database?
Zejan (12/1/2006 2:28:14 PM) cuz database names and passwords and whatnot changed
Me (12/1/2006 2:28:58 PM) i believe i changed it
Zejan (12/1/2006 2:29:07 PM) Czech :-)
Me (12/1/2006 2:37:48 PM) close...
Me (12/1/2006 2:38:03 PM) http://www.asitebyanyother.name/Main_Page
Zejan (12/1/2006 2:38:20 PM) I'm there already :)
Zejan (12/1/2006 2:38:32 PM) Now I gotta' figure out what's wrong with site_stats :)
Zejan (12/1/2006 2:39:59 PM) Run this:
Zejan (12/1/2006 2:40:01 PM) DROP TABLE IF EXISTS `site_stats`; CREATE TABLE `site_stats` (
`ss_row_id` int(8) unsigned NOT NULL default '0', `ss_total_views` bigint(20) unsigned default '0', `ss_total_edits` bigint(20) unsigned default '0', `ss_good_articles` bigint(20) unsigned default '0', `ss_total_pages` bigint(20) default '-1', `ss_users` bigint(20) default '-1', `ss_admins` int(10) default '-1', `ss_images` int(10) default '0', UNIQUE KEY `ss_row_id` (`ss_row_id`)
);
-- -- Dumping data for table `site_stats` --
LOCK TABLES `site_stats` WRITE; /*!40000 ALTER TABLE `site_stats` DISABLE KEYS */; INSERT INTO `site_stats` (`ss_row_id`, `ss_total_views`, `ss_total_edits`, `ss_good_articles`, `ss_total_pages`, `ss_users`, `ss_admins`, `ss_images`) VALUES (1,99411,2396,308,1828,8,-1,57); /*!40000 ALTER TABLE `site_stats` ENABLE KEYS */; UNLOCK TABLES;
Me (12/1/2006 2:41:28 PM) ran, new error
Zejan (12/1/2006 2:41:31 PM) ok.. I fix user_netwalk
Zejan (12/1/2006 2:41:37 PM) newtalk
Me (12/1/2006 2:41:49 PM) iou lunch
Me (12/1/2006 2:41:53 PM) or manlove
Zejan (12/1/2006 2:43:35 PM) -- -- Table structure for table `user_newtalk` --
DROP TABLE IF EXISTS `user_newtalk`; CREATE TABLE `user_newtalk` (
`user_id` int(5) NOT NULL default '0', `user_ip` varchar(40) NOT NULL default , KEY `user_id` (`user_id`), KEY `user_ip` (`user_ip`)
);
-- -- Dumping data for table `user_newtalk` --
LOCK TABLES `user_newtalk` WRITE; /*!40000 ALTER TABLE `user_newtalk` DISABLE KEYS */; /*!40000 ALTER TABLE `user_newtalk` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `validate` --
DROP TABLE IF EXISTS `validate`; CREATE TABLE `validate` (
`val_user` int(11) NOT NULL default '0', `val_page` int(11) unsigned NOT NULL default '0', `val_revision` int(11) unsigned NOT NULL default '0', `val_type` int(11) unsigned NOT NULL default '0', `val_value` int(11) default '0', `val_comment` varchar(255) NOT NULL default , `val_ip` varchar(20) NOT NULL default , KEY `val_user` (`val_user`,`val_revision`)
);
-- -- Dumping data for table `validate` --
LOCK TABLES `validate` WR
Zejan (12/1/2006 2:43:40 PM) shit
Zejan (12/1/2006 2:43:42 PM) Don't do that
Me (12/1/2006 2:43:47 PM) lol
Zejan (12/1/2006 2:44:02 PM) Email
Me (12/1/2006 2:45:10 PM) wholly slow as page loads batman
Zejan (12/1/2006 2:45:17 PM) j00 have page :)
Me (12/1/2006 2:45:30 PM) main page, yes
Zejan (12/1/2006 2:45:40 PM) I just clicked "all"
Zejan (12/1/2006 2:45:45 PM) but it kabloded
Me (12/1/2006 2:45:53 PM) yeah
Zejan (12/1/2006 2:46:06 PM) I think it's the wiki
Me (12/1/2006 2:46:25 PM) The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
* This problem can sometimes be caused by disabling or refusing to accept
cookies.
Zejan (12/1/2006 2:46:40 PM) yesh, I don't know why that's happenin'
Me (12/1/2006 2:47:56 PM) odd: http://www.asitebyanyother.name/Special:Categories
Me (12/1/2006 2:47:58 PM) works fine
Me (12/1/2006 2:48:10 PM) http://www.asitebyanyother.name/index.php/December_1 not so much
Zejan (12/1/2006 2:48:19 PM) is it supposed to try and send you to the index.php/whatever?
Me (12/1/2006 2:48:48 PM) lemme check something
Me (12/1/2006 2:53:27 PM) A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "User::idFromName". MySQL returned error "1146: Table 'db188307911.user' doesn't exist (db251.perfora.net)".
Me (12/1/2006 2:53:33 PM) btw: fixed the other issue though
Zejan (12/1/2006 2:57:25 PM) email
Zejan (12/1/2006 2:57:39 PM) gonna' pee and smoke
Me (12/1/2006 2:57:42 PM) email
Me (12/1/2006 2:57:50 PM) i really do love you
Zejan (12/1/2006 2:58:03 PM) what? Watchlist?
Zejan (12/1/2006 2:58:04 PM) WTF?
Zejan (12/1/2006 2:58:07 PM) I KNOW I did that table
Zejan (12/1/2006 2:58:09 PM) sec
Zejan (12/1/2006 2:59:18 PM) DROP TABLE IF EXISTS `watchlist`; CREATE TABLE `watchlist` (
`wl_user` int(5) unsigned NOT NULL default '0', `wl_namespace` int(11) NOT NULL default '0', `wl_title` varchar(255) character set latin1 NOT NULL default , `wl_notificationtimestamp` varchar(14) character set latin1 default NULL, UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`), KEY `namespace_title` (`wl_namespace`,`wl_title`)
);
-- -- Dumping data for table `watchlist` --
LOCK TABLES `watchlist` WRITE; /*!40000 ALTER TABLE `watchlist` DISABLE KEYS */; INSERT INTO `watchlist` (`wl_user`, `wl_namespace`, `wl_title`, `wl_notificationtimestamp`) VALUES (2,0,'Perfect',NULL),(2,1,'Perfect',NULL),(2,8,'Sidebar',NULL),(2,9,'Sidebar',NULL),(6,0,'July_4',NULL),(6,0,'Main_Page',NULL),(6,1,'July_4',NULL),(6,1,'Main_Page',NULL); /*!40000 ALTER TABLE `watchlist` ENABLE KEYS */; UNLOCK TABLES;
Me (12/1/2006 3:00:31 PM) go pee
Me (12/1/2006 3:00:33 PM) i think it works
Zejan (12/1/2006 3:00:41 PM) on phone now :)
Me (12/1/2006 3:01:14 PM) it worketh!
Me (12/1/2006 3:01:18 PM) /manbabies
Me (12/1/2006 3:01:54 PM) fux0rz
Me (12/1/2006 3:01:55 PM) A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "Article:getUsedTemplates". MySQL returned error "1146: Table 'db188307911.templatelinks' doesn't exist (db251.perfora.net)".
Zejan (12/1/2006 3:03:54 PM) DROP TABLE IF EXISTS `templatelinks`; CREATE TABLE `templatelinks` (
`tl_from` int(8) unsigned NOT NULL default '0', `tl_namespace` int(11) NOT NULL default '0', `tl_title` varchar(255) character set latin1 NOT NULL default , UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`), KEY `tl_namespace` (`tl_namespace`,`tl_title`)
);
-- -- Dumping data for table `templatelinks` --
LOCK TABLES `templatelinks` WRITE; /*!40000 ALTER TABLE `templatelinks` DISABLE KEYS */; INSERT INTO `templatelinks` (`tl_from`, `tl_namespace`, `tl_title`) VALUES (1571,10,'-'),(1397,10,'AlphabeticalList'),(1738,10,'Lts'),(1,10,'Oldblog'),(1088,10,'Oldblog'),(1,10,'Oldblog-url'),(1088,10,'Oldblog-url'),(1497,10,'Oldblogitem'),(1631,10,'Oldblogitem'),(1418,10,'Talk_Page'),(1690,10,'Talk_Page'),(1696,10,'Talk_Page'),(1698,10,'Talk_Page'),(1706,10,'Talk_Page'),(1753,10,'Talk_Page'); /*!40000 ALTER TABLE `templatelinks` ENABLE KEYS */; UNLOCK TABLES;
Me (12/1/2006 3:06:09 PM) from within function "SearchMySQL4::update". MySQL returned error "1146: Table 'db188307911.searchindex' doesn't exist (db251.perfora.net)".
Zejan (12/1/2006 3:06:21 PM) OMGWTFBBQ?
Zejan (12/1/2006 3:06:28 PM) I thought I got all of these?
Me (12/1/2006 3:07:13 PM) is there one thing in that text you need to do/mod so if i run into more over the weekend i can fix?
Zejan (12/1/2006 3:07:45 PM) No, it's just run it, see what blows, research fix, make fix happen, run again, see what blows... rinse, repeat
Me (12/1/2006 3:08:31 PM) can i rerun one of the files you already gave me in entirety?
Zejan (12/1/2006 3:08:44 PM) Uh... sorta
Zejan (12/1/2006 3:09:14 PM) shit,broke groupwise
Zejan (12/1/2006 3:09:32 PM) send you file some other way :)
Zejan (12/1/2006 3:10:13 PM) Uh... I broke my computer
Me (12/1/2006 3:10:17 PM) ack
Zejan (12/1/2006 3:10:52 PM) gonna' go smee.
Zejan (12/1/2006 3:11:05 PM) then I finish fixing stuff.
Me (12/1/2006 3:11:21 PM) KK
Me (12/1/2006 3:18:46 PM) Welcome to the beta test of World of Warcraft: The Burning Crusade!
Zejan (12/1/2006 3:20:28 PM) w00t
Zejan (12/1/2006 3:23:54 PM) I'm doing searchindex right?
Me (12/1/2006 3:24:13 PM) yup
Zejan (12/1/2006 3:25:29 PM) http://as400team.pacerglobal.com/wiki
Zejan (12/1/2006 3:26:50 PM) That work?
Me (12/1/2006 3:28:41 PM) checking
Me (12/1/2006 3:29:26 PM) http://asitebyanyother.name/December_1#Me_15:29.2C_1_December_2006_.28EST.29
Zejan (12/1/2006 3:29:50 PM) w00t! I make work!
Zejan (12/1/2006 3:30:12 PM) You should post our chat log =D
Me (12/1/2006 3:30:27 PM) you got the whole thing?
Zejan (12/1/2006 3:30:31 PM) yup
Me (12/1/2006 3:30:47 PM) throw it back out on http://as400team.pacerglobal.com/wiki
Conversation ended: (12/1/2006 3:30:48 PM)
