#mysql
12 October 2007
Total 26 pages. You are browsing page 2/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:45 <****> snoyes said he can't discuss it until after the trial
00:45 <****> !kick blobaugh
00:45 <****> oh noes! did they find his warez and pr0nz?
00:45 <****> err
00:45 <****> heheh
00:45 <****> hahaha
00:47 <****> every bot we have hates me
00:48 <****> Hiya everyone. I need to create a query that lists every row in a table with a unique value of a certain field. For example, if said table had one field "id", and 3 records "1", "2" and "2", my query would return only the "1" and "2" rows.
00:48 <****> select distinct id from table
00:48 <****> ToeBee, thanks :)
00:49 <****> are you creating the id? because that's not what you want if thats what you meant.
00:49 <****> we should make an ihatechadmaynard bot
00:49 <****> ebergen: it already exists under a different name : )
00:49 <****> ^kury_71 look
00:51 <****> chadmaynard: all week he's been going crazy thinking EXPLAIN was lying to him
00:52 <****> explain is a liar
00:54 <****> i've been struggling to get replication to setup correctly. I lock tables, record master position, mysqldump, unlock tables, download dump file, import, CHANGE MASTER, START SLAVE, and SHOW SLAVE STATUS reports a sql error.
00:54 <****> sometimes 'duplicate entry' and now 'unknown table tmp_union'
00:57 <****> Hi. Are there any special considerations or tools available for converting a PostgreSQL database to MySQL? The application is drupal 4.7.
01:00 <****> I have a dump of --all-databases which is 5-6 databases, any intelligent way to get the .sql for only one of the databases?
01:00 <****> or just restore one of the db's from the dump
01:12 <****> how do i query for certain entries in a field
01:12 <****> blah.sql - How would I get the exit status of the mysqldump?
01:12 <****> select "x" -regular expression- from fieldname?
01:13 <****> mikefoo: bash script?
01:13 <****> yeah
01:13 <****> echo $? :o
01:13 <****> jme: no..
01:14 <****> not on a pipe
01:14 <****>& and store the result somewhere or whatever
01:15 <****> i'd have to check bash for beginners, which i look at here and there
01:18 <****> can an innodb table use in index when the query includes a LIKE "likeme%" where statement?
01:18 <****> you have if (exit status), pipestatus, and $?
01:19 <****> thats how you check or test against the exit status of the mysqldump process
01:19 <****> whast the variable again?
01:19 <****> $?
01:20 <****> like
01:20 <****> if [ $? -eq 0 ]
01:20 <****> heh
01:20 <****> now tell me how to do a query, i just want to select rows with a certain name in a field
01:20 <****> say the field is a persons name, and i want the name mike
01:21 <****> select mike from fieldname?
01:21 <****> please!
01:21 <****> yeah
01:22 <****> mikefoo: so i say "use database"
01:22 <****> yes
01:22 <****> then show tables;
01:22 <****> do I say use table or say select mike from tablename.field?
01:22 <****> then select * from table;
01:22 <****> you will then understand..
01:23 <****> i've done select * from table. i just want to know how to do selects with the fields, and regular expressions
01:23 <****> i'm sure it's easy
01:23 <****> i just want a basic search, like if mike is matched at all in the field
01:27 <****> I am working on trying to setup a slave sever
01:28 <****> I needed help with the replication server - I am getting an error
01:28 <****> ERROR 1219 (HY000): Error running query on master: Access denied; you need the RELOAD privilege for this operation
01:29 <****> Ive got two tables, and i need to copy/paste data from one table into the other, is there a way i can do this in commandline or via mysql administrator?
01:29 <****> dwxreaper, SELECT * FROM table WHERE column ilike '%whatever%'; at least in postgres, mysql should be similar. ;o
01:30 <****> anyone know how to fix this error? ERROR 1219 (HY000): Error running query on master: Access denied; you need the RELOAD privilege for this operation
01:30 <****> I am really struggling here any help would be really useful
01:31 <****> setting up the replication stuff is not easy
01:31 <****> I am having trouble
01:32 <****> do grant all on db.* to 'user'@'localhost';?
01:32 * Kupo24z shrugs
01:33 <****> the docs are decent...just have to follow them...your repl user probably doesn't have proper permissions.
01:34 <****> SiliconG: http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html if you follow those they work perfectly as jme` said they are pretty darn good
01:34 <****> whats the mysql command to dump everything into a db? mysql -u -p database < C:\db.sql ?
01:34 <****> Speedy059, yes.
01:35 <****> actually...that restores it to the db..doesn't dump. ;) mysqldump extracts the info.
01:35 <****> can mysqldump only dump a portion of a table?
01:35 <****> hmm i don't think so.
01:35 <****> 7000
01:36 <****> hmm
01:36 <****> is there any way to get a tables rows/columns in another table then?
01:37 <****> dump that table to a file then modify the file and import the file into the db...at least if you want a new table that's easy.
01:37 <****> i need to do it to an already existing table
01:37 <****> that has the same structure
01:38 <****> its just need like 50 more rows added from an old version of the table
01:38 <****> could just dump the table to a file and change it from create table and alter it
01:38 <****> how do you dump an individual table?
01:38 <****> man mysqldump
01:41 <****> looking for SQL guru to hire -- see me in #fg3
01:42 <****> hmm
01:42 <****> that syntax isn't working
01:43 <****> mysql -u -p database < C:\db.sql
01:43 <****> I don't think Windows supports that redirection thing
01:43 <****> Just log into the mysql client and run SOURCE c:\db.sql
01:50 <****> how do I dump a single table to sql? (including all its records
01:50 <****> )
01:52 <****> mysql -p -u ren2007bb < c:\ren2007bb.sql = Gives me and error "Incorrect database name "en2007bb.sql", what happened to the 'r'?
01:52 <****> im having some late night join issues: i have two table, eg. languages and lang_articles, i want to get all the languages that dont exist for a specific article.
01:52 <****> Speedy059, you need the database name
01:52 <****> nvm, i got mine
01:53 <****> fowlduck, man mysqldump
01:53 <****> i said i got it
01:53 <****> cool
01:53 <****> woo
01:55 <****> Yes i am...
01:55 <****> There is a database name
01:55 <****> right there
Total 26 pages. You are browsing page 2/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last