CheapWebHosting.co.nz

Domain Search | www. .com .net .org .nz Check ALL

Is it ok to have a whole lot of stuff in one DB? Like lots of things for lots of different apps? Or would performance be better with stuff in separate DBs?

no real difference for performance

and you can reffernce tables in other databases if you need to
dbname.table

Hello folks

Dont forget the bots!

old_passwords="YES" where do I set this varilable in /etc/my.cnf
Please point me to the manual article if any that relates to it

!man old client

see http://dev.mysql.com/doc/refman/5.0/en/old-client.html

http://dev.mysql.com/doc/refman/4.1/en/mysql-cluster-config-file.html
oops
that's the cluster config file
Is there a manual section that covers my.cnf?

hi with mysqladmin status, what period is the 'queries per second avg' over?
is it since the server host started? Or the last day..? hour?

http://dev.mysql.com/doc/refman/4.1/en/using-system-variables.html - aha!

ah life of server... that's not all that useful then

Is Innodb Hot Backup worth the money? Or can that be achieved with other third party scripts?

How do I set old_passwords=on in /etc/my.cnf?

= 1
or just leave that out, and just 'old_passwords'

so I just put set old_passwords in /etc/my.cnf?
6 [ERROR] /usr/local/libexec/mysqld: unknown option '--set
6 mysqld
this is what I get when I put set old_passwords in /etc/my.cnf

SQL select table_schema,table_name from information_schema.views failed : Got error 28 from storage engine
i get this when trying to access mysql hosting from webmin
there is plenty of space left on the server

er, without set

it is only a week old

'old_passwords'

Works now

any idea what is happening here?
no one?

What does "perror 28" tell you?

!perror 28

No space left on device

yes
but there is plenty of space left

So check your disk space in the data directory

like i said

well, the storage engine believes differently

are you on a shared hosting sevice

nope

quota?

dedicated

Maybe using a temporary directory?

the strange thing is
i get the error from webmin
but i have sites running
and they are using mysql without errors

hmm

clare10billion, the tempdir could be on a different device/quota

using 1% of home, 2% var, 15% usr
how do i find out where the tempdir is?
there is practically nothing in /tmp for example

enviroment variable TEMP

and see in my.cnf

okay in my.cf
tmpdir = /tmp
there is maybe 1mb in /tmp

hello guys. I'm just starting to learn mySQL so this maybe a dumb question, please be gentle :P
I have to insert multiple row into table A with values (x, y, z), where y & z are constant and x is taken from table B.
How do I go about doing that?

insert table(fields) select static,static,field from table

the static hosting values go into the select? hm... curious :P

yes, they do

heh afternoon shift

somebody has to pick up your slack

hehe
more interruptions at work than irc today

thanks a lot, that did it

if I didn't want to help, I would not

maybe you don't want to help, maybe you want to create mass confusion

does anyone know what's more performant wrt INSERT's? InnoDB or MyISAM?
looks like InnoDB wins in our case, but I do not understand why. I just thought that InnoDB were the more feature blown DB type

hi! how many concurrent connections?
at the same time?

if INSERTs only, then myisam is much faster

but for a mixture innodb does row locks so faster on inserts

how do i delete a database host ?

drop database;

drop dbname

how do i list all the dbs i have access to?

show grants;

exit

jbalint:

I'm having some problems with my MyASSql server

does mysqls timestamp required a default value? or you can change that
?

if i do mysqlbinlog mysqldb.* will that go through them in the right order ?
they are machinename.000001 etc

it's myassql not mysql!

[-Vibe27M-]: doesn't require a default, but depending on what version you have it might have default behaviour

I can group by multiple columns right ?

yup

Alright and also how can I select certain columns from a table before I alias them . . . SELECT t.title_id, t.description FROM titles t JOIN title_categories tc
I use the t and tc alias' before I define them. Is this legal?

yes
you're also selecting from a table before you say which table...

touche
thanks.

np

hi
is it possible to use the replication facilities of php mysql web hosting to keep a consistent mirror of a specific _table_

yes
replicate-do-table

usually just one, but up to 150 inserts per second
which is quite fine with InnoDB, but we try to optimize wrt speed, and that's why we considered using MyISAM instead, as we don't need any of the features (like constraints) of InnoDB

hello

as you have a single connection, MyISAM's table-level locking is not an issue;
and InnoDB's logging should slow it down compared to MyISAM, so in theory,
MyISAM could be tuned to perform better.
Maybe some buffer size could help?
like key_buffer_size?

hm
I gonna take a closer look at it.
I assume increasing this value would help. let's see

How can I find all duplicate fields based on a field? (i.e., a duplicate is indicated by having two records sharing the same value on this field)

dupes

find them with select count(dupefield) as qty,otherfields from table group by dupefield having qty 1

trapni, doing batch/multiple inserts will speed things enormously eg 10 times for me with 3 indexes

the_wench, wow thanks!
works like a charm

what do you mean by batch/multiple inserts?

moving the COUNT() to HAVING seem to have worked too
so now I can use DELETE ...

hello guys
somebody knows a way to recover data of a mysql db with only the data files from /var/lib/mysql ?

trapni sorry I under quoted the speedup 27 per sec to 2886 per sec insert into blah values (1,2,3),(1,2,3)............
trapni I build the insert string till near max packet size then send

aaah
thx
and what bufsize do you choose?
(containing what number of inserts in average?)

didnt bother changing it

aha

dunno its under program control
varies

install the same version of php mysql hosting and set up the directory structure exactly like it was. But next time please use mysqldump to make backups

i was not able to use it that's why
so i saved what i can

so something broke and THEN you tried to save whatever you could?

yup the whole system

no hope for some people

thats why you make regular backups BEFORE things break

yup

CapNemo, on that quality note, how do you know its broken

Boo! Data files are fine for backups

archivist, the system was not booting up
we had to change the hardware
and the disk as well ...

well ok. but trying to salvage the data files after the system refuses to boot is still... "sub-optimal"
well ok. but trying to salvage the data files after the system refuses to boot is still... "sub-optimal"

so that was a fun migration

make sure the my.cnf matches for innodb to work properly

I'm currently working to implement a configurable option backup_time_prior_to_failure. This allows the user to decide when to run backups relative to failures. This is much more convenient than just running backups willy-nilly. No one likes that approach.

