mysql that says Can't exec "mysql_config": No such file or directory. Where do I get this mysql_config thing? I am on ubuntu 6.10
ok n/m i did apt-get install libmysqlclient15-dev after a google search

Hey guys.
Is there a way to generate a sql file to recreate a specific entry in a query?

mysqldump with –where?

oh, thanks. I'll look at it.

hope i didnt misunderstand what you want

There aren't too many other ways to interpret that.

Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `smf_members` WHERE memberName=Andares': Unknown column 'Andares' in 'where clause' (1054)
tibyke, I get that error.
am I supposed to be… bah, I suck at sql

)
quote

Use ` around identifiers (database/table/column/alias names) and ' around strings and dates.

ah

I don't do it professionally or much at all really, so I never really learn.
oh, okay.

Sup all. I have a question with regards to // computing. I am writting a scientific app that is multithreaded with ALOT of UPDATE/INSERTS on the same rows. As a result of course I have a million deadlocks… While I use InnoDB, I dn't understand how to get rid of these. If anyone can be of any
help

FAILED TO CONNECT TO MYSQL: Can't connect to MySQL server on '127.0.0.1' (111)
which makes no sense.

why not?

I mean, I remember.. you're supposed to allow connections to be made from 127.0.0.1 somehow or something.
But I can't find anything on the internet.

'bind-address' is restrictive. have you bound a different ip address?

uhh… I don't know. I'm trying to get a program to work that runs on this machine and connects to the mysqld running on here.

so check it

how?

hi,if i use group by, how can i define which row is kept?

you can comment out bind-address in your my.cnf, or to restrict access to localhost, you can use 'bind-address=127.0.0.1'

Anyone can help me solve my problem with // processing and MySQL?

andares, contact your system administrator

there is no bind-address in my my.cnf
tibyke, I am the system administrator. ~_`
It's my machine at home.

need some advice.. mysql with apache should most likely run the most powerful system I have available to use as a server correct… or would sendmail be a better choice for the faster pc (800mhz)

is it running at all?

I also need to run a ftp.. currently the 400 is doing that and seems to be fine

mysql with apache vs sendmail? rethink that.

tibyke, is my mysqldb running? Yeah, it is.

more a question of which processes will face the greater load.

I was thinking running all three off the 800 wouldn't have enough power to do it all

Lost connection to MySQL server at 'reading initial communication packet', system error: 0
yaaaay

at first, will be very little load. I'm working on a sql database I hope to be used alot in the future tho

andares, check logs, check if client is the same version as the server, etcetc

log is blank.
clients match up.

what version?

5.0.45
14.12

andares, how would you connect?

tibyke, mysql -u root -p?
Or the other program does it.. somehow I dunno.

and mysql -uroot -p connects fine?

yep

so where's the prob?

the program has to have an IP to connect.

what program?

It doesn't use sockets, it just connects to whatever IP you give it.
It's a serverlist for a game. It's internal.

check skip-networking

It's unset.
and bind-address=127.0.0.1 I added at the end.

comment out bind_address and restart just to be sure

when you are trying to talk about a one to many relationship, what do you call the table that has_many_of the other_table.
uwhen you are trying to talk about a one to many relationship, what do you call the table that has_many_of the other_table./u

tibyke, still doesn't work.
IT keeps dropping the connection at reading initial communication packet

http://farm1.static.flickr.com/221/490423135_a7e8e7b8fa.jpg?v=0
lol

hrm
ok now I see something interesting

andares, iptables? packet filtering?

interrupted system call

yaaay got it working.

enable logging, and see what happens

I just had to use localhost as the server name.
Instead of 192.168.1.1
*127.0.0.1

andares, I think localhost will use a UNIX socket, right?

Hey. I'm having a little annoying problem on my server, which is that mysql displays all error messages in frech - i cannot find anything about it in the configuration

not necessarily

icltlfatppl, I tihnk.

if you are on the same box, that is.

you about?

Usually.

Niklas - you may be using the "axis of evil" release.

