| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> ok
<1> Darien : here's one of the crashes from /var/log/syslog: http://hashmysql.org/paste/viewentry.php?id=1482
<0> amette: what happens if you repair the tables?
<1> Then they get repaired, everything seems ok - never the less I can't #mysqldump them and mysql crashes again some minutes later
<1> I just went into the /var/lib/mysql/DATABASE dir and did #myisamchk --recover *.MYI
<0> ok
<0> hmm
<1> yeah, "hmmm" - that's how I'm sitting in front of my monitor, too :P
<0> hehe
<0> amette: did you do that while the server was shutdown?
<1> right now it crashed again - different "client is using or hasn't closed the table properly" messages - but apart from that the same picture in syslog - mysqld-safe didn't restart it though, I had to do it manually
<1> Darien : the myisamchk ? Yes, I hope so!
<1> What's when I did it, while the server was still running (I'm not completely sure on having had it shut down always)..?
<0> well shut it down completely and then try running it
<1> And what I'm wondering, too - when doing the #mysqldump command, it says: "Can't find file: 'file.frm' (errno: 23) when using LOCK TABLES" - but the file is there - after looking at the perror 23 I decided, that it doesn't have to do anything with the file being there or not - but still it's weird..
<0> yes
<0> do you have a lot of tables/databases?
<1> Well, I know, that all this day, I have been shutting down the server before recovering - but I'll try again..
<1> Humm... not that much - it's three TikiWiki installations with not much load - a tiki has around, well, dunno - around 200 tables perhaps
<1> Ok, so I did #/etc/init.d/mysql stop - then checked with #ps -A|grep mysql - two clients still running, no server - then did #myisamchk --recover *.MYI on the mentioned databases - then #/etc/init.d/mysql start
<1> syslog says: Feb 23 23:56:18 vs242033 /etc/mysql/debian-start[29540]: Checking for crashed MySQL tables.
<1> What I think, is weird - since it was shut down regularly..
<1> ok, that's the log of the last action: http://hashmysql.org/paste/viewentry.php?id=1483
<1> it already crashed again - you wanna have that log too? ;)
<2> i have a bunch of queries i run like: select a.b,b.c from a,b,c where (1=2 or a.z=1 or a.z=229 or ... a.z=283) and c.id=a.d and c.d=283 order by c.e
<1> damn - I really don't know, what's up there :-/
<2> the or has about 30 conditions (all similar, a.z field = static value)
<2> is this a particularly resource-intensive way to run the query, and if so how should i go about it
<1> I go have a smoke - can I crank up MySQL-debug-level on debian somehow? Wanna know, if it tells, why crashes..
<3> bobnormal learn where in(a,b,c,d.....)
<3> !man in
<4> (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
<5> guys when trying to create a database using a script I am getting -- ERROR 1067 (42000) at line 10: Invalid default value for 'uid' -- any ideas
<3> the error message is pointing you
<2> archivist: thanks
<3> its faster as well
<6> can anyone help me with http://pastebin.com/569268 ? I'm thinking of going back to my old system...
<1> re - I went asking in #debian now - that issue appearing right after an #aptitude upgrade made me feel to have reason to ask there ;)
<0> amette: sorry, was doing laundry
<0> amette: any luck?
<1> yes, it seems, I'm running some unstable MySQL... I'll keep you updated
<0> hmm
<7> I have two servers, one is the existing established server, and the other is a new, superior system
<7> i'm trying to get the new system to server the files / databases of the old system
<7> It was easy to backup /var/www , but my problem now is how to backup mysql...
<7> or just transfer it to the new machine
<6> is there a better way to write this? (basically, select subscribers who have BOTH 'on' for d #10, and 'Peru' for d #4) -> SELECT DISTINCT s1.* FROM subscribers_data AS s1, subscribers_data AS s2 WHERE s1.demographic_id='10' AND s1.value = 'on' AND s2.demographic_id='4' AND s2.value = 'Peru' AND s1.subscriber_id = s2.subscriber_id;
<3> !m Silivrenion mysqldump
<4> Silivrenion: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<1> Darien : I'm running the regular stable package of MySQL apparantly - never the less the system wants to downgrade to 4.0, if I issue #aptitude install mysql-server - nothing like that happens, when I do #aptitude upgrade
<1> Hey, can I just tar up the current /var/lib/mysql and later on untar it into that location without having problems? I would like to check out, if I get those same problems with my backup (mysqldump).
<1> well, getting the same problems as now of course - but not additional problems, I mean ;)
<1> ok, most probably a very dumb question, I just realized :P
<1> But starting to doubt most things here ;)
<8> amette: Yes, you can make tar backups ***uming the database is shutdown or has no activity
<1> inviso : thanks
<9> hello!
<10> how does one set a constraint in mysql: ie: Employees.Jobs***igned must be greater than 2 but less than 10?
<0> you can set them, but they aren't enforced
<0> !man constraints
<4> (How MySQL Deals with Constraints) : http://dev.mysql.com/doc/mysql/en/Constraints.html
<0> I don't think that's it
<10> Darien: aren't enforced?
<10> Darien: then what do they do?
<0> yah
<0> they don't do anything
<0> not yet, anyway
<10> dotdotdot
<0> they're just in there for ANSI SQL compatibility
<10> Darien: lol
<10> Darien: what do you mean by "not yet"
<0> well presumably at some point in the future, they will be implemented
<0> right now you can set the restrictions, but MySQL doesn't do data validation
<10> Darien: is it difficult to do or something?
<0> no, just not as important
<0> I mean, generally speaking, your application should be doing data validation anyway
<0> so it's not nearly as important as, say, views, triggers, and so on
<10> Darien: i guess you're right...
<10> but still...
<11> braz: it's very simple
<9> k
<9> shoot
<11> braz: create a table such as: create table FOO (pid int not null auto_increment, etc, etc, primary key (pid))
<11> every time you 'insert into FOO ...', the pid will increment.
<0> or do 'CREATE TABLE foo (pid SERIAL)'
<0> which is a better idea
<0> !man numeric types
<4> (Numeric Types) : http://dev.mysql.com/doc/mysql/en/Numeric_types.html
<9> ahh
<9> so a "insert into FOO" would suffice?
<9> just that?
<11> well yeah, but look at the syntax
<0> 'SERIAL' = 'BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE'
<11> mysql.com is your best friend
<0> pid serial primary key
<11> yeah, listen to darien
<9> ahhh
<9> thanks, guys :)
<12> hello all i need some help please i can not get mysql to change the root p***word i tried using mysqladmin and i keep getting access denied
<12> its a new install
<3> !man reset root
<4> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<12> ty
<9> quick question: "null" vs, "not null"?
<0> ?
<0> NULL means it can be NULL, NOT NULL means it can't be NULL
<9> what's the difference?
<3> ?
<0> the difference is that with one, a column can be NULL, whereas with another, it can't
<3> didnt you just say that
<9> lol
<9> null as in "blank"?
<0> no
<0> as in NULL
<0> !m Braz NULL
<4> Braz: (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
<0> that's not it
<0> ffs
<9> gracias
<13> hello mysql
<13> I was wondering are there any documents relating to recommended disk configurations for mysql?
<13> What to seperate? Recommended raid levels, etc
<14> hi guys
<14> i need to upload backup.sql to the database A which has p***word word
<14> is it mysql xcat backup.sql -u a -p word database?
<0> xcat ?
<0> what the heck?
<0> mysql -u root -p database < file.sql
<14> that is to put backup.sql on to a database?
<0> yes
<0> so if the database is 'a' and the p***word is 'word'
<0> mysql -u root -pword a < file.sql
<0> or mysql -u root -p a < file.sql
<0> and it will prompt
<14> say i created a database called DATA
<14> and i want to put bakup.sql to data witch the mysql user = user and p***word = p***
<15> heh
<14> run the query on the database
<14> via terminal
<16> hi there... having a bit of trouble with mysql and php4... every now and then the mysql threads will just go nuts, like from 10 to about 99, and the server load goes from about a stable 5 to like 30/40... apache will have some threads crash with code 11, and sometimes apache becomes unusable at 100% cpu and doesn't recover
<16> im not sure if its a mysql problem, or apache/php
<16> but any input would be appreciated
<14> How do I copy or move a backup.sql to a MySQL database?
<17> AlexMike: Darien just got finished explaining it to you.
<0> ya seriously
<14> <0> mysql -u root -p database < file.sql
<14> yeah obviously
<14> correct
<9> YAY!
<14> i wrote wrong way, mysql -u root -p p***word database < file.sql
Return to
#mysql
or
Go to some related
logs:
#linux
kaffeine open recent
#css
#css
#linux
compile* iptables_nat
webcam_server Invalid argument
tdlp dhcp server
pkgsrc slackware autoconf broken
installing gtkglextmm ubuntu
|
|