sweet! Is that set for inclusion in 5.1 or 6.0?!

I say it should be a patch for 5.0

witch crystal ball mtbf guessing module is nearly ready then yay

mmm nice it works ! nice copy the directory

Not sure yet. I think marketing handles development schedules.

so is there a reason there is an XML export option but not an XML import option?

gonna be a big patch... have to build in a time machine and such

shabbs from the xml I have seen yes

:P
well it seems pretty straightforward to me

erm does it

mysqldumpdatabasetable_schema/table_schematable_datarowfield/field/row/table_data/database/mysqldump
:P
is docs an actual xml dump?

hell no
but its xml

ok, lemme rephrase my original question then
why can I export in XML if I can't import that same file back in as XML?
I mean, all you have to do is define the DTD you're going to use and verify the import file against it before you do anything. If it fails, it's not a valid import file

is there anyway do run 2 mysql servers over shared gfs storage?

yes but you have to read all 300 gig and test prior to insert

so?

shabbs write an importer

give me a DTD

doesnt an xml dump give you one
Ive never used it

you can generate one in certain IDEs, but if the dump isn't complete you don't get the complete DTD (only whats in the file)

nope, an xml file sin't self validating beyond simple XML host structures

pbro, I know reading them is fun as its how the bot gets its index terms

what monitoring tools would you guys recommend for mysql 5.x?

mysql network

hehe

ok, how about a tool that helps with performance tuning?
ok, what books do you recommend
what is shabbs?

I use mysqlreport, slow query log...

I thought nils_ used beer

nope
that's called abuse

shabbs

CEO of n00b Studios

the foreign key error reporting sucks

is ~2 tmp tables created per second 'bad'?

i did wget hackmysql.com/scripts/mysqlreport, how do i install it?

ubuntu-rocks: sh mysqlreport
there's no install though

22: use: not found
23: Syntax error: "(" unexpected

ok, perl mysqlreport
sorry

ok, got an error message, i guess i just need to pass it proper parameters

probably

hi folks

Dont forget the bots

trivial question for ya-- if a tinyint is a 1-byte number, why is it represented as tinyint(3) ?

zerofill

http://hashmysql.org/index.php?title=Zerofill

a number in parens for an int has nothing to do with size or storage. It refers to leading zero padding when you use zerofill.

aah.
cool, thanks

i have a design question - if we have tables with the following structure (all one to many) parent, child, grandchild, greatgrandchild. In the greatgrandchild should i store the child_id and parent_id (we have to store the grandchild_id). Or should i use joins all the way to get information from the parent table from the greatgrandchild table

I have apache / mysql on the same router and trying to connect yields Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (111)

mysql is running and listening on /opt/lampp/var/mysql/mysql.sock?
no chroot in place anywhere?

it's running
no chroot either

leaves the other half of my question.
(first question)

!wench learn zerofill is The optionally defined number after an INT data type represents the display width when used in conjunction with ZEROFILL. Please refer to: http://hashmysql.org/index.php?title=Zerofill

I have learnt zerofill is The optionally defined number after an INT data type represents the display width when used in conjunction with ZEROFILL. Please refer to: http://hashmysql.org/index.php?title=Zerofill

listening I don't know

well maybe you should check that?

how would I do so?

netstat -l --unix

yes
It's listening

hmm strange, well error code would have been 2 otherwise, not 111

!perror 111

Connection refused

too many connections maybe

I just set it up though
hmm

does the command line client work?

yeah

i'm looking at the output of mysqlreport, the mysqlreportguide mentions write ratio but i only see write hit, is that the same thing?
same for read ratio,i only have read hit

what area?

key, line 5 and line 6

ah ok
hm it says write ratio and read ratio on my host...

table_b (1,1) , is it better to make one or two select query ? won't the re-itteration of table a while fetching to get next table_b slow anything a bit ?

i have mysqlreport v3.2 may 26 2007

mysqlreport v2.5 Sep 1 2006
classic edition

the docs i'm looking at should be for v3.2 but i see it mention 3.0a
i think the docs are a tad outdated

It really does
))

what lame

ubuntu-sucks - what os do you prefer?

proprietaries

Solaris

^^

yeah, that's pretty nice but i don't have the $$$ for the hardware! we run a tad of that here though, i've read it scales very well

Well.. If you code some more
I mean.. If you can code at all

is there a side by side comparison of features for sql databases ?

you can make the money

you don't need the hardware.
solaris also runs on x86

ubuntu-sucks - are you running solaris on sun hardware or intel?

intel.. for the time being

nils - does it perform the same?

ubuntu-rocks: hard to compare.

i'll chalk it up to a future project to intall solaris on an intel box. i only have a ultra 10 box to play with on the sun side of things

host 192.168.0.7 is not allowed to connect to this mysql server?

I thought you were using the unix domain socket?

I just threw in the local IP and it gave me that
frustrating

indeed

www.linuxsucks.org

well
I won't expect any considerable input from a page with such a domain

Is ubuntu-sucks trolling?

what a crappy page

What did you expect?

oh well...

I think that web page is awesome, it demonstrates how clueless the competition is... thanks!

it demonstrates that you don't need to go through all the dependency hell and compilation, when you can keep it simple by using Windows

I'm not going to reply to that

I know ... you don't have arguments against it...

I wasn't talking to you

you don't have to go through the compilation
tha'ts gentoo
kubuntu works for me without compiling anything
and if you say windows doesn't have dll hell, obviously you've never written an application for windows
so meh

well.. I don't remember
the last time
I had to download a dll
in order to do something
You just simply, download the file, execute it, install it.. and you're good to go, no hassle
no command line.. no nothing
and you don't have to worry if your sister logs in as root

unbuntu-sucks: I just loaded and go, click on software I want, play it all. No virus, no extra software to try to plug the wholes, no 'buy the new version or your stuff won't work'. Now go away, you are in the wrong place and are only chatting to hear yourself.

yeah, and how many times has your 'new' application written over a dll that was already there being used by an old program which effectively killed your old program?

#windows is the place for you friend.

ubuntu-sucks: no, you don't have to worry about your sister logging in as root, but you have to worry about her accidentally dragging the entire windows tree into Cdownloads\

