| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> yeah
<0> if i want to seperate i'l hvae to do SELECT WHERE change > 0 for surcharges
<0> and < 0 for deductions
<0> the other question is, do i really want to fool with signs?
<1> i'm gonna up connection limit to 200
<2> hi jax
<0> oh no
<1> so mysqladmin shutdown ; /etc/init.d/mysql start is safer then using the stop/restart?
<2> ;-(
<2> i got mysql4 to work
<2> but not 5
<2> same problem that i had with my windows comp months ago
<3> Is that a question?
<4> Bheam: mysql, depending on configuration, may take time to shut down
<4> Bheam: if any distro-provided script decides that it is better to kill
<4> it makes a mistake, which may cost your data
<5> and data loss is bad
<0> i think 2 tables would be better
<0> and forget about the sign issue
<5> what sign issue ?
<0> well tihnk of the person who is entering the deduction / surcharge in the CMS or whatever... then he/she will select what discount / surcharge type, like SUB_TOTAL_AMOUNT and then he/she wants to enter $5 deduction...
<1> i better not shutdown mysql at peak hours then :p
<0> does he/she enter -5 or 5 ? i think this wil lead to confusion
<5> Jax: that is an interface issue
<5> it is nothing to do with the database itself
<0> so you're saying you'd make all deduction -X
<0> and surcharges X in the same table
<1> sure
<5> seems like a sensible approach to me
<0> and make something like a dropdown in the frontend Surcharge / Deduction
<0> and make sure that if Deduction is chosen, it will insert -X
<5> well the design of the interface should be based on what is convenient for people
<0> i.e -|FieldEntry|
<5> whereas the design of the database should be based on what is sensible and practical for data storage and retrieval
<5> the two are seldom the same thing
<0> well, you got a surcharge type of PAYMENT_PERCENT (2.5% addition for credit cards say)
<0> anyway, brb
<6> any solaris experts here?
<5> why not just ask the question...
<6> well.. i'm running mysqlslap on a sun T2000 ... and it is *crawling*
<5> nice
<5> do you think it will work ?
<6> on a x86-64 box is was like 100 times faster
<6> so I'm guessing something isnt write config wise
<5> oh sneaky
<5> oh
<5> sorry i thought you were trying to convince your employer of something :$
<6> I just downloaded the package for mysql's site
<7> hello all. is it possible to 'catch and view' the queries that are sent to the mysql server ?
<5> why yes, yes it is
<6> I am my own employer.. i can't convince myself of anything ;-)
<5> :P
<8> hello.. is it any reason why I update a mysql-field with that spesified as INT(15) with "200603291830", than the row suddenly changes to "2147483647" ?
<9> is that value to big for int(15)
<9> perhaps you should store it as a date?
<10> The (15) is being ignored anyways.
<10> INT (signed) is limited to 2147483647...
<10> A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.
<8> oh, i forgot about that max-value
<10> But indeed this looks like you want to use a DATETIME field... don't you?
<9> babi: but if it's not a coincidence that it looks like a date....
<8> BIGINT then..
<8> yes, should probably use date instead
<9> BIGDATE!
<10> babi: datetime, not date; you want the time, too
<8> mkey
<8> but timestamp would proably be better
<8> no?
<5> :|
<5> you do not generally want to insert values into a timestamp column
<5> that would defeat the purpose of it :P
<8> okey then
<8> datetime it is
<5> use a datetime instead
<8> but I have to seperate the values with "-" before insertion?
<8> or just YYYYMMDDHHMM?
<5> mysql understands both
<5> i never use - and : in dates when i am entering them unless there is the possibility that 0s are missing or something
<8> how fabulous
<11> what is root default p***word when first install mysql ?
<5> i don't think there is one
<12> yeah, there aint
<13> hmm what on earth is a cursor; need to look that up
<14> its a handle to traverse a result set
<15> like parsing?
<13> oh like an internal pointer?
<15> llike an array walk or something like that
<15> It sounds like one
<5> yup pretty much
<5> they are handy though
<15> Does mysql support cursors now? from what version?
<5> it is in the manual so i presume so :P
<16> how do i list all field names of a table?
<5> describe tablename
<17> what is the best way to import/transfer a mysql database from a remote server to my local mysql server?
<17> pakoo, hm, or shall I say, simplest
<5> print it onto punchcards then have someone manually install them onto the local server after sending them by courier across the planet
<4> !m pakoo mysqldump
<18> pakoo: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<17> thank you
<19> I still think the punchcard idea is better
<17> so, mysqldump --opt database_name > db_name.sql
<17> :-)
<20> punchcards?
<19> andrewbryson suggested the idea
<5> i have lots of good ideas like that :)
<5> is not my fault they were insufficiently specific with what they meant by "simplest"
<20> normal punchcards burn easily, but full-metal punchcards don't
<20> it's a perfect emdium, no moving parts!
<20> *medium
<20> in the storgae medium itself
<5> plus the cool thing about metal punchcards is that they weigh more
<5> so you are supporting the freight industry
<21> only slightly used
<5> well your name is fitting then archivist :P
<21> I must read them one day
<17> do I have to stop mysql while using mysqldump?
<5> lol no
<5> the whole point of database backup programs is that they work safely while the database is running
<17> oh ok
<5> otherwise you could just stop the database and use tar
<17> I don't want a backup, just to transfer a database to another mysql
<21> and mysqldump connects TO the server
<17> mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
<21> !perror 2
<18> System error: 2 = No such file or directory
<21> so start the server
<17> I think the server is running
<5> well you will need to find your .sock then :P
<17> how can I test if the server is indeed running?
<5> if you can connect to it it is running :P
<17> ps aux | grep mysql gives me ->
<17> root 3143 0.0 0.0 7772 1384 ? S 13:31 0:00 /bin/sh bin/safe_mysqld --defaults-file=/usr/local/mysql5.0/my.cnf --user=mysql
<17> mysql 3202 0.0 4.1 645784 85028 ? Sl 13:31 0:00 /usr/local/mysql5.0/bin/mysqld --defaults-file=/usr/local/mysql5.0/my.cnf --basedir=/usr/local/mysql5.0 --datadir=/usr/local/mysql5.0/data --user=mysql --pid-file=/usr/local/mysql5.0/data/plato.pid --skip-locking --port=3308 --socket=/tmp/mysql5.sock
<17> ooops, sorry about the long output
<5> why port 3308 ?
<5> or did they change it and noone told me ? :P
<17> what's the default?
<5> 3306 i think
<5> at least it was :P
<17> how do I specify the port 3308?
<14> --port
<17> mysqldump -u root -p --port 3308 --opt mydb > myd.sql
<17> gives me the socket error again
<21> its 3306
<5> not according to pakoo's ps :P
<21> dunno why he is overiding the default
Return to
#mysql
or
Go to some related
logs:
irssi ctcp version response custom
#web
krusader undelete
Pam Kuehling
#gentoo
www.fuck.gov
#debian
proftpd gentoo virtual user
mordorf
#linux
|
|