| |
| |
| |
|
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
Comments:
<0> in noob speak
<1> is port 3306 open between the 2?
<1> ie can you get to the other server just by doing mysql -uuser -p -hotherserverhost
<0> how do I tell (..struggling now..;-)
<2> is there any way to undo a truncate ?
<1> test34: restore from a backup
<3> test34: lol
<3> rollback!
<2> shabbs, ok that answer my question I guess
<4> hello, How do i active in mysql the tables innodb ?
<1> test34: or as winmutt said rollback if you're using transactions
<3> test34: i suggest using db's that support transactions
<5> damian: telnet destinationhostname 3306 first
<3> kuki: alter table blah engine=innodb;
<6> hi
<1> welp, gotta run, laters
<5> hi flopp years
<6> how can I ask the bot info on auto_icrement ?
<2> MyISAM support transactions ?
<5> !tell floppyears about auto_increment
<7> But I don't know a thing about that.
<3> innodb supports transactions
<5> it doesn't know anything about em
<3> myisam is for excel users
<3> floppyears: what do you need to know avout auto_inc?
<5> heh. no
<2> ok thanks winmutt
<3> mysql <5 myisam is for excel users
<8> does mysql have a problem with importing large doubles from a mysqldump?
<5> winmutt: again, no :)
<3> alphablue: why not?
<3> is there a functional difference?
<5> cuz sometimes myisam is faster than innodb for what you wanna do
<3> sure its faster
<0> alphablue: 3306 is open
<3> thats because it doesnt do very much
<5> it's a lot faster than excel..
<2> winmutt, well it does everything I need except Rollback which I dont really need
<5> and handles large amounts of data without the overhead of innodb
<6> winmutt: just when it would skip values and such, or just general info on it.
<5> floppy: it'll never skip values.. but it also won't "backfill"
<6> !tell floppyears auto increment
<7> Could you be a little more clear?
<6> !tell floppyears "auto increment"
<7> Could you be a little more clear?
<6> !tell floppyears increment
<7> Could you be a little more clear?
<5> http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
<6> alphablue: thanks
<3> test34: myisam does not do fk
<5> floppy: when i in doubt, http://dev.mysql.com/feature
<3> without fk how can you have a "relational" database?
<5> oh boy
<3> without fk you have a "maybe relational" db
<5> do you always need a "relational" db ?
<9> yes to store grandad in
<5> lol
<6> thanks
<6> alphablue: thanks a lot for the linkies
<5> np
<3> you dont always need a relational database
<3> if you are doing simple things
<3> simple things are for simpletons
<3> :)
<5> and quite often you can combine simple things to do complex things
<3> alphablue: when you do that then they have relations :)
<2> winmutt you can code the relations yourself too
<5> without fk contraints
<10> I've got sunshine on a cloudy day.
<3> relying on application code to handle constraints is poor at best
<3> bad security and to much work
<5> winmutt: if you find lack of fk and transactions "simpleton" then it's your choice i guess.
<9> relations are a pain so i am old free and single
<5> sometimes contraints are constraints.. and not necessary
<3> to much german blood in me not to be a data nazi
<3> we are good at counting
<3> and being anal
<5> german.. nazi ..
<5> then you'll hate the code i work on. all it does is count
<3> count what?
<5> stats
<3> oh
<5> when you go to cnn, i'm counting you
<3> heh
<3> u work @ cnn?
<5> no
<5> i work for the company they use to track their stats
<3> i know i was wondering what your answer would be
<3> u in atlanta?
<4> [winmutt] How do i active in mysql the tables innodb ?
<5> no, i'm in san antonio, tx
<3> kuki: alter table tablename engine=innodb
<3> make sure skip-innodb is not set in you config
<3> alphablue: ah well you and i proably know people in common
<5> san antonio is a pretty big town..
<11> and then watch everything sloooowww ddooooowwwwwnnnnn
<4> [winmutt] i have that put in the my.cnf of my debian its ?
<3> kuki: what is your native language?
<3> alpha; i dont know anyone in san antonio, but I know half the staff at CNNi and IT support for it
<3> and i work across the st from cnn
<3> :)
<12> does mysql 4.1.10 support union, delete join and multi select (select within select) statements?
<12> Im on mysql 3, and it doesnt support them
<12> I want to know if my new host will meet my needs
<13> SELECT access FROM groups_to_products WHERE customers_group_id =13 AND products_id =28 LIMIT 0 , 30 gives me 1 number in phpmyadmin but I cant recreate it in my php script :s
<4> [winmutt] i speak spanish
<5> brb cable guy is here
<4> my english is very bad :)
<3> kuki:cercirese de saltan -innodb no est en sus config
<3> so is my spanish but babel fish is here to help :)
<4> thank you :)
<5> winmutt: i doubt i'd know you then.. i don't know anyone in IT at CNN
<3> kuki: usted est consiguiendo un error?
<4> [winmutt] the skip-innodb doesn't in my.cnf
<3> alphablue : mostly ppl in CNNi
<4> [winmutt] yes
<3> what is the error
<5> cnn is our customer, along with aol, ebay and msn..
<5> check your cookies for 2o7.net
<4> mi error es las tablas con el tipo innodb estan en uso
<4> y no funcionan
<3> alphablue: and you dont ever have to talk to ppl for support?
<4> [winmutt] do you understand me ?
<3> cul es el error?
<4> adslayud_adslayuda.votos_votaciones repair error Can't open file: 'votos_votaciones.InnoDB'. (errno...
<3> corte y goma el error exacto
<4> ok
<3> whats the errno
<4> wait moment please
<4> error Can't open file: 'votos_votaciones.InnoDB'. (errno...
<3> por qu est intentando reparar? qu versin del mysql es sta?
<14> can someone take a look at my code: http://www.hashmysql.org/paste/viewentry.php?id=1515
<4> [winmutt] para que yo pueda ver el error
<5> winmutt: no we have customer service for that
<9> kuki the errno is?
<14> it tells me I have an syntax error near 'INTEGER'
<3> kuki: show innodb status;
<14> but I can't find the problem... everything looks just fine
<4> my version of mysql is 4.0.24_Debian-10sarge1-log
<3> kuki: upgrade to 4.1
<4> have_innodb | YES
<15> we need the error numbe
<15> r
<15> which you didn't paste
<15> paste the whole error
<3> el mysql 4.0.x est quebrado, mejora a 4.1 su establo en debian
<4> con apt-get update mysql ?
<14> Darien, my error number?
<15> no
Return to
#mysql
or
Go to some related
logs:
ubuntu cdrom must specify the filesystem type
install madwifi using yum
openser chroot
delivered to command: procmail -a $EXTENSION
gaim amarok
#debian
Xinerama Fluxbox Maximize
NutStation.Com
xorg.conf xtest
#awk
|
|