ok riddle me this batman. In an strace, I see "interrupted system call"
I see where it binds to the socket file
it gets down to rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] unfinished…
And then right after that

) = -1 EINTR (Interrupted system call)

ShortWave, is this mysqld? Is the program exiting?

mysqld, yes
stand by
I'm getting the full trace to a pastebin
http://pastebin.com/m5a69c1e5
aight
I don't actually see it open any tables

Niklas- See: http://dev.mysql.com/doc/refman/4.1/en/languages.html

aaand in the .err file, it never says it's ready for connections
how very strange

looking up the pastebin, I see an EPERM, operation not permitted. I don't claim to be good at this, but could it be that mysql doesn't have permission to perform a read or write on a socket?
Maybe you could try running mysqld as a different user?

that eperm is when mysql is attempting to kill something.

Ah, o.k.

kill(3560, SIGRTMIN) = -1 EPERM (Operation not permitted)
kill(PID, SIGNAL)

seen that, but mysqld isn't launched with any language parameter

And strangely, that particular invocation of mysqld was done as root, just to make sure there were no rights issues.

I guess I can't see what signal mysqld is getting that interrupts it, and who issues it, so I'm kinda grasping.
I'll stare at it a little more.

whatever unknown signal 32 is
it gets up and running at least writes to the log file
but then hangage
for no apparent reason

http://bugs.mysql.com/bug.php?id=1450
My net connection is so slow that that link won't open for me for a while, but there appear to be a number of bug-related hits when googling mysqld unknown signal 32

yeah but that's a rrrrreeaaallly old version
from 2003

You got enough file handles available?
memory?

128 MB
plenty of file handles
This is an intermittent problem
now that I'm poking at it, it refuses to work at all

shortwave which distro

Slackware

make sure you kill all mysqld processes before starting it again

I don't think distro should matter here tho
I did that.

have you run memtest on the memory?

not explicitly, no, but it's worked fine in every other case….running Live CDs on it with KDE and Blender, it works great.

Niklas- have you tried launching it with: mysqld –language=/usr/local/share/english ?
Niklas- there is also an interesting user comment at the bottom of that reference manual page.

hello guys, is there a way to "tail -f" a mysql table? or a way to write each row added to a specific table to the file?

logging ?

adaptr, i need a real-time auto-followed log of every entry in some convenient window (ssh console?) …

then use tcpdump
mysql doesn't support this sort of silliness

lol

adaptr, yeah problem is that one well known framework writes it's errors and logs to the database, and not to any file… so yeah…
*its

which framework would that be ? I don't know it, so it can't be that well-known

maybe you need a trigger or something?

beleiev me, I don't

or perhaps
you need a repated query that looks at the count, if the count changes then it pulls the last row

a trigger to write to a log file is hideously expensive
iew.. that's even worse

) i didn't name it yet. i'm talking about drupal. either it can't or i've missed smth.

I looked into signal 32 a bit. Seems like it's sometimes used to tell a thread to wake up. My guess is that it's a red herring, that the real problem is that the thread crashes. Either due to a software bug or a hardware bug. Might be easiest to narrow down by trying a different stable version
of mysql. Sorry I can't be more help. Interesting problem, though.

it was worth a suggestion

mxNet if it can't then it's braindead, simple as that.. loggin in *nix has always been and will always be first and foremost in text files, for oh soo many reasons
mxNet but if you have to do it, I suggest you do the trigger on insert, update thingy and have that log whatever it juust did
expect performance to fall, though

adaptr, hmmm then don't quote me, since i wouldn't wanna result in unfair bashing of a framework
adaptr, of course i would , it's development
adaptr, performance is secondary
adaptr, but thank you for trigger advice

http://lists.drupal.org/archives/development/2001-12/msg00206.html
5-second google
that was 6 years ago, perhaps it's in there now ?

)

mighty odd this is
ok so
I tried running myisamchk on my tables
one of the tables claims a user still has it open, it's usable, but should be fixed

adaptr, nope
adaptr, not there

too bad, you'll have to hack it yourself !

