#mysql
04 October 2007
Total 23 pages. You are browsing page 3/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
02:06 <****> tators learn hour to import comma delimited files
02:06 <****> how
02:06 <****> yeah I know how to
02:06 <****> very easily
02:07 <****> there's something about the .out ending on this
02:07 <****> that is making it difficult
02:07 <****> if UUID() is used as a primary key for a table, i've just discovered that the last insert id isnt set like it would be for an auto increment field.. how do i get the result of the generated UUID?
02:07 <****> tators obviously you did not read the page you pointed us at
02:07 <****> Mrdini: well, I've installed the connector, but don't know how to "import it" in a project
02:08 <****> eg.. im using UUID() in an insert statement, but i need to know what it is for subsequent insert into a different table
02:08 <****> archivist ??
02:13 <****> no ideas?
02:14 <****> i guess i can just do a SELECT UUID first.. duh :P
02:14 <****> YammYgirlcoding, how are you trying to enter it mysql, or some other thing like phpmyadmin
02:17 <****> I've got some list, with Name/address/email/phone - is there any possibility to filter the email address to another out put out of this txt?
02:17 <****> archivist in mysql prompt
02:18 <****> archivist I removed the IN, and now the error says tthat i cant have dynamic querys inside functions. oh no! what I do now?
02:22 <****> put the in back missing ; after end and resetting delimiter ;
02:23 <****> and 1:12 AM /me wants to go home
02:31 * zeitsofa gute nacht - good night
02:33 <****>
02:34 <****> field
02:34 <****> ORDER BY FIELD( country, 'US', 'Canada', country ), country; // This will order the list by placing the US first, Canada as second, and the other countries in alphabetical order
03:08 <****> seekwill: I made a decent maze
03:16 <****> in mdb2 for php/pear do I only use prepare statements for sql inserts/update/writes? thanks
03:28 <****> got an interesting question, i have a select query that returns 8 mil rows(emails) to a file, i want to seed the list w/ a certain row(email) but i cant get it into an array to intersect, there a way i cna get it to be one of the rows somewhere in the middle?
03:42 <****> Anyone know of a good tool to convert a postgres dump to a mysql compatible format?
03:45 <****> Hi guys ..
03:45 <****> I have a big big problem here
03:46 <****> I cannot start anymore mysql server from the server.. this happenned since I had to reset the machine while it was booting up at startup ...
03:46 <****> WooD: do you get an error?
03:46 <****> yes
03:46 <****> what is it?
03:46 <****> chadmaynard: yes in the syslog file
03:46 <****> paste it
03:47 <****> chadmaynard: how to paste it is more than one line
03:47 <****> Anyone know of a good tool to convert a postgres dump to a mysql compatible format? I have a 700ish kb postgres dump and manually editing the table defs to mysql format would take forever.
03:47 <****> WooD: use a pastebin
03:47 <****> what, if any, is the importance of the order of the fields in a "combined" primary key in a join table? (i don't know the proper term, i'm referring to (a_id, b_id) style keys)
03:47 <****> chadmaynard: hmm i dont know that ..
03:47 <****> i've tried google but not knowing the term is making that difficult
03:47 <****> !tell WooD about pastebin
03:47 <****> WooD try http://pastebin.ca or http://pastebin.mysql-es.org
03:47 <****> ok
03:48 <****> pd: the optimizer can find the key no matter the order
03:49 <****> chadmaynard: cool, thanks
03:49 <****> the vast majority of my queries are for only one of the ids, so i wasn't sure if i needed to worry about it
03:50 <****> chadmaynard: ok here it is
03:50 <****> chadmaynard: http://pastebin.ca/725033
03:52 <****> WooD: you have a crashed table (one of the mysql internal tables). You should try to repair it with myisamchk -r
03:52 <****> chadmaynard: ho ok
03:52 <****> chadmaynard: ok i try that command
03:52 <****> WooD: you have to cd to the datadir first
03:53 <****> chadmaynard: lol where is that file ?
03:53 <****> WooD: hmm. Anyone know where debian datadir is by default?
03:53 <****> chadmaynard: i have ubuntu
03:53 <****> ubuntu then
03:54 <****> chadmaynard: Almost the same I think
03:54 <****> WooD: try locate mysql/mysql
03:54 <****> chadmaynard: ok
03:54 <****> chadmaynard: do you work for MySQL AB or something? :)
03:54 <****> nope
03:55 <****> chadmaynard: i get a lot of files... /var/lib/mysql/mysql/user.MYI .. etc
03:55 <****> maybe you should.. i just checked on their front page, they are hiring
03:55 <****> WooD: then the datadir is /var/lib/mysql
03:55 <****> snadge: maybe so
03:55 <****> chadmaynard: ok i see
03:55 <****> chadmaynard: i have 6 database in there
03:56 <****> WooD: cd mysql
03:56 <****> chadmaynard: i have to do that command on each folder of datafiles ?
03:56 <****> chadmaynard: you have more knowledge about mysql than just about anybody i've come accross.. thats why i asked that was all, and you provide support for it for nothing
03:57 <****> Anyone see anything wrong with this query? INSERT INTO "html_img" VALUES (14,'ipage',16,'14_new_bitmap_image.bmp',1,NULL,NULL,NULL,0,NULL);
03:57 <****> Does NULL need to be wrapped in single quotes in mySQL?
03:57 <****> avidal: Double quotes are for ANSI mode, otherwise use backtics for identifiers.
03:57 <****> hi, is it possible to limit the bandwidth when using mysql replication?
03:58 <****> Xgc: Ah. That was from a postgres sql dump. I ran the import in postgres compat mode and it worked
03:58 <****> avidal: In this case, remove the double quotes.
03:58 <****> avidal: Right. That probably enables ANSI mode.
03:59 <****> Hrm. There were a bunch of \015\012 in the data....anyone recognize what that would be for?
03:59 <****> WooD: you can use a wildcard. *
03:59 <****> Is that CR+LF?
03:59 <****> chadmaynard: ok I did the command into the /var/lib/mysql/mysql/ and after I tried mysql start and still the same ..
03:59 <****> WooD: did it say the table was ok?
04:00 <****> chadmaynard: i check
04:00 <****> WooD: I mean in the output of myisamchk
04:00 <****> WooD: if it finds a problem you still have to use -r flag to actually make it fix it
04:01 <****> chadmaynard: seems that the command is not good
04:01 <****> WooD: what command?
04:01 <****> chadmaynard: /var/lib/mysql/mysql$ sudo myisamchk -r
04:01 <****> WooD: you have to tell it what files.
04:02 <****> myisamchk *.MY*
04:02 <****> chadmaynard: sorry ok
04:03 <****> chadmaynard: MyISAM-table 'user.MYI' is corrupted
04:03 <****> WooD myisamchk -r user.MYI
04:03 <****> chadmaynard : so i -r this file
04:03 <****> yes
04:03 <****> ok
04:03 <****> chadmaynard: ok done
04:04 <****> WooD: check it again
04:04 <****> chadmaynard: ok
Total 23 pages. You are browsing page 3/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last