fortunately.. I don't have a sister

or saying "ooooh, Cwindows\whatever.dll" I don't need that!

so I don't have to worry about that

hi guys how can i do checks in mysql like the checks in sqlserver

ubuntu-sucks: plus if you let your sister have your root password you deserve it

Oh yeah.. and I don't have to worry about my sister deleting a whole directory without being asked even a confirmation message

why even have such silly conversations. If you like chocolate then eat chocolate, if you like vanilla then have vanilla. you can't possibly convince anywhere here that your flavor should be theirs. Please go to #windows where you can be productive.

You're going to have to define what a "check" is...

i want to do a `desc int NOT NULL CHECK( desc =100 and desc =0)

Oh that kind of check

a trigger most likely
a before insert, before update trigger

ok thnajks

yay!
I'm a winnarr!

yo

That's just wrong...

lol

threnody++

Thank you very much. I'll be here till Saturday. Try the veal.

courtesy of the establishment?
sounds... interesting

hello

spaghettios and popcorn!

I hate spaghettios

is it possible to delete from table where name= a regex ?

on other operating systems the default table type is MyISAM. However, even the InnoDB table type permits storage of values that exceed the data range; some view this as violating the Integrity constraint of ACID. - WHY?

!m Zmanu rlike

Zmanu see http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html

thanks

that question makes no sense. why what? no to mention the first part of the question is irrelevant
oh, and which data type allows you to exceed its range?

Strict mode?

now that I think about it, that question looks like SPAM

na

the wikipedia article states, that the default table on mysql is MyISAM

used to be

What happens when you insert 500 into a TINYINT?

on most os except windows

it's been innodb since 4.1 iirc

MySQL makes not claims that MyISAM is ACID compliant.

however, for MySQL to be ACID complaint (according to wikipedia) you need to be using the InnoDB
so, why isn't MySQL ACID complaint ?

It is, when you use InnoDB

what is special about ACID
other than it will kill you

maybe you should figure out what ACID stands for first
then ask silly questions

heh. Use wikipedia and find out what ACID stands for

Wikipedia can be wrong as well

Never!
It's MySQL powered. It cannot be wrong.

it said "Out of range value adjusted for column 'xx' at row 1", but no insertion took place

actually, i'm not asking silly questions. after all, a question is asked because the knowledge is not there yet
so, no question is really silly

Do you have strict mode on?

well it's pointless to ask 'how does a hyperactivation-enabled gyration motor work' if you don't know what it is to begin with

shabbs left hand or right hand rotation

I don't know, how do I find out?

Are you serious?

yes, I don't think it's enabled :P

peeps keep telling me that this other db is better,, that mysql is not good to learn on, blah blah blah. but nobody can give me a definitive answer as to why mysql is less ideal. so i am left to peeps opinions when making a choice

it's personal preference

What's better, Toyota or Honda? Chevy or Ford? Black or blue?

there are advantages and disadvantages to each

*sigh*, that is exactly what i mean

grilled cheese is better than popcorn

Go to a book store, look at some database books. Pick the book that you like the best.
book

http://www.kitebird.com/mysql-book

actually, a black background and black plastic monitor is better than a ivory one with a colored background
and there are good reasons for it

But it doesn't match my living room!

I happen to have a black monitor with a black background and I love it
but that's not to say my mom would love it

Hi folks - i'm having trouble thinking of the proper way to execute this query. Table1 contains columns: [id, name] , Table2 contains columns [talker_id, listener_id] where both these id's reference Table1.id . My query needs to return rows containing the names, not the ids of Table2..and i'm not sure how to do the JOIN. Any suggestions?

Any uk MySQL developers around?

Sounds like a homework question!

crazyal, whats location got to do with it

so it's more than personal prefernce ... bleh, this is disintegrating into a mess. maybee that is why the other sql db is better. i am not looking for your logic, but a good reason why over and over peeps say, learn on sql x rather than mysql. there has to be a reason for their bias.

Join to table1 twice
Use an alias
If no one helps you out, ping me. Busy at the moment.

Protect the innocent.

well when you look for consultants location can play a factor

SELECT a.name, b.name FROM table1 c JOIN table2 a ON c.talker_id = a.id JOIN table2 b ON c.listener_id = b.id;

thanks

shabbs, if you let your mom use a ivroy monitor and a colored background your are doing your mother a dis service, black does not cause the cones to fire as often
in your eye, saving your eye from fatigue and eventually burnout

crazyal, /me in in uk
is in

thanks!

oh cool, have you worked with or setup MySQL clusters before?

no

ah okay, I'm looking into MySQL clustering for a startup, it's giving me a headache

just ask

well I don't know what 'other db' you're talking about because you won't give specifics, and I'm not going to go into detailed differences between mysql and all other dbs (or any db for that matter). If you want to use other db, use other db. Plenty of people use mysql both in small and large businesses and at home that *they* must feel it has something to offer

i did, and bleh

I will thanks but nothing specific at the moment. I'm confident I can set it up, but I need to be in touch with people who can help if things go wrong. If you see what I mean

mysql is used in a lot of software programs. i suspect it is because of ease

enterprise users don't necessarily need ease. they have the resources for 'not easy', but still choose mysql

crazyal, well often ppl in here and if needs be mysql.co allways can help

hi

yeah thanks, seems like there are alot of knowledgeable people about

crazyal, mysql consultants often work at a distance
which gives you a real 24hr cover if needs be

I don't mind distance during development but I do like at least some face to face meetings

video conference :P

yeah video conference :-D

a question about optimisation, i have a big table members, i do a lot of join between this table and another one, i have to store some information (text data) per member, should i add these fields to the table members, or should i create another table members_data with this fields ?
cause i do a lot of access on members, and very very few on members_data
hence the idea to separate data, even if the relation between these 2 tables is 1-1
anyone ?

that type of partitioning sounds like a good idea

you're sure Shrews ? mysql is not designed to avoid those kind of tricks?

that is not partitioning, that is denormalizing

the members_data table idea is called vertical partitioning... article on it somewhere... /me looks
http://dev.mysql.com/tech-resources/articles/performance-partitioning.html

thanks Shrews i read that

technically though, if you put it in the members table but never select it or do selects with it, there wouldn't be much of a performance hit, correct?

you reduce your avg row size. if you can move all variable length columns out, you get even better join performance.

you thought that shabbs, but i have a doubt

ic

you have a good level with mysql Shrews ?
enough to be sure of what you're speaking about Shrews ?

i've been around

cause my question is important for my db structure
very important

yeah, so wear protection
:P

it is easy to test the effect it will have yourself
each situation is different

If it's so important, why listen to anonymous people on the Internet? Hire a professional consultant!

seekwill++

or mysql network

op yourself Shrews and i'll trust you
partitioning is for mysql 5.1 only no ?
ok i trust you

Having ops is not the greatest indicator of knowledge

of course not
but a better indicator than no op at all

heh

splitting text fields out in myisam can be good, for InnoDB, doesn't really matter

Actually, not at all. Many MySQL employees do not have "ops" who are highly skilled.

just means ops have better 'people skills'

what field do I change on a primary key index so that it starts at a specific number?

Wishful thinking?
auto_increment might be the term you're looking for.
There's nothing special about a primary key that would provide for a sequence of values.

the article is verty interesting

i don't think the author has ops, though

so he's a looser
i'm one also snif
mysql dev comes here sometimes ?
cause i'm so tired to find bugs and bugs on views...
you think mysql 5.1 will support vertical partitioning ? or it"s technicaly impossible ?

http://dev.mysql.com/doc/refman/5.1/en/partitioning.html

i'm in
There are not at this time any plans to introduce vertical partitioning into MySQL 5.1.

Query OK, 388260 rows affected (1 hour 5 min 29.24 sec)
lol

the .24 secs made all the difference

indeed
oh
I am so stupid.
well...
I should have committed

oops

is there anything in mysql configuration that might cause slow query responses from one win32 box to another?
perhaps some sort of dns type thing?

when is it slow?

for every query
I am using the gui query browser and once I get connected to the remote mysql server, and run queries, they are sluggish
different subnets btw

well, there is reverse dns lookup, but that should only be looking at it during logon

well, the IP changed and it went on a utm
firewall device
but it is wide open for testing purposes
the sql box doesn't have a public ip also

are the queries slow if you run them from the same box?

let me check
they are lightning fast
locally

hm

so, it isn't a grant issue because I can get it and query

in mysql, how would you query before or after a DATE field?

necos that's confusing wording, to me anyway
any other thoughts?
I appreciate them so far
I've been beating my head against this for several hours

i mean to say,how would i query a DATE field to search for things after a certain or before a certain date
gah, stupid lag

!m Necos date and time functions

Necos see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

yeah that I dont know, necos
there you have it

and = (= = also)

I'm trying to create a table for holding passwords and a username what would the command be?

it's hard to say. can't think of anything specific in mysql that would do that
you could try disabling hostname lookups
not sure if that would solve your problem or not

well, i'd suggest Monie, not using the passwords, but maybe a md5sum of the password

!m Monie create table

Monie see http://dev.mysql.com/doc/refman/5.0/en/create-table.html

2007-06-01 would select all rows with dates after june 1st... at least, that's how the docs read to me

How do import an sql file in cli?
phpmyadmin won't allow me to upload it

mysql -uUSER -pPASSWD schema file.sql

how would I go about disabling lookups?

ty

nevermind

we have 7 webservers, each with a mysql replication slave. our application only reads from the database doesnt write. 3 of the servers have been experiencing an odd issue. Randomly (normally during a high traffic period) it just stops accepting connections and returns "Resource temporarily unavailable". Any input on this?

how do i specify db?
-d?

mysql --help
Apache/Web problem?

i would suspect you're running out of file descriptors... are these webservers running php/perl/etc apps?

I think it's skip-name-resolve
put it in your my.cnf

did anyone in here get an private message from the user noesc offering jobs ?

I already told you I msg'd people in here

damn it can't drop this fucking foreign key

I am asking how many in here got your message
you have many pm's - please get back to them

i can tell you approx 20

20 people is spam

Necos yes they are running php. That was my suspicion, however we modified our balancing application to send less requests to these 3 servers (1/4 of the normal traffic the other servers sustain) and we still get it.

my report stands

all servers have the exact files and configs

!man skip-name-resolve

see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

hrm, interesting
it points it at that page, but it doesn't appear on that page

could someone kindly tell me how to call the numeric equivalent of a column
maybe I have to eval it?

numeric equivalent?

ah, so the dates do work as i expect them to
cool!

you have a varchar/char column that contains a numeric value and you want to read it as a number?
field + 0 or CAST()

no, the name of the column isn't numeric

I didn't say the name, I said the value in the column

I want to call it from a numeric value so the end user can't see the column name
oh

the column index?
why don't you just alias the column then?

yeah, sorry
oh, i didn't know I could

noesc, dude WTF

field1 as SOMETHING_I_WANT_YOU_TO_SEE

we dont do that shit like that, you need a DBA go monster it

ah ok! thanks!

there is a job thread on mysql.com

We do monster and all of the other sites.
shabbs: thanks for the info

ha ha
let me guess - job offer ?

ikonia yea

i've logged a complaint - just random spam

if he wants to add 25% to my current pay with 100% paid benefits and moving expenses
sure
lol

not very loyal

do we know why skip-name-resolve doesn't show on the system variables page?
full paid benefits? thought I was the only one that was that lucky

Cleveland to Santa Monica
i get 100% paid insurance

aye, same. only health though

got health, dental, eye, life
and it is the good shit too

how can i specify an INT that's only 4 bytes long
can i do INT(4)

no

or do i only have the standard preset numeric types to choose from?

preset

that will make it 4 digits long

i want to use an INT column for ip addresses
so i only want 4 bytes

tchmnkyz: what's your current salary?

could i just use DECIMAL(4) then instead?

4 is just for the display

your gona need to do like varchar(15)

tchmnkyz, no i'm not
!man inet_aton

see http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html

tchmnkyz, see that
so then, i guess my best bet would be SMALLINT

abstrakt ok
sorry
thought you were just putting it in normal

INT is only 4 bytes

i would say yes to that

!man storage requ

see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

!man numeric-types

see http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

seekwill, oh, ok so 11 digits = 4 bytes...
k, cuz the manual says it recommends using INT UNSIGNED

Exactly

unsigned = 11

+ 10

right

ouch

NICE
he is probably one of the offers i got from monster over the past few weeks
i had 3 job offers for DBA this week from it

lol yea
I hear that tchmnkyz :P

they want to offer like 25k/year 80/20 benefits and no retirement

hahaha I know right?

and the 80/20 is they pay 20 you pay 80

lol!
yea, well there are -plenty- of good jobs around
escpially in Silicon Valley

who offers 25k? heh

i am in cleveland ohio and found a better offer then that
and cleveland is fucked for jobs right now

I started at 25K 3 years ago :/

???????

but at least I found a job

25k???
holy shit dude

hey, I'm up to 42 + bonus in 3 years so it ain't bad

i made 25k/year working in a Data center in ohio

where in the heck do you live?

west michigan

we are starting at 80-100+

we're more fucked than cleveland

i am doing 45 now

yea, I only except 100+ jobs :P

lol

I'm serious :P

that's accept :P
and I'd accept 100+ jobs
but no one's offering

in cleveland to get 100k/year you need to be blowing the president of the company

plenty are

not around here :P

yea, well NYC/Cali they are :P

at least not for anything I'm qualified for

shabbs, I am trying to

tell you what, you pay me 100+ /year, let me work out of my home here in michigan and we got a deal

excuse me

that makes 2 of us

you're excused

thanks. I feel much better now

welcome

what did you rip ass?

shabbs: I wouldn't be living in California myself if that was possible.

why couldn't someone work out of their home?

exactly. if it was just me, I'd probably move, but I got a family so... not that easy

sounds like my job description

you would think 100k companies would have a no lol policy

a no lol policy?

yeah I would fire anyone who used "lol"

noesc you line me up 100k/year | apartment that accepts Large dogs and i can be there

I would be fired day 1
I used lmfao

I noticed!

they would sue me

TaSo: too much live interaction with depts I suppose

me too

tchmnkyz: send me a resume and if the ceo likes it, it's 100% possible

we're looking into options for databases for our MMO game server and we're looking into mySQL and PostgreSQL, but I can't find any smart-ish performance testing..

I use smileys with the cute customer service chick at my company, but that's about it

pm me the email addy

haha large dogs, nice

English Mastif

can someone point me at something that'll help me test the databases and see which fits better?

I have a husky

nice

our old neighbors have an english mastiff

what do you do at the job, and what does the job entail, what kinda company is it for

those are the big looking pit bulls eh?

there are a couple, but your best bet is to write up scripts that simulate your data
and then hammer the databases

just don't forget, moving to cali on a 100K salary is the same as staying in cleveland on a 45K salary :P

TaSo: we're the only high risk payment processor on the net, processing ccs for over 250,000 websites, 100% linux driven, using mysql

well, I guess I"m going to start a high risk payment company

are you guys PCI complaint? :P
compliant too

thanks for the advice, going to get on the phone with a couple Venture Capitalists now

where i work now is

shabbs: actually, coming from Texas mysql, I always tell people to add 20k to what they currently make to account for california. The only thing here that's more expensive than my home state is rent

and it is a pain in the ass

s/mysql/myself

same, we just finished our first year audit in december

uhmm... and the fact that you need a car? :P

TaSo, is it anything like smart to test them in a system that will NOT be the one they'll be running in? can I expect the results to be useful if only for comparison?

shabbs: yes, I run the cpi compliance here
s/cpi/pci

oh yea noesc you need to add that to your offer... New 08 Impreza
lol

dude

and they just added more strict rules for pci audits in CA.

at least get a honda

TaSo: I don't drive, I built and electric scooter.

heh, I drive 65 miles each way
uphill in both directions
in the snow, year-round

:[

well ok the last part isn't true
snow in winter, construction in summer
the only two seasons here

I can't get mysql to work over my lan still, Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (111)

Don't do that again.

@perror 111
!perror 111

Connection refused

Sockets don't work over LANs

*unix sockets don't work over lans

So how can you run apache on one machine and mysql on the same network?

tcp connections

tcp
yeah what shabbs said!

what changes would that entail?

remote
external

remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules
remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306

heh
I guess both work

I don't have that bind-address= in my my.cnf
:X

maybe you should remove the localhost stuff from your php script and enter the actual ip of the host where your mysql server runs?

I've done that, it throws different errors, same error code

well

you also have to grant permissions to the remote user

try adding bind-address= into my my.cnf?

!man adding users

see http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

no, remove skip-networking and you are fine
and grant permissions!

it won't work as root even

user@localhost != user@yourlanip

skip-networking is off

a mysql user is the username + the hostname combination

strange
did you verify that mysql actually listens on port 3306?

when I change the host to 192.168 etc
Yes
it says host isn't allowed
I have it in etc/hosts.allow

...
first

what error message have you got (.err file in the datadir or wherever debian puts it)
bwhat error message have you got (.err file in the datadir or wherever debian puts it)/b

stupid bot

Horrible human

lol

well you have to grant permissions to the user@host.
host isn't allowed is not the same as 'connection refused'

a) in your php script use: mysql_connect('remote_ip_of_server', 'username', 'password'); b) on the server grant permissions to 'username'@'yourwebserversipaddress'

%

or 'username'@'%'

''@'%'

bad wookie!

whooooooo!

does MySQL support supoport AJAX?

no
mysql is not a browser.

heh

try firefox or opera

IE
IE invented Ajax
... well, what is now called Ajax

indeed but doesn't run on many platforms.

mysql supports ajax through php

But the platforms it does run on is much more common

that's irrelevant!

Bah!

I'm trying to make a pointless point here

And I was trying to make an irrelevant revelance

"SELECT * FROM product_yahoo INNER JOIN category ON product_yahoo.id = category.prodid AND '%$category%' = 'T' ORDER BY price DESC

so it doesn't support it through jsp? :P

does mysql support AJAX?

lol

when I use GET to do the search

dejà-vu

!tell ultravi01 about whats wrong

ultravi01 Don't ask us "What's wrong with this query...". We are not SQL parsers. We do not care to look character by character looking for errors when MySQL will tell all of us WHERE the error is. Paste the FULL error issued by MySQL.

no!

'%$category$' = 'T' won't ever be true.

you've been through this like yesterday or the day before

I know
I lost the file

this just makes no damn sense in any way I try to interpret it...

woo a new one
Lost connection to MySQL server at 'reading initial communication packet'

!man lost connection

Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/lost connection

boo

nils_ why won't $category ever be T?

I didn't say that.
but even if $category == 'T', 'T' != '%T%'.
maybe you want to use the like operator but still... it just makes no sense at all
as either it joins all rows based on product_yahoo.id = category.prodid because '%T%' LIKE 'T' is always true or not because $category is not 'T'
and if you don't even use LIKE, it will always return 0 rows.

I see

oh wait
'T' LIKE '%T%' is always true
the other way round it's just bullshit
and false
and I should get drunk

way ahead of you

I just need to relate the information in product_yahoo.id and category.prodid ... so if category=spiritual then I want to pull all of the results in the spiritual column in prodid with T and relate it to the id column in product_yahoo so it can display the other attributes of the result
if that helps...

congratulations I think I'll start with a bottle of wine and then move on to beer.
it just adds to my confusion to be honest

the local cafe opened a new beer and wine place and held a reception earlier today...

hehe

well does this channel have logs anywhere

hello
i'm trying to repair what seems to be a crashed table..
i'm getting an error 145 on it, and i tried doing `REPAIR TABLE [tablename]` but that didn't seem to help...

I'm sure several people log this channel

can someone help me with this, please?

MyISAM I guess?

well i need logs from the day before yesterday and yesterday

in which timezone?

not sure

Mountain time

you can try shutting down the mysql server and run the command line tool myisamchk on the table.

yeah, it is MyISAM

ultravi01 what for?

actually shut down and try the myisamchk tool

thanks, will do

find a query that I got working a few days ago and posted on here

haha

but I can't find it now

good luck with that

I'll find it if I can get the logs

they are confidential, I often say embarassing things when it gets late

alright, it says to use -r or -o to repair it... http://pastebin.ca/567025

nils_ I won't read any embarrassing comments

try -r, if that doesn't work you can try o
hehe

ok
shouldn't i try -o first, as it's a safe-recover? :-/

nils_ if you can kindly send them over, however, I really appreciate it

7
hmm
I actually do have logs

from awhile back
lol

yay
thanks, nils_

is it possible to reset the root passwd if you dont know it, using the mysqladmin tool?

just checking if they cover yesterday

it always possible to reset a root password

cool, thanks

mysql root account
user

yep
just find out where the password is stored, and modify the file ;P
that is... if you have a root shell on the pc you're meddling with

so the root password for mysqladmin is not stored in the mysql db?

it is

then how can I change it if I don't know it

!m Marticus root user

Marticus see http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

see there

thank you

what's with this indexing stuff? i mean, what's the use of it? i stepped into a web programming interview last week not knowing

very important stuff

Basically it works like this

an index helps mysql find rows fast (among other things)

if you have a book and you want to know where something is you look in the table of contents
that gives you a page number to go to for your information
if not you would have to look through the book page by page

i see

the data is stored in the table in unpredictable order, the index is ordered and only contains certain column data. Ordered data can be searched easier

so, for huge databases, this is useful

it should always be done

hmm, k

not indexing is a showstopper for medium databases

how would one index a column?

how long should i expect
optimize table tbl_name;
to take?
it's been running for a long time now
and now i can't even connect to check its progress
Too many connections

the larger the table the longer it takes...

6million entries
how long should i expect?

the many connections are most likely waiting for the table to be optimized and the lock to be released
how many deleted rows?

none
but i recently did an ALTER TABLE tbl ENGINE = InnoDB

ok

fwiw

6m rows might be something around 10 minutes depending on hardware, ram, data, innodb settings

insert into table1 select * from table2 where column value=(not in table 1 already)

nils_, ... it's taken far longer than 10 minutes
and i can't even check to see whta's going on in the processlist
because i can't even CONNECT to mysql

!tell sabakas1 about a not in b

sabakas1 SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL;

ok, i liead.
lied

argh
i just hope it resolves itself within a cpl hours

hye all

Another approach: If value is supposed to be unique over table1, make sure you have a unique constraint. Then use: INSERT IGNORE ...;

If I alter a table, and add a new columns, thus that new column will be added in previous rows as well ?

yes
either with a null value or whatever you have specified as default

I've added any value in that column
and I want to access that field, will it give me error ?
btw its giving me error

then why ask if it will?
what's the error?

Hey guys.. so I have a 4.1.22 linux server , x86_64, with tons of RAM, but its memory usage is slowly but surely creeping up up up...
I'm sort of at a loss for why this is happening, but I suspect its just fragmentation in glibc's malloc libs..
because even restarting mysqld does not reclaim the RAM. Anybody have any ideas?

'Specified column "IP" is not in the row'
I'm accessing i thtoruhg PHP

yeh it's a primary key so it's unique

*it through

hmm no, it's all freed when mysql stops... how many ram does mysql use?
err how much

When it starts up it uses about 6GB (innodb_buffer_pool is set really high)
the box has 12GB total..

great

i'm not quite sure how to do it because the column names are slightly different

and right now.. _something_ is using 11.5GB

i mean obviously i could do it in php but i'd rather do it in a mysql command because it's quicker

and it's not the os file cache I guess

though top only shows 6.5GB for mysqld

hey, is somebody of you working on an oracle 10g?

is it cool if I paste 3 lines from 'free -m' ?

yes

Xgc

I got this statement
http://pastie.caboo.se/70530

total used free shared buffers cached
12242132 12219692 22440 0 60188 613012
-/+ buffers/cache: 11546492 695640

but get an error when querying:
select * from DAX
where INDEX = '20';
ORA-00936 missing expression

The next big process in top is using like 8M

INSERT IGNORE INTO table1 SELECT * FROM table2 how do i edit this statement so that it puts columna from table1 into columnb from table2 etc
i mean columna from table2 into columnb from table1

You need do nothing more than use the IGNORE keyword, in that case. No join is requried.

I'm totally stumped..

no but i want it to put the values into the existing columns

INSERT INTO table1 (field list, ...) SELECT field list, ... FROM table2;

rather than put new columns in

INSERT [IGNORE] INTO table1 (field list, ...) SELECT field list, ... FROM table2;
Correct. You would be using existing columns, not altering to add new columns.

INSERT [IGNORE] INTO table1 (a,b,c) SELECT d,c,e FROM table2 WHERE c='x';

a etc?

INSERT [IGNORE] INTO table1 (columnb, ) SELECT columna, ... FROM table2;
You keep making mistakes in your questions.

isn't what u just told me the same as what i said back?

The insert list specifies the fields to populate in the new rows in table1/

i realise that

The select list specifies the fields to obtain from table2.

i realise that too
where did i missunderstand?

What else do you need to know?

nothing i was just asking if that was correct

The form is correct.

ok i'll try it then thanks

The []'s were to show an optional keyword. Don't use the []'s in your SQL.

ah ok

INSERT IGNORE ...;

yep

hi everybody
In a virtual learning environment (written in php)I want using a database(mysqld) as a backend and LDAP as a front end Do you think it could be good idea ?

hmm you want to query mysql via ldap?

exactly

hmm openldap can use mysql as storage backend I think
but with sql you are more flexible
I wouldn't cripple myself with ldap

or do you want to manage mysql users via ldap?

create mysql users via ldap ; Do it be possible ?

hello ppl

ok i want to run a mysql command that checks for repeat values. how do i do this?

how do i run a script with sql commands as root?

ie repeat values in columns
in a table

dupes

in a specific column?

find them with select count(dupefield) as qty,otherfields from table group by dupefield having qty 1

yeah
or in a specific 2 columns
or perhaps similar entries using the LIKE function?

?
can anyone help?

what kind of script?

look at 'mysql -e'

i have mysql.sql, with sql comands inside

mysql -uuser -p db mysql.sql
optionally -h if you're on a remote host

xzilla?

or if you're already logged into mysql use the source command

well, the like bit is a bit whacky... otherwise do what the_wench said

is there a config option to make mysql treat empty strings as NULL like oracle does?

1;

doesn't work, what am i doing wrong?
o missed the group command
hangon :p
ok it works!
but has the wrong output..

count(title) as opposed to 'title, count(*)' will only count non NULL instances of title.

hrmm

how can I configure mysql's default empty string value to be null?

ok so how do i do it on 2 rows then

you define the column's default value as null

DEFAULT VALUE NULL

ie check if values in both the rows are duplicated

is there a way to do this at the database level?
isntead of the table level

uhm, that is database level

no

oh
no

well that sucks

why?

why? how would you even utilize that lol

you define the fields of a table

or it is flexible

databases don't have fields

well oracle's database makes "" come out as null

guys?

good for oracle

what if you really want a ""?

mysql says that's a blank string

moving this stuff over to mysql will be a pain, cause all those ""s will have to be replaced with NULL

But "" isn't the same as NULL

just make a script that migrates them to NULL ?

so do a dump and do a find/replace on the file

xzilla, the_wench u there?

some way to configure it would be nice

how do i do it on 2 columns rather than just one

stupid bot

Horrible human

yeah that's the idea, it means rewritting large amounts of code
a configure option would be nice

no... wtf
you would just change the current values and run it through a mysql script

for some reason I don't think oracle supports "" as null
because it also supports the "is null" syntax

NULL

why doesn't your audi take a ford's engine?

perhaps some sort of concat(), count(*) group by ?

Because Audis suck!

it would be nice if it did cuz then you could interchange them
uit would be nice if it did cuz then you could interchange them/u
I thought you had a jeep wrangler
liar

Empty string
Oracle treats the empty string ('') as null. This is not ansi compliant. Consequently, the length of an emtpy string is null, not 0.
so it's your fault for using a non ansi compliant null comparison
die in fire

lol

a*

firewire++
actually I don't know if that should be a -- or not

the "die in fire" may be a bit harsh

informative yet insulting

that's me

hey guys, NULL as a string is the same as NULL as the null value right?

no

"NULL" is the string "NULL", not the same as NULL

hrmm
so in his case, how would he change his columns to null?

if it was then you couldn't have people named null

s/""/NULL/

cause my idea was to do a find and replace and use the string 'null' as a replace

Ok, I'm not seeing this anywhere, but what is a good value for setting fields that will be used for passwords?

right, but isn't that a string?

no

no s/""/"NULL"/ would be a string

s/""/"NULL"/ would be the string
shabbs for the win

echo

ah, gotchya

NULL means a) Unknown b) Did not supply a value c) "" d) lack of a value e) could not determine value f) none of the above

f

I chose NULL as an answer

it means whatever the hell the implementers decide it means

NULL means zero in German!

so by passing it NULL and not "NULL", it would be like passing a function, kinda, that insters the true NULL value?

...

lol

I'm not sure how you got function out of that

well you get my point!
you cant pass KETCHUP
so NULL is special

yes
!

yes

can repeat entries in a unique column cause a corrupt table?

good word
special

you can pass ketchup

is there a way I can mount a mysql database (with innodb tables) from a read-only volume? i just want to be able to do SELECTs on it.

lol

it could get messy though

who passes ketchup?

washing it out might be hard

Saberu not really

MUSTARD stains more though

funny

I would use MAYO instead

NULL is special like harry potter is special
he's a boy wizard, but he's also a horse loving freak

mysqld users can be appened with ldap ?

nope

maybe through some scripting, but not directly

I wanna know when Hermione is going to get it on with Ron

when she turns 18

she can travel in time
gotta be soon

woohoo

just imagine the whiz bangs!

aha :P

how do you view all stored procedures?

mysql.proc table

cool

wth did they store procs in mysql.proc and not inside the datadir?
of the appropiate database

well the proc table knows the database

no takers on read-only volume question?

I don't think you can

I prefer to ask why the hell did they store triggers in the datadir rather than a data dictionary table?

though why don't you TIAS?

TIAS?

tias

Try it and see, its quicker to type it on your system and try it than wait for one of us to tell you its ok

We don't have a real data dictionary

Client program doesn't building. I tried 'gcc -o hatirlatici `mysql_config --cflags` main.c `mysql_config --libs`'. It's say main.c.text+0x46): undefined reference to `mysql_connect'

