| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> Either it does now or it's planned.
<1> thanks. :)
<0> Manual will tell you.
<2> In Mother Russia, Database Backs ITSELF up!
<1> seems like it is in newest 5.1 versions, but not production grade
<2> yeah, 5.1.6 on
<1> yeah, but some incompatabilities between versions
<2> both of them? :)
<1> MySQL is really turning into real database
<2> totally, heh
<3> tld: really? when?
<1> "mportant: Partitioned tables created with MySQL versions prior to 5.1.6 cannot be read by a 5.1.6 or later MySQL Server. In addition, the INFORMATION_SCHEMA.TABLES table cannot be used if such tables are present on a 5.1.6 server."
<4> where's mysqld's error log, to figure out why it's not starting up?
<0> rik, data directory. Usually /var/lib/mysql/ or /usr/local/mysql/data/
<4> and it's called?
<0> <hostname>.err
<5> hi folks; I would like to rename a column--is there a way of doing this without providing the old column definition (i.e. ALTER TABLE employees CHANGE oldcolname newcolname OLDDEFINITION) ... OR ... is there a way of getting the OLDDEFINITION; basically, I want to rename a column without requiring my calling program to have to know the old definition.
<4> ah yeah
<4> i see how i broke it
<4> any good way of downgrading a database or log format from mysql 5.0 to 4.1?
<0> Why do you want to downgrade?
<4> because 5.1 doesn't work with my application
<0> 5.1 or 5.0? Why not?
<0> It should.
<4> you're right
<4> it should
<0> Of course :)
<4> but it doesn't
<0> What is wrong?
<0> Share the secret!
<4> keeps dropping connections.
<4> to localhost
<0> Why?
<4> THAT WOULD BE MY QUESTION.
<6> you know the datetime field, is there a way to see what it is expecting? ie dd-mm-yyyyHH:MM ?
<0> Advocated, YYYY-MM-DD HH:MM:SS
<6> is that the default then?
<0> rik, What did the error log say?
<7> yes, that's default
<0> Advocated, There's no way to change it.
<7> !m Advocated date time functions
<8> Advocated: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<6> ahh, didnt realise, thanks
<7> but you can change your input to match the default
<4> the server or application?
<0> rik, Both.
<0> What app/client?
<4> Ruby on Rails.
<0> And the errors?
<4> nothing from the server
<4> just "Lost connection to MySQL Server" from the Rails log, plus which statement it was executing when it failed, which is actually "any of them"
<0> I doubt that Ruby has a problem talking to 5.0
<4> then it must be mysql that's wrong, by your logic.
<0> Possibly. How did you install MySQL?
<0> !man gone away
<8> (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<9> rik - does it seem like this problem is related to the connection timing out?
<0> Check that out. See if any applies.
<4> sudo portinstall mysql41-server
<0> 5.0 the same way?
<4> yup
<0> or 5.1?
<4> both
<4> i've tried 5.1, but that failed, so i tried 5.0 and that failed
<4> and i switched to mysql from sqlite3, which ****s even worse
<0> Ruby and MySQL on the same server?
<4> yes
<4> tailking to 127.0.0.1
<0> Try using localhost.
<4> i do.
<0> Or check your my.cnf for skip-networking
<0> (if it's enabled or not)
<4> where does that live?
<0> /etc usually.
<10> 127.0.0.1 is not always localhost in some situations...not sure about ruby though
<11> hello everyone, I've got an issue after an upgrade to 4.1.18 from 4.0.25 tho i tried to use the old p***word all my SQL databases seem to be down. does anyone know of a howto or anything that might help?
<4> 127.0.0.1 is localhost
<0> rik, Depends in what context :)
<7> !m Lawbringer upgrade 4.0 4.1
<8> Lawbringer: Nothing found
<0> In your code, do you p*** 127.0.0.1 or localhost?
<7> !m Lawbringer update 4.0 4.1
<8> Lawbringer: Nothing found
<7> damn it
<9> rik - does your client (ruby) connect to mysql at all? iow, does it perform some queries and fail on others, and if so, what's the relationship between those that work and those that don't?
<10> !man old p***word
<7> !m Lawbringer upgrading 4.0 4.1
<8> Nothing found.
<8> Lawbringer: (Upgrading from Version 4.0 to 4.1) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
<7> there
<0> !man old client
<8> (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<0> THERE WE GO
<11> shabbs thanks i'll take a gander
<7> read too while you're at it
<4> right
<0> Great way!
<4> it's a good job i don't use mysql ususally.
<4> otherwuise this might be considered destructive.
<12> select concat(NULL, "foo"); gives me NULL. How can I get sth with `foo' inside?
<4> but i'm using it because it's a better database engine than sqlite.
<11> shabbs, hmm reading.. sounds like hard work
<7> sth?
<12> SomeTHing
<7> Lawbringer: it's actually not really, just make sure you upgrade the priv tables and dump/reload the data rather than move the raw files between servers
<7> Wulf4: select 'foo'?
<12> shabbs: NULL is actually a column of my table which might be null and might contain a value
<7> uhh
<7> NULL is a reserved word
<0> lol
<7> other than that, check out IFNULL()
<7> !man ifnull
<8> (Control Flow Functions) : http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
<0> rik, That might not fix a problem if you have an existing my.cnf.
<0> rik, Did you even CHECK my.cnf for skip-networking?
<4> yes
<4> i didn't have a my.conf
<4> cnf, even
<4> :)
<12> shabbs: thanks
<0> There are other locations one could be, depending on your install.
<0> /etc/mysql/ for example...
<7> or even ~/my.cnf
<4> well, i looked at my install, and it was supposed to live in my /var/db/mysql directory, with everything else. it didn't exist there
<13> hola folks. what's the flag on mysqldump so it outputs commands to create the dumped database? I'm not seeing it. thanks.
<4> i don't have a my.cnf. i checked.
<7> :D but that's for client
<0> shabbs, Wouldn't be there for server settings.
<0> rik, If you say...
<4> i say
<0> Too late anyways!
<9> my.cnf can also reside inside the data directory (ie, /var/lib/mysql/ or /usr/local/mysql/data/)
<4> i'm not stupid, i just don't like this engine :)
<4> fyi, on FreeBSD, the data directory is /var/db/mysql
<0> That's FreeBSD's fault.
<4> and the startup script says that my.cnf should live in /var/db/mysql too
<7> roue: it automatically adds create database
<7> roue: unless you specify -n or --no-create-db
<13> shabbs I'm doing mysqldump -u user -p -h localhost databasename > databasename.out and it doesn't seem to be.
<13> let me double check.
<0> !m roue mysqldump
<8> roue: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<13> shabbs yup, the dumpfile just starts with the table creation.
<7> what version?
<13> 4.1
<13> actually, that's not true. it's 3.23
<0> heh
Return to
#mysql
or
Go to some related
logs:
#debian
ERROR writing user file (Operation not permitted)
xdriinfo ubuntu feisty libGL is too old.
#physics
ubunutu refresh rate monitor
#perl
WYSIWOD emacs
update lspci
opensuse intel d945
qdvdauthor breezy
|
|