aight, i'll figure it out, thank you

mxNet might not be much help, but I've seen a few sites turn off writing to files in favor of writing over sockets and get some speed improvements using syslog-ng.

that would be better in any case, sure

seems like most folk logging from lots of boxes are using that, from what I can tell.

a logger buffers independently of the application
so can be much more efficient

icltlfatppl, thanks i'll check it out

hi, how can i define how group by or distinct groups the results. ex: select name,language from table group by language. how can i tell mysql to group on language=1 and not language=2

adaptr, just found out on drupal channel that the 5th version doesn't do it. drupal 6 however, will reintroduce it

so now you wait ?

wouldn't you just add "where language=1";

adaptr, yes, with sunflower seeds and a blanket

this is my first day using mysql.

icltlfatppl, imagine that i do where language in (1,2) but i want 1 to be default

cjk you can't, you need to SELECT the proper language

if i have two tables.. posts, news and both have columns id, created… how do i select the (id,created) rows from both the tables? i want to select the top 20 recent items

cjk that ;s not how group by can work - all resulst HAVE to be groupable

adaptr, yeah but my name is different for each language. so there is no solution to my problem

your "name" ?

id, language, name

I have ni clue what you're talking about - you say you want to GROUP BY something, but you only want one result, and now "the name is different" ?
okay, and the query is ?

language=1 name=My test | language=2 name=Mein Test

yes.. so it's a unique table

adaptr, so SELECT language,name from table where language in(1,2) group by langauge

because…? what is it you wish to *achieve* ?

but now how can i control the value of name, i want it to take the value from language=1 in the grouped results

the table is unique for every row, you just stated that - so GROUP BY can only return one row
ergo GROUP BY is useless

adaptr, i only want one row
i want as results language=1 name=Mein Test but i get language=1 name=My Test
ups sorry other way round
anyway, using group by mysql defines on some internal rules what name will be

do queries always execute in the order sent to the mysql server?

okay what could be blocking 3306?
firewall accepted, norton off, and router port forwarded'

mysql user with remote connection privilege?
try to telnet to the port and see if it connects

anyone?

mysqld also has to be configured to accept remote connections

i have some queries that are not executed in the order they are sent

im on wondows xp

or more accurately, mysqld has to have not been configured to disallow remote access

how do i do this?

on what computer is the mysqld running?

the one I am using

perhaps someone else can answer a local windows question. I'm afraid I cannot.

do you allow remot access in the configuration menu

if the mysqld and the mysql are on the same computer, why would you need remote access?
if the mysqld and the mysql *client* are on the same computer, why would you need remote access?

yeah thats right
the only reason i am using this is to run an app called blenderpeople
cant run it without mysql
cant set up mysql if it wont connect

looking for a script which will compare two versions of the same database (dev vs prod) and output alter commands to bring prod in sync with dev.

will there be something in prod that won't be in dev that you want to save?

possibly, but i'd treat that as a special case
although if there are options for dealing with these things which i dont know about id be happy to explore those

Hi, using mysqldump, what is the way to do a 'table dump' but, do not creating CREATE/DROP statements in dump file?

if you were able to be sure the answer was no, the easiest answer is to do a mysqldump from dev and import into prod. It'll overwrite the old prod

I only waht the 'records files'

select and output to a file ?

threnody, oh, you mean wipe the prod completely? no, i'd rather not. all i want is alter statements to bring _structure_ (my bad for not mentioning this specifically) in sync. data in prod should remain intact

filesintable.sql; mysql filesintable (to add it)

yes… and ?

what is the way?

you mean you haven't tried that yet ?

have you looked at "–no-create-info, -t" option?

CREATES will be ignored if the table already exists, so what's the problem

threnody i get error 0

you want to automate the updating of alter table statements only? That might be problemmatic…

error 0?
error 0 = success

cannot create windows service

sorry, i am not familiar with the windows program you are using.

not necessarily automate, but give myself a headstart by doing a kind of sql-diff if there is such thing and getting a list of alter statements. i'd then go through the list and add whatever is needed not to screw up data in prod as i run these alter statements to update prod's structure.
makes sense?

