#mysql
23 October 2007
Total 29 pages. You are browsing page 29/29.
First :: Prev :: [...] [25] [26] [27] [28] [29] :: Next :: Last
23:40 <****> ?
23:40 <****> setuid: The replace doesn't check the entire row, only the columns in the unique indexes
23:40 <****> MacRohard: that only works if the data is continuous. I hate that idea
23:40 <****> ionico: look into ALTER TABLE
23:41 <****> I've done something stupid. Accidently (don't make fun of me) I did rm -rf /home/mysql (intended to delete an other directory -- damn tabs). That directory contained all databases
23:41 <****> chadmaynard, well. the min time that's larger than the last time
23:41 <****> setuid: it will check the new value in the auto-inc for uniqueness. Then it will check the content column for uniqueness. Separately. If either have dups it will fail
23:41 <****> I hitted ctrl+c asap, but now (when restarting sql). I get this error
23:41 <****> STOPPING server from pid file /home/mysql/site.cautela.nl.pid
23:41 <****> God that makes no sense to me
23:41 <****> But let me try that implementation
23:41 <****> (I did ./mysqld_safe)
23:41 <****> MacRohard: better but still that'll be SLOW.
23:42 <****> there appaers to be a file /home/mysql/site.cautela.nl.err
23:42 <****> _yannick: pastebin it!
23:42 <****> chadmaynard, perhaps.. it might not be too bad though
23:42 <****> which says:
23:42 <****> 071023 23:42:11 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
23:42 <****> 071023 23:42:11 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
23:42 <****> that's the only relevant thing (2 lines was not worth a pastebin)
23:42 <****> _yannick: don't paste here, and permissions. chown the files
23:45 <****> ALTER TABLE `wp_posts` ADD `t_md5` VARCHAR( 32 ) UNSIGNED NOT NULL AFTER `ID`
23:45 <****> grrr
23:45 <****> #1064 - You have an error in your SQL syntax;
23:45 <****> alter table foo add column....
23:45 <****> or is column optional
23:45 <****> i think it is. nevermind. carry on
23:46 <****> hi
23:46 <****> varchar can't be unsigned. lol
23:46 <****> damn phpmyadmin
23:46 <****> what if host.frm is gone?
23:47 <****> Tapout, Ok, so I have a 't_md5' row on my wp_posts column... now you're saying I can use an md5() function to md5(@article_content), as I insert it into the row?
23:48 <****> you're welcome set
23:48 <****> Yes, and many thanks... (if this works, no success yet)
23:48 <****> set: yes. insert MD5(@articl....);
23:48 <****> make sure t_md5 is set to unique
23:48 <****> It is
23:49 <****> chadmaynard, Is the md5(@foo) in the INSERT side (LHS) or the VALUES side (RHS)?
23:49 <****> values side
23:49 <****> I'm still learning MySQL and was wondering if someone take a look at my code and tell me if I'm doing this properly http://pastebin.ca/747293
23:50 <****> So:
23:50 <****> how many queries a second can mysql take before it explodes
23:50 <****> PaulB: 14
23:50 <****>prepare(qq{REPLACE IGNORE INTO `wp_posts` (`t_md5`, `post_author` , `post_date` , `post_content` , `post_title`, `post_status`) VALUES (md5(?), ?, ?, ?, ?, 'draft')});
23:50 <****>execute($article_body, $post_author, $article_date, $article_body, $article_title);
23:50 <****> lol
23:50 <****> 14
23:51 <****> well it was a silly question.
23:51 <****> what's the query, how much data, hardware, indexing, lots of other stuff
23:51 <****> I think you can get 28, if you cluster
23:52 <****> Depends on how much dynamite you use too
23:52 <****> Ok, as expected, this md5 trick did nothing
23:53 <****> 14 queries? Oh god, I better blast-proof the server room quickly
23:53 <****> Erm, did you set the md5 column on the existing data first?
23:53 <****> setuid: show create table
23:53 <****> chadmaynard, sec.
23:54 <****> http://rafb.net/p/kGu3OV21.html
23:54 <****> setuid: update table set `t_md5` = MD5(`post_content`); too
23:54 <****> setuid: you didn't make that column unique
23:54 <****> | 325 | cb7687c390f83bbd8668d38281caa684 | Choose the Right Foo |
23:54 <****> | 326 | cb7687c390f83bbd8668d38281caa684 | Choose the Right Foo |
23:54 <****> | 327 | cb7687c390f83bbd8668d38281caa684 | Choose the Right Foo |
23:54 <****> hrm
23:55 <****> alter table add unique(md5colname);
23:55 <****> (might need the alter ignore, if it's already got dup data in it)
23:56 <****> delete the dupes
23:56 <****> alter wp_posts add unique(`t_md5`) varchar(32) NOT NULL;
23:56 <****> Right, I'm reloading from the dump again
23:56 <****> does it take up more resources if i use * rather than selecting the columns i need?
23:56 <****> PaulB, Yes
23:56 <****> ooh
23:56 <****> setuid: did you delete the column?
23:56 <****> * is bad
23:56 <****> ok staying from that bastard*
23:56 <****> ok so select column names
23:57 <****> no wildcards
23:57 <****> chadmaynard, Bad syntax
23:57 <****> setuid: you didn't do what I told you to do
23:58 <****> alter table `wp_posts` add unique(`t_md5`);
23:58 <****> chadmaynard, I reloaded the db from a pre-md5 column state... trying to figure out what phpmyadmin does, so I can learn it through the shell
23:58 <****> ALTER TABLE `wp_posts` ADD UNIQUE (`t_md5`)
23:58 <****> comeon help a newbie out did I do this coding properly http://pastebin.ca/747293
23:58 <****> #1062 - Duplicate entry '' for key 2
23:59 <****> But that column does not exist
23:59 <****> setuid: isnt that duplace entry in that t_md5 ?
23:59 <****> setuid: add it then. i'm not sure why you deleted it
23:59 <****> arg, this is so confusing. I can't add a column to a table, because it says it exists, but it doesn't exist, so I can't delete it.
23:59 <****> wheeeee!
--- Log closed Wed Oct 24 00:00:13 2007
Total 29 pages. You are browsing page 29/29.
First :: Prev :: [...] [25] [26] [27] [28] [29] :: Next :: Last