#mysql
14 October 2007
Total 16 pages. You are browsing page 5/16.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
05:44 <****> HerbM: MySQL error code 150: Foreign key constraint is incorrectly formed
05:44 <****> XsteelWolf: you need to take a good look at it again. you have order by, then limit, then where, then order by again
05:44 <****> both tables need to be InnoDB
05:44 <****> TodoInTX: and what about datatypes?
05:44 <****>
05:44 <****> must be identical
05:44 <****> chadmaynard: that what i need to say?
05:45 <****>
05:45 <****> blobaugh: yes but i have a feeling that he's going to want you to right it out exactly.
05:45 <****> you havent taken spelling yet at the uni have you chadmaynard
05:46 <****> or would that fall under grammer?
05:46 <****> hehe
05:46 <****> ok thanks, comprehend now
05:46 <****> i dont know
05:46 <****> :D
05:46 <****> grammar i think
05:46 <****> i'm just stupid. And tired
05:46 <****> i havent had to take an english class, or any of those prereqs in 3 years
05:46 <****> this is why i'm not talking directly to anyone currently.
05:46 <****> you're talking to me ;)
05:47 * blobaugh begins pulling stuff from under the bed
05:47 * chadmaynard adds !kickban blobaugh to the list of things to do today
05:47 <****> heh
05:47 <****> how can I check how much memory is my MySQL server consuming? (i'm on redhat)
05:48 <****> TodoInTX: Both tables were the default (Windows) and I believed that I eliminated Inno-DB as the issue when I got the sample to work without specfifying Inno-DB on the two test tables...
05:48 <****> chadmaynard: you know you love me. and one day you'll convince the guys to make me an op ;)
05:48 <****> there you go
05:48 <****> HerbM: ok, probably you have default-storage-engine=InnoDB as is the case with many Windows MySQL installs.
05:49 <****> one second of opness
05:49 <****> woot
05:49 <****> HerbM: other option is that the referenced column isn't the same datatype as the propertyID.
05:49 <****> TodoInTX: That's what I figured about InnoDB (think I read that somewhere) when I saw the requirement for Foreign Keys to use InnoDB tables
05:50 <****> Ok, I will recheck the types -- thought I did that but then I cannot even translate the EXAMPLE without somehow screwing it up
05:51 <****> gotta move some cable around. bbiab
05:52 <****> TodoInTX: no luck, I even tried int(11) even though originally I just used 'int' to defined the key in the master table
05:58 <****> HerbM: maybe you should give us show create tables
05:59 <****> chadmaynard: what is "show create tables" show tables?
05:59 <****> noo
06:00 <****>;
06:00 <****>;
06:00 <****> pastebin it
06:00 <****>;"
06:01 <****> ? paste
06:02 <****> grr... dumb b0t.
06:02 <****> is there a way to check the amount of memory used by mysql from the console?
06:03 <****> top... looks at the "RES" column
06:05 <****> chadmaynard: that (merely trying to pastebin it) probably found the error -- for some (strange) reason I defined the Engine type on the "master" table without even knowing why I did that. The thing has 52 fields -- it's a temp table to hold some raw data until I can get the stuff normalized. Thanks;
06:06 <****> HerbM: http://pastebin.com/d67084985
06:17 <****> re
06:21 <****> Thanks TodoInTX, and for the original suggestion (which I stupidly ignored) about InnoDB
06:21 <****> Where in TX, TodoInTX
06:21 <****> Here in Austin
06:38 <****> does MySQL's REGEXP allow conversion between uppercase and lowercase ? if not, are there MySQL functions I can use to do that outside of the REGEXP ?
06:47 <****> nm, I am taking the wrong approach to this problem
06:53 <****> \quit
06:58 <****> heya.. my mysql is set to use one gigantic file for all innodb databases -- can I enabled the each-db-to-separate-file option so that new dbs are written to separate files? would doing that screw up the existing data?
07:00 <****> EMH_Mark3: yes you'd have to dump existing data and reload once you set innodb-file-per-table
07:01 <****> chadmaynard: yes it would screw up existing data? or yes I can enable the one-db-per-file thing without screwing up stuff?
07:01 <****> EMH_Mark3: yes, it would screw it up.
07:02 <****> EMH_Mark3: which is why i said you should dump the data to .sql file and reload
07:03 <****> ah. don't really feel like dumping 100gb of stuff to flat files, so I think I'll just leave it the way it is :)
07:03 <****> thanks
07:03 <****> ok
07:39 <****> CREATE USER pat IDENTIFIED BY 'pass';
07:39 <****> ERROR 1146 (42S02): Table 'mysql.procs_priv' doesn't exist
07:39 <****> [domon]: mysql_install_db from the shell
07:40 <****> chadmaynard: that won't mess up any databases that are in the system right?
07:40 <****> [domon]: rigt
07:40 <****> good :D
07:40 <****> thx
07:41 <****> [root@ctc httpdocs]# mysql_install_db
07:41 <****> Installing MySQL system tables...
07:41 <****> ERROR: 1136 Column count doesn't match value count at row 1
07:41 <****> 071013 22:43:28 [ERROR] Aborting
07:41 <****> 071013 22:43:28 [Note] /usr/libexec/mysqld: Shutdown complete
07:41 <****> Installation of system tables failed!
07:41 <****> :(
07:41 <****> holy crap get pastebin
07:41 <****> Athfar: chill
07:42 <****> no i didn't walk in here to get flooded.... that cost me like 20 cents on my dial up
07:43 <****> it was only a few lines and the channel isn't busy. It's fine.
07:43 <****> 20 cents aint fine! I could have bought like 3oz of coke
07:43 <****> then dont be in IRC? i pasted only 6 lines (which is twice the normal max, but that rule is generally to keep people from having their conversations interupted, etc)
07:43 <****> [domon]: have you upgraded recently? what user did you try CREATE USER command with?
07:44 <****> [domon]: oh don't turn this around on me now
07:44 <****> Athfar: not like i did that purposefully to make you spend 20 cents...
07:44 <****> drop it!
07:45 <****> like it's hooot
07:45 <****> this chan is like no fun right now
07:45 <****> chadmaynard: no, and i'm using root
07:46 <****> [domon]: do you have any users already defined?
07:47 <****> yea
07:47 <****> well
07:47 <****> i am using root for command line...the mysql "root" user is admin
07:47 <****> we have a couple users though
07:48 <****> [domon]: It sounds like your grant tables are old, which doesn't make sense if you have not upgraded. You can always delete the mysql database and recreate with mysql_install_db. You won't lose any data but you will lose all of your users.
07:49 <****> i could backup the mysql user table right?
07:49 <****> yes
07:51 <****> okay
07:51 <****> so
Total 16 pages. You are browsing page 5/16.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last