yeah, but it's above my paygrade. I'd be concerned about the validity of your prod data.

threnody, thanks for giving it a try!

you could do the mysqldump, and then grep through the file for ALTER TABLE

hrm

thats a good idea

I'm finding zero info on this
so how might I export the data from my tables and move it to a new server?

todo_list.txt ;^)

ShortWave what's wrong with mysqldump ?

the only thing to do than is get rid of same alters from prod and dev dumpd, no?

mysql client can't connect to the server, so mysqldump won't be connecting either

hi how can I retrieve just the field names of a tables

the whole concept of prod and dev servers that are being simultaneously changed gives me the willies.
table structures, I mean

i'm not talking about automatic update, you understand, right?

oh, yeah
but still

and one way or another dev stuff has to make its way to prod
so i'm just looking for the path of least resistance, can you blame me?

I'd limit table structure changes to dev, seriously document those step by step, then manually update prod. My bias only, ymmv

anyone can help me out?
I want to know the sql sentence to display the field names of a table
no content, just the headers of the table

ok weird

describe table, or look into queryin the schema

I again removed the my.cnf file, and this time it's up and running

hey i set it to open with the command line and not the service

*querying

it finished the configuration

but now my web client can't log in via PHP

go tit nevermin

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

go tit!

threnody, i see your point, and its very valid. but our project is very agile at this point, and i'm at the other extreme, stifling database evolution would probably cause more harm than good for us. yet i fundamentally share your concern - prod data isnt to be fucked with, and that is why
i'm looking for tools which will allow me to minimize human error factor. thats all.

hrm
mysqladmin processlist status says I have 32 open tables
I don't have that many tables
WTF?

tmp tables?

maybe
but I doubt it

and information_schema tables?

normal isam tables
unless that's something internal to mysql

right, but there are internal tables in the information_schema db
yup

This is weird
I can't figure out why this is happening this way
I've got two processes hung at Connect
but the server knows they're there.

Consider shutting down the server, moving the datadir out of the way; create a new datadir; initialize the new datadir; then restart and see if you have the same problem. Make sure you have a valid backup in case you don't do this correctly.
Don't try to use your php applications.

I've shut the server down too many times now
so what I'm going to do
is move the database to a different machine
and just use the DB remotely
This is getting damned old, and I've got stuff to get done.

Also, do yourself a favor and grab $10 from the pizza fund and guadruple your available ram.

lol

can't, it's an old IBM thinkpad

There's something wrong with this picture.

overexposure?

I didn't realize you were refering to the IBM, "This is getting damned old." Now I understand.

LOL

I have a unusual thing i want. I have two sql schema's.. i want some sort of way of making a patch to merge them together. a bit like the diff/patch thing on linux.
any ideas?

I'm a total newbie, here. Just learning about SQL. I think I have a query that returns a result set that shows a one to many relationship. I have two tables, foo and bar, and an intermediate table foobar. Is this the correct pattern to use?
select * from bar
inner join foobar on bar.bar_id=foobar.bar_id
inner join foo on foo.foo_id=foobar.foo_id
order by bar.bar_id;

heh, no
in all other respects, this laptop has been great. I've run DSL on it for a couple years now, worked great as a workstation. I figured I'd make it a server…and it worked great for two weeks. Then this.

Depends what you mean by "merge". Embarcadero has a tool that can be used to diff two schema.

you around?

Normally, you're trying to produce a patch file that will transform A into B or B into A. But you have to pick the direction.

If anyone has a pointer to a doc I should read on grabbing data from these one-many and many-many relationships, I would love it.

yes, threnody

I get the concepts, but selecting data from both tables is a bit…weird.

yeah that pretty much it.. then it could generate the alter table syntax

see Xgc's comment at 16:50

its no problem having to choose a direction

Actually, the tool generates the alter statements, deletes, inserts, etc you might need.

was that comment for me?

thanks, trhenody!

It handles several types of databases.

threnody (sorry, bad sp)