whenever i try to add a foreign key to an existing table, i get foreign key restraint failed

After all of that now I can't get my working server to connect again :/

does anyone have a clue what that might mean?

SELECT * FROM information_schema.ROUTINES;

now *there* is the real question

That's for you too.

cool, thanks

information_schema is ugly too, it clashes with the namespace of regular databases

so what's the difference between... information_schema.ROUTINES; and mysql.proc ?

foreign keys anyone?

data dictionary .... don't try me to make a comment to that

did. it fails because it checks if volume is writable. hence the question here.

mysql.proc is the place where the procs definitions are stored. i_s.routines is just a read only representation of it

information_schema relates closer to the SQL standard.

sigh

cool

I start server with --skip-grant-tables and I still need a root password...

it didn't start with skip-grant-tables properly then

using --init-file method, the password specified doesn't work

having a "password" option in your config? Just hit enter

Leith can I put that in the my.ini?

yes

kk
thanks

just 'skip-grant-tables'
check SHOW INNODB STATUS for LATEST FOREIGN KEY ERRORS

Inside the [mysqld] section

¿Hay alguien de Ecuador que haya usado una cédula en una BD?

well that seems to have also failed

leith, one moment
im getting a syntax error on that

on what?

skip-grant-table is being overridden or something

SHOW INNODB STATUS for LATEST FOREIGN KEY ERRORS

