| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Nope.
<1> well thanks for the help guys!
<0> Target0, You're welcome!
<2> Hi gurus, I have this very odd error: ERROR 1064 (42000) at line 10231: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql int(3) NOT NULL default '0',
<3> kk....
<4> put any fulltext stuff you have in separate tables, and link them to other tables with an id column
<0> Kyndig, Full query?
<5> will - this is just a mysqldump from one box, and trying to create the table on a more up to date box
<0> Wasn't dumped 'properly' then.
<0> !m Kyndig mysqldump
<6> Kyndig: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<5> mysqldump -ufoo -p database>DATABASE on old box ... (mysqladmin create database) mysql -ufoo -p database<DATABASE
<5> but I narrowed the issue down
<0> Oh I bet you did.
<5> When I change the row entry from: sql int(3) NOT NULL DEFAULT '0' ..so something like: fsql int(3) NOT NULL DEFAULT '0' ...it works
<0> I bet
<7> hmm, could it be a reserved word?
<0> Naaaaaaa!
<5> Is "sql" now a restricted term for rows in a mysql table? If so..man am I in trouble (looks at thousands of codes/queries to update)
<0> That is why you are better off dumping it properly... Like I mentioned before.
<5> and if reserved - is there a backwards compatibility trigger? I ran through doc's but didn't see a fix
<0> !m Kyndig mysqldump
<6> Kyndig: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<0> Read the options... especially the ones about 'quoting'
<5> thanks will, doin so now
<3> hum
<0> muh
<3> meh :S
<0> hem
<3> before InnoDB came... didnt mysql support foreign keys ???
<0> No
<3> that sound stupid.... thought that was the basic of SQL
<0> If that bothers you, you can freely switch databases now.
<0> You sound stupid too, but I won't go into that.
<3> Please do walk
<3> will
<8> cappiz> It is rather weird that an rdbms would not support that.. but with innodb it does.. or you can move to postgresql, another opensource database which is ordbms
<3> Shariff okey.
<8> cappiz> Basically, it depends on what the purpose is for your database.. :)
<0> It's a matter of priority. I have the ability to use FKs now, but I don't. It's also very silly to think about the past. Who cares about when FKs were implemented?
<8> 1970 :P
<3> hehe :P
<5> ah .. --compatible ..nice
<0> Kyndig, No, that's not what you want.
<0> --opt is better
<8> will> Why not use FKs.. how do you secure data integrity?
<0> My application handles it.
<8> I see
<0> There's only one hand going into the cookie jar.
<0> Because of that ***umption, I want the speed of MyISAM.
<8> You are brave :D
<0> Why?
<8> You're ***uming the application is designed that integrity is ***ured (when it concerns relational data)
<5> will - I'm trying just the --quote-names right now, I just read about 'compatible'. The box I'm pulling it from is an older mysql version, and the one I'm trying to add it to is the one that comes with FC5. The dumped file itself is 1.2Gigs, and transferring it across a DSL connection is a real kick in the nuts. Can you toss me a bone on what I'm looking for in this dump?
<8> I would rather have it that the db would make sure I cannot do anything illegal :)
<0> Kyndig, I did
<9> most of the time, your data isn't as important as you think it is
<0> sjrussel, :)
<9> if it was, you'd pony up the $$$ for oracle
<10> hello, is there a way to turn verbose off on the mysql command prompt?
<3> oracle :P *money*
<9> or the $$ to get decent performance from InnoDB
<8> sjrussel> oracle also offers a lite version, which is free of charge :D
<5> HA! nodnod. that worked. --quote-names thanks much will
<9> yeah?
<8> sjrussel> Yes :)
<11> but only 4gb data/2gb ram or so...
<9> can it handle a 100 simultaneous connections and run over 10M reads/sec on commodity hardware?
<0> Shariff, I have not ran into a situation where I've had problems. Our company uses MySQL to store sales orders and invoices, and list of books. All of which usually runs into the 1k to 2k of line items. I've never had a situation where I've needed FKs because of the way I handle the data.
<8> sjrussel> I just prefer postgresql, because it doesn't require as much resources as Oracle does
<8> sjrussel> I do not know.. I would say, find out :D
<10> anyone read me
<9> I would say, I don't need to, I'm comfortable with MySQL
<0> Shariff, I have noticed in larger implementations where the company has multiple programmers/systems, FKs are essential. But I'm the superman at this company.
<0> testmania, Nope.
<0> testmania, What are you trying to do?
<9> much like, Java is built to allow lots of average programmers to work together w/out corrupting things
<8> will> I guess you're just lucky then, that your employers don't understand this stuff... I think if they would be given the choice, they would want their data to be as secure as possible :)
<0> Shariff, Tell me how it would be more secure?
<9> be bold, feel the wind blowing up yer kilt
<10> will: nothing but pasting like 10mb of data at the prompt and i dont wnat the verbose to be on so that it goes faster
<0> Shariff, Security at the cost of performance? Probably not.
<0> testmania, Importing a mysqldump?
<10> yes
<0> Try mysql [options] < myfile.sql
<8> will> Performance isn't everything, if something happens and data is no longer linked properly..
<9> ... then you deal with it
<0> Shariff, How would that ever happen?
<9> Shariff, if you need it, use InnoDB or NDB or BDB or PostgreSQL or MSSQL or Oracle....
<9> but if you like the speed more, use MyISAM
<9> will - it happens
<0> In our situation, we have never lost any data. Never any corruption. It's also datawarehoused data. All copies.
<8> will> Murphy's law
<9> rogue code, edge cases, server crashes, etc
<0> (Well, sales orders and invoices)
<0> My backup system is decent. Nothing is "critical" where we lose customers. We blame them when things "don't work" :)
<9> regardless, this isn't really worth debating
<8> Will> What if at some point you leave the company?
<0> Shariff, Job security... haha.
<9> if you need it, use an engine that supports it
<9> if you don't, don't
<8> lol
<0> Shariff, Hard to leave the company when you run it.
<5> will - updated my boxes with the --quote-names switch for backing up and transferring. Worked wonderfully. ::lets out a sigh of relief::
<8> As I said.. you're brave :X
<8> :D
<0> kyefun, You don't like --opt?
<0> sjrussel, "edge cases"?
<9> unexpected, rare situations that are hard to debug
<9> i.e., bugs
<0> ah
<9> but understandable ones
<0> I mean, I'm totally open to using FKs once someone gives me an example of where I really need it... or if I ever did run into a case. I just haven't yet.
<0> I just don't need any of InnoDB's features. So why use it?
<9> I think they're mostly to protect the DB from rogue code
<0> sjrussel, Exactly. But I don't have any.... /me knocks on wood.
<8> What I don't understand is.. why use a relational db management system, if it's not relational?
<0> It is relational.
<0> It's just not enforced at the DB level.
<12> ei, mysql doesnt have root p***word, how do i add it
<12> =
<12> ?
<0> asd, mysqladmin --help
<0> !m asd secure installation
<12> mmmm
<6> asd: Nothing found
<0> grr
<8> Then the database holds a poor design, for it hasn't even been normalized to at least 3NF
<8> I'll hold my tongue :)
<12> will, i have just arriveds to this computer in this company
<0> Shariff, FKs are a wa y for the DB to ensure the relations. It does not really affect the design of it. It affects the data integrity (as you stated).
<0> asd, mysqladmin -uroot p***word 'will_sets_my_p***words'
<8> will> FKs are a vital part of the db design process, because before you even write an application you design the database..
<0> Shariff, Ok
<9> Shariff - an FK doesn't have to be enforced by the DB to be an FK
<0> sjrussel, Heh, true! I defined a "FK" as DB enforced.
<8> sjrussel> A foreign key by definitation references another key within the database context, why would you let an external layer have that responsibility when it should be in the db layer
<9> Shariff, if you don't want to use MyISAM, don't do so
<0> Because with MySQL, I can get better speed.
<9> s/MySQL/MyISAM/
<0> Yeah...
<8> sjrussel> Who said anything about me using or not using something?
<8> will> *nods*
<9> well, you don't seem to like the lack of constraings
<0> s/constraings/constraints... oh nevermind :P
<9> you probably won't like that it (the MyISAM engine) doesn't support transactions either
<0> GASP!
<0> I was going to mention that... I don't use transactions...
Return to
#mysql
or
Go to some related
logs:
#ai
totem-xine xvid fedora
ati 2900 compiz
slackware mysql can't find host
meaning of pollsa
determine size of resulting image file
#css
#web
hulkk
#suse
|
|