news to me, too

What should i be typing in google?
and what embarcadero product should i be looking at?

Embarcadero. See ER/Studio or one of the other tools.

Xgc, any more info on that diff tool?

Ditto.

isnt there an opensource thing for that?

Could be. I don't know of oe.
one

yup

would be fun to make a perl script that could take two dumps and produce a sql-diff
trouble is, i need one today

better get hopping. ;^)

hey guys

Carlin was it who asked why is it that we _take_ dumps? not, say, make them funny is english language

should have named it 'mysqlpinch'

can someone explain this to me, when would 2 tables have any type of relationship? is it only based on if 1 table has a forgien key of another table, then they would have a relationship?

ERWin? that used to be bloody expensive

tables dont have relationships, data inside tables do. but hey, it has so firmly embedded our language i think i will get yelled at right now

and i believe some visio version does that too

z_, thanks for the info, so foriegn keys arn't the only way to make a relationship with tables?

what defines a relationship between two tables in SQL?

hail there

icltlfatppl, I think…like look at this…i'm confused on why these guys are connected, http://img502.imageshack.us/img502/6258/mysqlyd5.jpg
what makes those lines want to connect eachother, i'm not a sql person i'm a programmer but I have to figure how these guys interact with eachother

What do you think about using REPLACE syntax instead of INSERT and UPDATE?

lokieee - I don't really know what that tool displays, exactly. Can you just paste the sql into pastebin?

well there are like 30 tables all together, what type of sql would you like?

just the sql that creates the two tables in question.

k

Can "REPLACE" syntax fail more often?
or is it safe?

but it won't show the code exactly

show create table tablename;

hello
i have tons of selects and tons of updates on the same table, is it possible to lock somehow else the table on updates?

lokieee I have no idea how to use the tool you are using. I don't normally even have access to a graphical browser, so I would never use a graphical tool.

and can i sort the 'show processlist' resultset by time somehow?

lokieee, you should be able to conduct experiments on these tables with the command-line mysql command. I am learning that way and it's a great way to get the fundamentals.
What I know is, a relationship is formed when a primary key column in table A is referenced by a foreign key column in table B

ahh i c, thats what I thought as well

im trying with set transaction isolation level READ UNCOMMITTED; but my query ( select count(*) from videos ) is 8.95 secs (2452 records)

hey all
having a wee trouble with MySQL on Mac OS X
Anybody aquainted with it?

what's the problem?

how do I set a row so a duplicate won't enter into the database, or should I just use a if statment and check the row, and if it exist have a jscript screen come back?

i'd like to run mysql with limits on memory, eg. softlimit -m 3000000000 /usr/sbin/mysqld-beton

the problem is on install - am runnig an Intel mac so I have use the tar package to instal

but it does not want to start with such a limit
i am sure my database is smaller

but the command line instructions are wrong - there's no "groupadd" command in Darwin..
and neither does "pw groupadd" work
ay ideas?

gpasswd -a user group
or addgroup, perhaps

I'll give that one a go…

there's a universal binary on mysql.com
or atleast for intels

yes - that's the one that i've downloaded - it's a tar file - tis the prob

http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.45-osx10.4-i686.dmg/from/http://mirrors.dedipower.com/www.mysql.com/
Mac OS X (package format) downloads
Mac OS X 10.4 (x86)
x86 = intel

ah… didn't know that
thanks!

d-media: see 'insert on duplicate' http://dev.mysql.com/doc/refman/5.0/en/insert.html

p.s. didnt know you could compile seperate PowerPC and x86 apps instead of universal bin

you can, just easier for most to do a universal

must be a bit bulkier though..

not really, look at the sizes on the download pages

yes - the universal binary tar is twice the size of the others…
ok looks good - cheers flupps!
seeya later

later

do mysql tables have comments like columns and keys?

When you do "SELECT foo AS foo_bar", you can use both "foo" and "foo_bar" to refer to the same thing, right?

you cant really use 'foo_bar' in the where
or join, just order
and group