no, just 'SHOW INNODB STATUS\G'

oops

it has a LATEST FOREIGN KEY ERRORS section in the output

guy, why wouldn't you just tell me to do "SHOW PROCEDURE STATUS;" ?
instead of SELECT * FROM information_schema.ROUTINES; or mysql.proc

it's database specific, and not 'all'
be more specific

ahh okay
so "SHOW PROCEDURE STATUS;" isn't in some of the 5.0's?
I don't understand how it's DB specific

Hey folks. I've got two boxes - one is running Debian Etch, the older one is running Debian Sarge. I'm trying to move all the databases from the Sarge box to the Etch box, but I'm not quite sure how to upgrade. I can't get the older version of mysql on the etch box, and I can't upgrade on the Sarge box for other reasons.

mysqldump

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Can I just do a dump from the Sarge box, import it on the Etch box and run mysql_upgrade?

yes

do the dump and follow update directions

dunno about the mysql_upgrade part

what are the version?
4.1 and 5.0?

Aye.

!man upgrade 4.1 5.0

Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/upgrade 4.1 5.0

bah
!man upgrading 4.1 5.0

Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/upgrading 4.1 5.0

grr

I'm reading the docs on it

ok
yeah, just follow those directions, as long as you have a dump of your data you're safe

what are the biggest things to watch out for when moving from 4.1 for 5.0 ?

