| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> ****ty MS Word data can be solved by converting character sets
<1> liubi: copy/paste from ms word into most forms, causes stupidity.. things like tinyMCE etc have a de-word this text box button, look into that
<2> cool
<0> yeh
<2> MS: making life hell. One soul at a time.
<1> heh, that was meant for freemania
<0> Penny Arcade used to have that problem... Gabe would paste from Word and then all his quotes would be ****ed up
<1> a lot of sites still have that
<1> the stupid ? issue
<0> yeah
<1> kill em all i say
<2> yeah, I see ? in emacs when I paste from there
<3> I had a situation once where someone had different kinds of quotes in the TEXT fields. I had to dump s/'/'/g the thing and reimport.
<4> TodoInTX: shabbs: Jivedue: Screen connection dropped. (: Thanks for your answers.
<3> cool
<4> Jivedue: Isn't CHECK() from PostgreSQL? *checks,*
<4> CREATE TABLE xx (xx INTEGER NOT NULL CHECK (xx <> 10)); seems to work. (-: Thanks.
<4> Hm. INSERT INTO xx VALUES(10); still works though.
<0> !man check
<5> (How to Check MyISAM Tables for Errors) : http://dev.mysql.com/doc/mysql/en/Check.html
<0> nope
<0> jasper: MySQL doesn't check constraints (yet)
<6> so is this place to ask about mysql_query, or should I go to ##php?
<0> depends on your question
<4> Darien: Interesting that it supports the syntax for it though. (:
<4> Guess I'll stick to the check in my SP instead, then.
<0> jasper: of course
<0> compatibility
<6> well, let me see if the mysql is working in command line, then maybe I can ask in here...
<3> ironpig: mysql_query is a php function but you'll find plenty of cross-over here.
<4> Ah, yes.
<6> I'm not sure what the problem is yet...
<6> ok, my problem is with the mysql query its self, not the php. I think...
<6> give me a sec to phrase this right
<6> I want to select a bunch of variables from database where, but I want it to perform a where one of those variables equals the phrase "test"
<6> so I've been trying to use: SELECT title, url, date1, img, summery, author, subject FROM data WHERE subject like 'test';
<3> ok that looks correct.
<6> hmm
<6> maybe its php then...
<6> let me look at this a little more.
<6> thanks though.
<3> do this query work from the cli
<6> ok
<7> mysql wont boot
<7> when i issue mysqld_safe &
<3> Acidic32: ok what's in your error log
<7> where do i find error log?
<3> it's either explicitly defined in the /etc/my.cnf or in the $datadir
<7> ok
<7> touch: /var/db/mysql/mossy.err: No such file or directory
<7> chown: /var/db/mysql/mossy.err: No such file or directory
<7> Starting mysqld daemon with databases from /var/db/mysql
<7> /usr/local/bin/mysqld_safe: cannot create /var/db/mysql/mossy.err: No such file or directory
<7> ahh
<7> 060308 20:50:39 mysqld started
<7> 060308 20:50:39 InnoDB: Operating system error number 13 in a file operation.
<7> InnoDB: The error means mysqld does not have the access rights to
<3> ok then either /var/db/mysql doesn't exist or is not chowned.
<3> !perror 13
<5> System error: 13 = Permission denied
<3> ah.
<7> ;/
<7> im on FreeBSD
<3> and you built mysql from ports ?
<7> yes
<3> it should have chowed the dir for you.
<7> :/
<7> i created /var/db/mysql and that fixed one of the problems
<3> unless it already existed.
<7> but what dir is it trying to access?
<7> mmm
<3> you might want to run mysql_install_db --datadir=/var/db/mysql ; chown -R mysql: /var/db/mysql
<3> why aren't you using the startup script in /usr/local/etc/rc.d/mysql-server.sh ?
<7> ahh
<7> its booted
<7> there isnt one?
<7> oh there is
<7> wasnt before
<3> hehe
<7> do i copy that to /etc/rc.d ?
<3> no -- you just need to add mysql_enable="YES" to your rc.conf
<7> ok ta :)
<3> using that startup script should install and chown the directory for you,
<3> yea, not the ports install.
<8> how do I get the default value of a mysqld variable?
<3> hacim: mysqld --verbose --help
<8> thanks
<9> I've reciently upgraded the version of mysql I'm using and now when I run 'mysql -u root -p' the only database I see is called 'test'. The mysql db has disappeared although all the files are still in /var/lib/mysql/mysql
<9> any ideas on how to get mysqld to slurp up that DB?
<10> terje: If you can't "use mysql" or otherwise access the mysql database, that user doesn't have proper access/grants.
<9> I'm running the client as root
<9> all the files are owned by mysql:mysql as well.
<10> terje: root may not have proper grants.
<9> I see..
<9> so if I start the DB and skip grants, I should be able to see the DB again?
<10> terje: You can restart the mysql server with the --skip-grant-tables option and browse/chage anything as you see fit.
<9> alrighty
<10> change
<3> terje: you will need to issue "FLUSH PRIVILEGES" once logged in to be able to issue the GRANT/REVOKE commands.
<6> got it working TodoInTX, thanks :)
<3> Xgc: you seem pretty expert... mind giving my tuning primer script a once over ?
<9> ok
<10> TodoInTX: Haven't seen it. I'd be glad to take a peek a little later.
<3> ok thanks... http://www.day32.com/tuning-primer.sh
<3> +800 lines of bash ;)
<10> Got it. No problem.
<3> it's not terribly difficult to read though.
<10> TodoInTX: What's the main purpose? Do you expect users to pick this up and run it directly?
<3> yea
<3> it's supposed to evaluate server status variables and mysqld runtime variable and make suggestions.
<10> TodoInTX: Is it destructive (modify the system) or simply informative?
<3> no, it makes not changes to the my.cnf
<10> Got it. That's fine.
<3> it will make a ~/.my.cnf if it can find a p***word it can use and ~/.my.cnf doesn't exist.
<11> That's a neat script
<11> I might not have done the angry fruit salad, but it's flashier this way at least :)
<3> :)
<11> not bad, not bad
<3> I was thinking, run this for free and charge for nore indepth analysis of slow query log etc.
<11> TodoInTX: The background of your terminals is white, isn't it
<3> yea
<11> I can tell because blue-on-black is very hard to read :)
<12> how can i rename a database?
<12> 'MySQL does not support the rename of a database through its command interface'
<3> jade: from the command line -- stop mysql ; mv ~mysql/old_database ~mysql/new_database
<13> Use a time machine, go back and tell yourself to use a different name.
<12> TodoInTX, thanks
<0> TodoInTX: ~mysql might not be accurate
<3> true
<0> ~mysql is not necessarily the data directory
<3> use whatever $datadir is
<13> That's not a problem with my approach.
<0> cd /path/to/datadir && mv old_db new_db
<0> or do 'RENAME TABLE db1.table1 TO db2.table1'
<3> ugh... for each table
<0> yeah
<3> that gets cumbersome.
<0> depends on how big your database is, but this can be done without shutting down the server
<0> and is very fast
<0> so you could write an .sql file to do it and then paste it into the command-line client
<3> mendel: get a new version it's easier on the eyes when using black on white
<11> Much :)
<3> mendel: it has 'modes' too :)
<3> ./tuning-primer.sh mem
<11> nice
<3> the innodb mode only works as a user with SUPER.
<14> thuper!
<3> mendel: alphablue even tested it on Mac .
Return to
#mysql
or
Go to some related
logs:
#xine
#php
#perl
quantum physics oh shi
#linux
gentoo nox
i live to serve lisp
opensuse netinstall pppoe
fixdep permission denied
#perl
|
|