Protricity is right, you can't use foo_bar, you must only use foo. It's the law of foo.

what do I win

That alone is an honor from above

what a shitty variable

!kb Protricity

each time i use foo my system crashes

PEBKAC.

version? and can you write a test case that crashes it?

yea, but don't I have to set the mysql row as caratesian?

mysql 7.0.1 super early release

cartesain

funny
don't waste our time, please

?????????????

Hi! I' ve a select (select * from tablename), and i' d like to get its result with an additional column (don' t care about its value, for example constant 1).

zzz select a.*,1 from sometable a

that query will fail if tablename has more than one column and/or row

=Z
MySQL 7?! WTF?! I'm still at 5!
What happened to 6?

only preview releases of 6 out so far

oh jesus christ

6.0.4 or something is the latest

"Latest" bleeding edge, I assume.
Stable is 5.0, right?

yep
5.1 beta, 6.0/5.2 is being developed

I wouldn't dare to run anything but stable.
What's this talk about 7.x?

either he's making it up or someone lured him into install a trojen
trojan*

trojan? shit

Me like MySQL, but the MySQL Administrator software lacks triggers.

try SQLYog, Navicat, Toad for MySQL if youwant other alternatives on gui tools

thanks.

But I don't want alternatives!
Especially not unofficial payware ones.

fair enough

mysql has triggers?

http://img502.imageshack.us/img502/513/untitled1vp9.png
Look at that image.
Where the red paint is is where the "triggers" tab should be.

Trengo, 2 bugs with triggers+innodb right now in 5.0.45 … so using myisam only is ok

Tapout i had no idea it even had them

I will probably take some serious time before I start using views, stored procedures/functions and triggers.
Especially since triggers aren't even part of the GUI.

which ones?
views are pretty safe to use, triggers are getting the last kinks fixed, stored procedures still has some resource issues and limitations, but otherwise pretty safe to use

flupps|JP, the mixing engines one (lockign error) and the explicit/implicit commit not allowed …
buddy that works for mysql ab wrote up about them on planetmysql.org like 1-2 weeks ago

commit kind of breaks atomicity if you allow it in the middle of a trigger

Hmmz.

http://kostja-osipov.livejournal.com/ is the blog you think about

http://kostja-osipov.livejournal.com/26815.html

lol this new mysql7.0.1a is so buggy, but I love the differences

what differences?

like batch transactions and teh other stuff

i haven't tried that one yet

you mean actual transactions?

lol didnt know it was being distributed yet, or did you get it from piratebay also

yea piratebay

Hi

On the community version of mysql how many proccessors can it use?

I'm passing data from one table (habitacion) to another table (ventacliente), but I'm a bit clueless, I was thinking in fetching the data in my application with SELECT and then do an INSERT, but I'm sure there's a way to do this in 1 line
INSERT INTO ventacliente (no_cuarto, entrada, salida, cortesia, corte) VALUES(habitacion.no_habitacion, habitacion.entrada, now(), habitacion.cortesia, habitacion.corte) WHERE habitacion.no_habitacion = 101;
can anyone help me out?

!m tupa insert select

tupa see http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

thanks Shrews, reading it right now

one question, why this query works, and why the other does not,
1) SELECT * from $dbtable where fecha_hora like '2007-07-17%' LIMIT 1;
2) SELECT * from $dbtable where fecha_hora = CURRENT_DATE() - INTERVAL 5 DAY LIMIT 1;
why?

hi
I have a simple question…
how do I delete an entire row?

because #2 doesn't include a time (hour/minute/seconds)

CURRENT_DATE() - INTERVAL 5 DAY this does not work?

for that i write here

that result is '2007-07-17'

anyone?
I really need help

!m Gargantua delete

Gargantua see http://dev.mysql.com/doc/refman/5.0/en/delete.html

so it is the same nope?

thanks Shrews

no

how to fix it using CURRENT_DATE etc style?

is fecha_hora a DATETIME or TIMESTAMP ?

it is a string I think

Shrews, it seems like that deletes an entire table\column…