I just didn't know if I could load the 4.1 data into the 5.0

sure you can

Before running mysql_upgrade on the data.
Okeedoke - thanks, I appreciate the advice.

select * from records where name like %herbie%;

like '%herbie%'

hi everyone

quotes

Use ` around identifiers (database/table/column/alias names) and ' around strings and dates. MySQL does allow " for strings, but ANSI standard uses " for identifiers (which you can enable with ANSI QUOTES option)

hrm, interesting

ajax

lol what
how, what's mysql_upgrade good for?

!man mysql_upgrade

see http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

haha

dick

fixes tables/table structures

i have a proble with a migrated db which i exported from a mysql on windows and installed on a linux system the mysql version of the source machine is 5.0.27 and the target machine is 5.1.7 now my table names same to become case sesitive
any ideas?

I thought mysqlrepair or a table repair did that?

check your my.cnf for lower_case_table_names
!man case sensitivity

see http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

!man identifier case sensitivity

see http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

that one

thanks

I've tried two different methods for getting root password reset and neiother worked

is is possible to query data from two separate databases using php?

you would do that in the SQL
or make 2 seperate queries

the problem was that there was some orphaned data i had to clean up before it would add the foreign key
thanks a lot

np

hi, what's the best way of authenticating an user via mysql in debian etch?

typing the password?

I meant more like a script securing
that the user must authenticate himself before accessing some script
awstats in this case

does skip-grant-tables exist in 5.0?
because it sure as hell is acting like I didnt specify

afaik, yes
how are you specifying it

both from command line and from my.ini\
mysqld.exe --skip-grant-tables

select Description,SubnetMask,Country from subnets where SiteCode = 'OCEN' where Country like 'User VLAN%';
and you do multiple sorts?
can

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

using the directions that start at "...Alternatively, on any platform, you can set the new password using the mysql client(but this approach is less secure):..."

I've done that many times

use the 'initialization file' method

can you do multiple where statements?
like a grep of a grep?

omg
that place in that document which says windows users omit the --user-root option
I ignored it and got right in

'where col1 = 'val1' and col2 = 'val2'...'

in a table there are rows representing family groups (father,mother, kid1,kid2,etc) the main data is key="father_doc/family_member_number" and the date they enter a club, now bcoz of a problem many of the groups this date is NULL i want to know who are they and then update the date to the fathers date IF posible in only one query

how the heck can you drop a db with an underscore in it?
tried back ticks, quotes, etc etc

ff
oops.

Nothing special needed

CREATE DATABASE abc_xyz;

Query OK, 1 row affected (0.21 sec)

DROP DATABASE abc_xyz;

Query OK, 0 rows affected (0.42 sec)
works

How come it takes twice as long to drop a database?

_k_ is using an apple, crappy filesystem

*gasp* oh no!

oh no!

lol

sad but true. he used to be a pretty cool geek, using freebsd and so on, but he is old and weak now.

rumors are there will be ZFS in Leopard

Official support?

no. r/o only support and you cannot boot from it

Lame

sun made it cool, apple fucked it up

You're a minority here
As a readonly FS

is there a noticable performance gain from using raw disks for innodb instead of files?

yes, but a larger minority.

damn it.

do not do this.

why not?

as soon as you have replication, you want files.

because your sysadmin and backup admin will jointly kill you

heh

fortunately, those are both me

too bad. killing yourself is a deadly sin

this server is a slave. (it'll be initialised with a dump)

I know the suicide prevention center E-mail address.

I can kill you too

what if you need to reinitialize it?

i'll dump it again

their phone number is also posted to lamp posts on golden gate bridge

syphillis can kill you too...

Related Topic: