| |
| |
| |
|
Page: 1 2
Comments:
<1> www.something.com/else.html
<1> thats working too!!
<1> wonderful
<2> if anyone's bored could they take a look at this newbie q for me pls, cheers! http://groups.google.ie/group/comp.lang.php/browse_thread/thread/862a84ca720fdd7c/372a37e9c9ef7c42?hl=en#372a37e9c9ef7c42
<1> it's broken
<1> stil
<1> l
<3> flash 8 player
<1> no
<1> javascript
<3> me and savagephp are chatting on it now
<1> i guess none of you actually use a standard compliant browser
<3> yes IE
<1> rather; "no ie"
<3> this is for my IE app,
<3> which, yes, dont work in FF cause its 2300 a4 pages of js and PHP
<1> so?
<1> it's not like its harder to make code work in firefox than in ie
<1> if you read the ****ing specifications instead of documentation at msdn.microsoft.com you'll even notice that it's in ie things are broken
<1> but then again, just because gmail, google maps and like every other ajax / web2.0 application out there works fine in all renders, why should yours..
<3> grazzy if your gona have an attitude about browser then **** off i dont need your ****, if you want a pleasant conversation then please have one, if not then dont bug me with your FF ****e
<1> yeah well i guess this breaks down to your returning pasting of totally offtopic, non-relevant, non-working links in here
<1> one could guess it would be you asking for feedback or comments
<1> but seeing that you're not interested in that i'll have to just ***ume you're just doing it to show off your projects to as many people as possible.
<3> maybe i am, but browser platform is not one of them you know what your an ***hole enjoy life and **** off
<4> Hi. little question. I want to add a description to a Table.. what is the command? I tried to remember,to search, but didnt find it :(
<5> #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7
<5> K_F: you there
<5> well i just tried to upload a mysql backup
<6> sort of
<6> just remove that
<6> you're apparently downgrading
<5> which means?
<5> remember that backup you help me to take the other day?
<6> 4.1 was installed on server A. 4.0 installed on server B
<5> so ?
<6> so just remove the "DEFAULT CHARSET=latin1" thing
<6> run a search and replace on the file
<5> in where?
<6> in the backup.sql file?
<5> remove the line?
<5> yeas
<6> not the line, the text
<6> ... just, read the manual
<5> well i am removing "DEFAULT CHARSET=latin1" from backup.sql ok?
<6> yeahj
<5> i need to remove all ?
<6> all the occurences of DEFAULT CHARSET, yes
<5> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
<6> simple search and replace
<6> :%s/DEFAULT CHARSET=latin1//g
<6> would be what I'd use
<5> ok
<5> ok i am replacing "DEFAULT CHARSET=latin1;" with //DEFAULT CHARSET=latin1;//
<7> how can i extract in my php script the columns from the mysql table ? e.g: i auto generate some tables for some polls, and my script needs to know the fields (q1_a,q1_b and so on) and their types (numeric, text ...)
<6> Alexender: that was not what I said
<6> xy-yz: 1) you have a very flawed schema
<5> so that wont work? if i just replace // //
<6> ?
<6> <6> :%s/DEFAULT CHARSET=latin1//g
<6> is a command in vim to perform a search and replace
<5> ok
<6> vim.org
<6> just do a SEARCH AND REPLACE in whatever editor you use
<5> well do i have to comment that out or just remove the line?
<6> just remove it
<5> ok
<5> ok its been removed.. now uploading the backup.sql
<5> K_F: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `forumattach_quota` DISABLE KEYS */' at line 14
<5> ****
<5> well.. i got one few hours left , to upload this
<8> salut
<6> heya
<8> hi K_F
<8> few people..
<6> sort of
<6> the way I like it :)
<6> well, except for my website of course
<6> but I'm still living on the 14k in a day thingie
<8> well.. when you are p***ionate about something people flock around.
<8> .. i guess.. :)
<6> either that or someone submitted one of my articles at digg.com
<6> had 3k visitors the first hour on the frontpage
<8> digg is nice :)
<8> imagine what slashdot would do.
<6> hehe, jup
<1> whats happening guys?
<6> not much
<6> still have a cold, reading logistics
<1> mhh..
<8> betatesting lincity
<9> just wondering, is there a program that can be used to input loads of properly formed information into a table, ive got 100's of records, and would take ages to type up the inserts
<6> LOAD DATA INFILE
<6> .... RTFM
<6> http://www.kfwebs.net/links/6 for SQL
<5> dam daim.. today is wasted
<6> huh?
<5> K_F: already more then 5 hours
<5> i couldnt make this work
<5> :(
<10> where can i find the C API ? (i am running mandriva linux 2006.0 and mysql 4.1.12)
<6> bah
<6> cristi8: urpmi mysql-devel
<10> no package named mysql-devel
<10> is the package mysql-devel on mysql.com ?
<6> http://dev.mysql.com/doc/refman/4.1/en/c.html
<10> "It is included in the mysqlclient library and allows C programs to access a database."
<6> [kristianf@cm-80 ~]$ find ~/mirrors/cooker/ | grep -i libmysql15
<6> /home/kristianf/mirrors/cooker/media/main/libmysql15-5.0.18-4mdk.i586.rpm
<6> /home/kristianf/mirrors/cooker/media/main/libmysql15-devel-5.0.18-4mdk.i586.rpm
<6> /home/kristianf/mirrors/cooker/media/main/libmysql15-static-devel-5.0.18-4mdk.i586.rpm
<6> show up on an "sudo urpmi mysql-devel" here
<6> bah
<6> get a brain implant..
<10> no, really.. where can i find them ? urpmi outputs "no package named mysql-devel"
<10> maybe it's not configured..
<10> but can you tell me a mirror ?
<11> hi, question. can someone tell me how to post the same information to my database to 2 different tables by just 1 single action? using a form
<6> SJAH: for one thing that sounds like a very odd schema
<6> second one option is to use a stored procedure
<6> third you could use a writeable view
<6> forth you could consider reading the manual
<6> want me to continue?
<12> hello everyone
<12> I am in the need of some MySQL Optimization.. I have tables that have arround 9 million records, and are about 6gb in size.
<12> if someone could give me a hand please let me know :-D
<6> Zayak: chapter 7 of the manual
<1> buy more ram ;=)
<12> I have a dual xeon with 2gb of ram
<1> Zayak, also, I've already read chapter 7, for 299$/h I could be available to you.
<1> payment first ofcourse
<1> zayak, if theres free slots in taht box then put some more ram in there ;)
<12> $299/h.. guess I will ready Chapter 7 and then start working as MySQL Admin :-D
<12> hehehehehe
<6> writing your own caching schemes can make sense in a lot of situations
<1> gawd im good
<6> aggregating results et cetera
<6> grazzy: hehe
<12> hehehehehe
<1> zayak, no but seriously, identify slow queries, make sure those queries uses indexes, try to remove searches on unindexable columns (varchar) be restrictive about using % in searches. buy more ram. tune my.cnf
<1> in that order i'd guess ..
<6> I'd use (runtime) server variables before my.cnf
<6> SET GLOBAL table_cache=256;SET GLOBAL read_buffer_size=1 * 1024 * 1024;SET GLOBAL sort_buffer_size=4 * 1024 * 1024;SET GLOBAL key_buffer_size=64 * 1024 * 1024; SET GLOBAL max_connections = 1000;
<1> caching is great if it's possible, the way i use it is to run a md5 on the input variables, genereta a static file (which i check exists before doing a new query) and then i run a background process that removes all files older than 15 minutes in that cache-directory.
<12> I have been running a Query for 125k of seconds
<12> that is 34hrs
<1> ... ;)
<1> as i said, for 299 im sure both me and K_F would love to take a more detailed look
Return to
#mysql
or
Go to some related
logs:
was King Arthur's queen and Lancelot's lover
Where is the human skin the thickest
woldchat
#linux
THE ACT OF A VAMPIRE TURNING A HUMAN INTO ANOTHER VAMPIRE OF THEIR CLAN IS CALL
biggernigger jpg
#linuxhelp
vlad kornea
#javascript
#linux
|
|