your WHERE clause controls which rows you want deleted

ah
Shrews, If I have two rows that are exactly the same, will it delete both?

show me the values you are expecting to be returned
if your WHERE clause matches both, then yes

sorry it is timestamp

Shrews, O'right, thanks.

so a date without a time will not match a value with both date AND time in an = test
'2007-07-17' != '2007-07-17 12:34:56'

Hello everyone.

can I use like?
or how to get only 2007-07-17?

I can't find this on Google because I can't remember what it is called, but I am trying to say "SELECT username FROM usertable WHERE userid = (SELECT userid FROM anothertable)"

WHERE DATE(fecha_hora) = '2007-07-17' or similar

Basically, grab the ID of every user in a table, and convert the IDs into actual names on-the-fly.

but be aware that will not use any index you may have on fecha_hora

yes, but I need to use INTEVAL etc

WHERE DATE(fecha_hora) = CURRENT_DATE() - INTERVAL 5 DAY
try it and experiment. best way to learn

I think it's called nested queries?
I'll try Googling that..

subquery
!m javaJake subquery

javaJake see http://dev.mysql.com/doc/refman/5.0/en/subqueries.html

hey, it works using DATE(fecha_hora), why!? thanks

Shrews, thanks
lol!

i already explained why. your welcome.

thanks again

The actual code is the same as I gave as an example…
Wow… this is really "intuitive"

ruben i too was asking how to remove the utf from mysql
but they didn;t say

you can't remove it

why no ?
why i can't remove only serbian ?

the DATE(fecha_hora) this function strips the second field?

the mysql server is hard coded to use that character set for some of its tables. you must include it in the server

ubuntuserver_, you know what a character encoding is?
Shrews, OK, well, you can't drop UTF easily anyway

character encoding maybe was to translate tjhe page
and to display the correct languages

Basically, ubuntuserver_, a character encoding is a list of characters that can be used. UTF uses a much bigger list of characters then most others, so if you were to try to "downgrade" to another encoding, you'd lose some characters in the process depending on the characters you
used.

but i will not use serbian why i need to have it?

At least, I'm pretty sure that's what would happen
And what a character encoding is.

character set is not the same as a language

what does this error mean?
Column count doesn't match value count at row 1

!m ubuntuserver_ charset

ubuntuserver_ see http://dev.mysql.com/doc/refman/5.0/en/charset.html

but i will not use serbian

*sigh*

i can't see the webpage in the moment i don't have mouse

Another question, I am using PHP to work with mysql, mysql_fetch_assoc is better than mysql_fetch_array, but, it is possible to get all tables without to know her name?

ubuntuserver_, right, a character set is merely a list of characters that can be used. Imagine this: it's an alphabet for the computer. The computer only knows how to write the letters that you give it in a character encoding. UTF contains a lot of letters from different languages, expanding the
computer's "alphabet" to include many languages.

anyone?

ok but it will display if you use some languages

show us the SQL statement

why there don't have option i9f you want to use serbian install serbian language utf

ubuntuserver_, it can display whatever characters are in the UTF "alphabet", which may include those languages you are thinking about

Shrews, there's none.

hmmm

Gargantua, what wer eyou doing when you got the error?

so mysql is randomly giving you error messages? huh, the server must be bored.

lets see now
if i install invision power board that is in english
it will only use english utf?

ubuntuserver_, there is no "UTF english" or "UTF serbian". There's just UTF, and whatever it contains is what you get.

Shrews, http://24.64.110.182/share/files/G-man/72202

ubuntuserver_, if you wer able to select a specific language, your entire software would be limited to that langauge's characters. Not good.

i use only english things

you need to determine which sql statement is giving you that error. i'm not going to guess.

invision power board is in english

Shrews, ok.

it will not be limited it will be saving memory

Shrews, I just learned that that's not where I got the error from sorry

ubuntuserver_, http://www.sitepoint.com/article/guide-web-character-encoding
ubuntuserver_, "a character encoding is the way that letters, digits and other symbols are expressed as numeric values that a computer can understand."