#mysql
30 September 2007
Total 19 pages. You are browsing page 3/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
02:08 <****> phpinfo(); ?
02:09 <****> mikegriffin: I am trying to query from root acount and I already granted all on the entire db to the user that php is set to connect to
02:09 <****> mikegriffin: one step ahead of you (just through it on some random page I had open... LOL)
02:11 <****> GRANT ALL PRIVILEGES ON dbname.* to 'dbuser'@'localhost' ?
02:11 <****> mikegriffin: default_charset = "iso-8859-1" (changing it to utf8)
02:11 <****> slavi1: also try flush privileges;
02:12 <****> Terinjokes: im guessing btw
02:12 <****> should be easy enough to revert
02:13 <****> http://pastebin.com/m6078fbba
02:13 <****> megaspaz, ?
02:14 <****> mikegriffin: does that look familiar to you?
02:14 <****> So... there is absolutely no performance issues with adding a TEXT column to a table?
02:14 <****> Assuming the TEXT is not being used in any queries.
02:15 <****> And assuming the TEXT columns are filled up with data for each row.
02:16 <****> nope, flush privileges didn't work
02:17 <****> mikegriffin: nope... nothing
02:17 <****> gfhghgfhfg: a larger row size will affect performance
02:19 <****> slavi1: are you sure the value is actually 'slavikg'? maybe there are trailing spaces. try: LIKE 'slavikg%'
02:19 <****> mikegriffin, Cahaan: ran mysql_client_encoding on the server... it's still reporting latin1
02:20 <****> hmm
02:21 <****> slavi1: if you define the username column as CHAR instead of VARCHAR, it will be space padded
02:21 <****> it's varchar
02:21 <****> I tried %slavik% and still zero rows
02:21 <****> in another table, I had to remove the rows and readd them, but there were like 6 of them ...
02:22 <****> does anything go into the mysql db when new databases are created and such?
02:23 <****> ok... did a SQL dump... i see DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
02:24 <****> hey, is there a way to create a field that will automatically insert the date everytime a row is entered?
02:24 <****> zaatar: set col as TIMESTAMP and insert NULL into it or nothing at all
02:25 <****> well, check table users reports that the table needs to be updated ...
02:26 <****> but repair table users extended reports no errors
02:26 <****> and 2 errors
02:26 <****> slav: mysql_fix_privilege_tables
02:27 <****> slav: mysqlcheck --autorepair mysql
02:27 <****> mysqlcheck --auto-repair mysql
02:30 <****> this is weird
02:30 <****> mysqlcheck reports errors (update required)
02:30 <****> but mysqlcheck --auto-repair shows that the tables are already repaired
02:31 <****> mysqlcheck -ao mysql
02:31 <****> mikegriffin: thx
02:32 <****> the mysql db is fine, it is another db that was there when MySQL got messed up
02:32 <****> Shrews: It will? How?
02:33 <****> http://pastebin.com/m35a064a8
02:33 <****> gfhghgfhfg: the larger the rows, the less that can be cached in memory
02:33 <****> JavaGeek: np
02:33 <****> gfhghgfhfg: fk is gonna be best imho
02:34 <****> mikegriffin: -aoe produces same results
02:35 <****> mysqlcheck -e web_forums search_words
02:35 <****> oh
02:35 <****> try it anyway :)
02:36 <****> or perhaps mysqlcheck -eg web_forums search_words
02:37 <****> mikefoo: fk?
02:37 <****> foreign key
02:37 <****> Shrews: That makes no sense. The indexed columns are supposed to be... INDEXED!
02:39 <****> gfhghgfhfg: ok, what about the non-indexed columns? you have to go to the table to retrieve those
02:39 <****> and then you get into over indexing...
02:40 <****> Dammit...
02:40 <****> Everything is always complicated beyond belief...
02:41 <****> mikegriffin: nope, just shows the error ...
02:41 <****> is it a big table?
02:41 <****> was that for me?
02:41 <****> slavi1: if its not too big, mysqldump it and reimport to a new db
02:42 <****> see if its still broken
02:42 <****> remember that it will lock tables during the dump
02:42 <****> what if I dump it, then drop it and reimport it into same db?
02:42 <****> you can
02:42 <****> Is there any way to concat a column value and text only if a column is not null?
02:42 <****> mikegriffin: this isn't a high traffic site, so doesn't matter :)
02:43 <****> WebspecAdam: version of mysql? see functions
02:44 <****> mikegriffin: I'm using 4.1.22
02:44 <****> http://dev.mysql.com/doc/refman/4.1/en/functions.html
02:45 <****> mikegriffin: thanks
02:45 <****> WebspecAdam: in 5x stored procedures could do it
02:46 <****> im thinking that perhaps a function may not..
02:46 <****> concat_ws might do the job...
02:46 <****> I'm trying to join 3 strings
02:46 <****> with seperators
02:47 <****> string3
02:47 <****> except sometimes the strings are null
02:50 <****> hmm, I dropped the tables, but now when I try to mysqlimport, it says that the table is not there, even though I see create tables statements in the dump
02:51 <****> ', `granddept`.`text`, `parentdept`.`text`, `childdept`.`text`) AS `name` )
02:51 <****> WebspecAdam: sweet nice work
02:53 <****> WebspecAdam: same happens for me, unsure about mysqlimport
02:54 <****> mysql $dbname < $file.sql
02:56 <****> ahh
02:56 <****> works?
02:59 <****> yes, but have to fix stuff
02:59 <****> seems the tables got corrupted a bit
02:59 <****> the table definitions.
03:00 <****> ERROR 1062 (23000) at line 36: Duplicate entry 'that' for key 1
03:00 <****> looks like duplicate entries and such
03:10 <****> mmm noodles
03:11 * mikegriffin goes to kitchen :)
03:13 <****> mikegriffin: I think punbb broke down, heh
03:13 <****> ?
03:14 <****> oh a forum
03:14 <****> yea
03:14 <****> for some reason, it is having trouble reading the users table and it hashes the passwords ...
03:15 <****> administrating a gentoo server is not simple :(
03:15 <****> well, going to push for e107 :D
03:16 <****> slavi1: old_passwords=1 in my.cnf and then mysql_fix_privilege_tables
Total 19 pages. You are browsing page 3/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last