#mysql
30 December 2007
Total 14 pages. You are browsing page 2/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
02:26 <****> hey anyone here familiar with setting up postfixadmin
02:26 <****> ?
02:26 <****> im getting some mysql database erros
02:28 <****> Naphidia: Probably just an application setup/configuration issue.
02:29 <****> Naphidia: Did you install the mysql database separately?
02:29 <****> yeah i think so
02:29 <****> i followed this tutorial
02:29 <****> You don't know?
02:30 <****> it was prob out dated or somethin
02:30 <****> http://www.xnote.com/howto/postfix_mysql_courier.html#mysql_install
02:30 <****> thats what i followed
02:30 <****> and im getting unknown errors
02:30 <****> Invalid query: Unknown column 'alias.modified' in 'field list'
02:30 <****> stuff like that
02:30 <****> Naphidia: "Installation of MySQL is outside the scope of this document."
02:31 <****> ya i got mysql installed
02:31 <****> its running
02:31 <****> how can i troubleshoot mysql to find out which DB is causing my server load to be so high?
02:31 <****> Naphidia: An SQL error like that is an application issue.
02:31 <****> ooo...
02:31 <****> i wonder if its useing mysql 4
02:31 <****> which means the tables are wrong cause shit changed
02:31 <****> Naphidia: Try asking the developer of the application what version of MySQL is required.
02:31 <****> ya i know what it is
02:31 <****> there are certain words in the table
02:31 <****> that im sure u cant use in 5
02:32 <****> like alias
02:32 <****> ;^)
02:34 <****> i feel smart now
02:34 <****> :p
02:35 <****> looks like i have many open processes in "Sleep mode"
02:36 <****> how do i clear the mysql command line?
02:36 <****> i just knew it!
02:36 <****>ip ;)
02:36 <****> there used to be a command line tool before but even that one is gone in 5.0.45
02:37 <****> NetAffect: \c
02:37 <****> i REALLY need a resolve_dns() :(
02:37 <****> \c doesn't work
02:37 <****> in mysql?
02:37 <****> you can use dig from the command line
02:38 <****> or nslookup if you feel old school
02:38 <****> threnody, what do you mean by \c?
02:39 <****> NetAffect: I guess you better define 'clear the mysql command line'
02:39 <****> like there is stuff on there, a previous select, and it won't go away, but i want a blank line
02:39 <****> NetAffect: hit the down arrow?
02:40 <****> right, the last select stays there
02:40 <****> NetAffect: hit the up arrow?
02:40 <****> hehe, all the previuous stuff is there :)
02:41 <****> sok just thought there might be a ^l or some kind of thing
02:41 <****> NetAffect: type '\c' and press enter
02:41 <****> i did and the select executed again :(
02:43 <****> heh
02:43 <****> ah well, no biggie :)
02:53 <****> Is there any tool for mysql to view the rows in the table in a grid? I don't see it in my MySQL Admin, I can only change the schema
02:55 <****> can i make a select statment output to a file?
02:55 <****> a text file?
02:59 <****> Hi all, does anyone know why it would take 20 seconds to connect to mysql? Do I have some sort of setting inadvertently set to cause a delay? Once the connection is made, the queries happen in 0.0005 seconds--it's the connect that's lagged
03:00 <****> how do i wipe out all the databases i created
03:00 <****> ?
03:00 <****>;
03:00 <****> thats it ?
03:01 <****> I believe so :)
03:01 <****> wait
03:01 <****> what do you mean by "wipe out?"
03:01 <****> well
03:01 <****> ebergen hm.
03:01 <****> i was installing postfixadmin
03:01 <****> and i set it up useing old school databases
03:01 <****> "drop" would erase the database completely.
03:01 <****> not erase all of the data within the database
03:01 <****> i wana erase all the data too
03:01 <****> and the users
03:02 <****> so if you want to keep the structure, drop isn't the way to go
03:02 <****> i dont wana keep any of it
03:02 <****> ebergen so do you confirm that mysql can't lookup hostnames?
03:02 <****> Lazarus: so you don't want the tables either? you want it to all be gone?
03:02 <****> ya
03:02 <****> all of it
03:02 <****> then drop is it :)
03:02 <****> of course i know how to dig and such in bash... i just need a function in mysql desperately
03:03 <****> is there a way to list databases ?
03:03 <****> show databases;
03:04 <****> now test must stay thre correct?
03:04 <****> Lazarus: no
03:04 <****> what anout the one called mysql
03:04 <****> you don't want to drop information_schema anyway...
03:04 <****> Lazarus: don't touch it, it is essential
03:05 <****> and don't touch mysql either of course
03:05 <****> hmm
03:05 <****> ERROR 1064 (42000): 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 'postfix' at line 1
03:05 <****> wont let me delete postfix
03:05 <****> drop database postfix;
03:05 <****> awesome
03:06 <****> now this database i don't know where it came from...
03:06 <****> what else are you going to destroy tonight? :s
03:06 <****> information_schema
03:06 <****> Information_Schema is a virtual database of databases inside of MySQL 5.0. You can use it to get schema, table and column metadata. Please note: It only shows information the user has access to. For more info: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
03:06 <****> don't touch it.
03:06 <****> k
03:06 <****> | information_schema |
Total 14 pages. You are browsing page 2/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last