| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> but when i search in 1200000 registers it take 1 minute
<0> to find the doc
<0> is so much time?
<0> Xgc: what do you think?
<1> Depends on the criteria.
<1> SlayPain: Show an example SELECT.
<0> wait
<1> Use the pastebin if it's more than one or two lines.
<2> http://pastebin.com/729161
<0> wait
<0> i will use pastebin
<1> BriteLeaf: Check the error log.
<0> Xgc: http://pastebin.com/729172
<1> SlayPain: That will perform very badly, since no indexes will be used.
<0> wait
<2> If I read this right (error log) there are no errors and the mysql daemon is running... http://pastebin.com/729175
<2> not error.log... mysqld.log
<1> BriteLeaf: Well, is it running?
<2> All I know for sure Xgc, is that it APPEARS to be. But running does me zero good if I can't get in it, right?
<1> BriteLeaf: and does the last start time match what you'd expect?
<2> yes
<2> that does match
<1> Maybe you never shut it down correctly.
<2> netsplit
<2> http://pastebin.com/729175
<2> disreguard that
<1> BriteLeaf: Don't know what to tell you other than, use the GRANT command to fix root access. Don't try to set the p***word field yourself.
<2> this says shut down did work... 060419 22:10:31 [Note] /usr/libexec/mysqld: Normal shutdown
<2> 060419 22:10:31 InnoDB: Starting shutdown...
<2> 060419 22:10:33 InnoDB: Shutdown completed; log sequence number 0 43665
<2> 060419 22:10:33 [Note] /usr/libexec/mysqld: Shutdown complete
<2> 060419 22:10:33 mysqld ended
<1> BriteLeaf: I'm guessing your attempt to set the p***word was incorrect. Try using the GRANT command instead.
<2> k
<3> SlayPain, What does $busqueda typically look like?
<0> $busqueda = search
<0> this is the query
<0> http://pastebin.com/729193
<0> this is all source code
<0> http://pastebin.com/729195
<0> Xgc: look the source code
<4> Can i ask ? mysql runs on windows2003 is not recommended ?
<0> Noboru: is no recomended to run Windows 2003
<4> I mean is it true that if we run mysql run windows2003,there will be some strange problems occured than we ever expected ?
<0> use Linux or FreeBSD
<0> look for problems reported in MySQL.com
<4> SlayPain, but i have some question to run linux, some programs i will need to run which only work on windows
<0> what programs?
<5> is there any reasonable way i could do a reverse regex where a column in DB contains a pattern and i want to see if that pattern matches a string i provide
<4> SlayPain, I need a 3rt party tool to do keyword filtering and stuff,this program by far has windows release only
<4> 3rd*
<0> find one in linux
<0> there can be some app
<4> So you would agree mysql would have some strange problem running on windows ?
<0> i never run in win2003
<0> only linux
<0> but
<0> you can test
<0> create databases
<0> inser some millions of registers and see what happen
<4> I see
<0> but you have to read too in mysql.com
<4> I will try that
<4> But i dont think they put those threads on the site that it wont work well on windows
<0> hummm
<0> there is only one way to know it, test it !
<4> ok
<0> hey guys
<0> i want to import a DB
<0> but when i imported it, all don't appear good
<0> all appear like
<0> is there any way to solve this_
<1> bnovc: WHERE 'string' LIKE col1
<5> Xgc, that would use the regex from col1?
<1> bnovc: or use RLIKE
<5> you sure?
<5> i didnt think LIKE supported regex
<1> bnovc: It's the same idea.
<1> bnovc: WHERE 'string' RLIKE col1
<5> hm, ok, cool thanks
<1> You're welcome.
<0> Xgc: do you see my question
<0> ?
<0> i am importing CSV file
<0> but all speciall chars appear wrong
<0> appear like --->
<6> <?php
<6> $text = "A very long woooooooooooord.";
<6> $newtext = wordwrap($text, 8, "\n", 1);
<6> echo "$newtext\n";
<6> ?>
<6> opps wrong channel
<7> Does anyone see a syntax error in this query? > "INSERT INTO wwm_news (articleID, DATE, TITLE, STORY) VALUES ('', '$news_date', '$news_title', '$news_story')" <
<7> Yo?
<7> Hey bish504! :D
<8> kai_wp: Not offhand, aside from 'using prepared statements with bind values is a good idea', and 'DATE is a reserved word, but is probably accepted without quotes'. What error are you receiving?
<9> you shouldn't insert '' into an auto_increment column, you should omit the column or specify NULL (i'm ***uming articleID is autoinc)
<7> Well the query is stored in the variable $query, so I use the code "mysql_query ("$query") OR DIE ("Cannot query");"
<7> and I always get the message "Cannot Query
<8> ah, yeah, that's probably it.
<9> kai, http://php.net/mysql_error
<9> use that instea dof "cannot query"
<7> so remove the articleID?
<7> ok
<9> and use mysql-error
<9> _
<7> Um what do I put where it says "Resource Link Identifier"?
<9> The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is ***umed.
<9> e.g. you did $dbh = mysql_connect(whatever)...
<9> you'd do mysql_error($dbh)
<7> oh ok
<9> or just mysql_error() if you don't have more than one open connection
<7> THANKS SO MUCH! :D
<7> I fixed it!
<9> find the error?
<7> Or techinicly you did.
<7> Yup.
<9> what was it?
<9> the articleid thing?
<7> I was trying to insert into a table named wwm_news, when it should have been WWM_news.
<9> ahhhh
<7> These simple errors always take up so much time.
<9> not when you use mysql_error religiously :P
<7> religiousely?
<7> But ya I should have used mysql_error() but I never knew it existed.
<7> Anyway, thanks! :D
<7> I gotta go now.
<7> Bye! :D
<10> Hey
<10> If you've got a key that auto incriments, how do you set a value to it?
<9> hmm?
<10> Well how do I get it to auto incriment?
<9> omit it when you insert or insert NULL
<10> I'm trying to insert a row, what value do I need to put in for that field?
<10> Oh ok thanks
<11> is there another way to find out if a table exists other than SHOW TABLES LIKE.. ?
<9> what's wrong with show tables like?
<9> there are multiple other ways, i'm just curious.
<11> (this is in a perl app) its not returning false, so my table existance checks just dont work
<9> you can't just take 0 rows as false and not-0-rows as true?
<9> create a function to check if a table exists
<9> change your code to call the function
<11> i have unless ($dbh->do("SHOW TABLES LIKE '$table'")) { fail; }
<9> like i care
<11> which does not work, it always returns true
<9> change your code.
<12> if I select 50 random rows from a table, is there a guarantee that each row will be unique?
<9> write a function to check if the table exists
<9> how are you selecting the random rows, flolry?
<12> ie SELECT * from table WHERE 1 ORDER BY RAND() LIMIT 50;
<11> gleam_: it would have to use $dbh->do("SHOW TABLES LIKE '$table'") anyways which is where the problem lies
Return to
#mysql
or
Go to some related
logs:
#centos
#centos
workplace switcher
mysql-server configuration ubuntu Internet site no configuration
#gentoo
qtparted no device found
Ati+Debian repositories
grub-remove
#perl
install fluxbox themes permission denied
|
|