| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> cp?
<0> cp -R?
<0> rysnc?
<1> nah
<1> pen + paper + lots of time and effort
<1> :D
<2> Silly Putty. Flatten and press, peel and paste.
<1> nice
<2> GUI!
<2> Do man pages on 'being born in usa in 1951'
<3> lots of no manual entries :P
<2> soon none. lol.
<4> Guys, I REALLY need help here. I can't get access to mysql. I did a yum remove, then yum install again after a reboot trying to fix the problem (Drastic measure I know, but I wasn't getting in so I had nothing to lose) and I still can't get in. Other than yum remove, is there another way to completely remove mysql and start over if you can't get into the database?
<1> did you do a mysql_install_db ?
<1> or whatever the command was :P
<4> err... no. lemme try it and see what happens
<3> NYAAA
<3> stupid mysql++!
<5> odd, I cant use ORDER and then GROUP BY in the same query?
<4> Ok... I typed that in... then I went to the directory that it said to go to and typed in /usr/bin/mysqld_safe & (as it said to do). It tried to start the server, quotes lines 376 and 384 of /var/log/mysqld.log and gives permission denied on both lines. Then it stops the server, says tee: /var/log/mysqld.log: permission denied and ends with permission denied
<0> yes you can mage.
<4> any ideas anyone?
<3> anyone in here uses mysql for C/C++ applications? :(
<5> gleam_: well it doesn't seem to want to do ORDER and then GROUP
<0> yes, that's correct.
<0> group by comes before order by
<2> BriteLeaf: mysqld_safe --user=mysql &
<6> anyone know of a mysql database visual designer that is free
<5> oh, darn, because if it does GROUP and then ORDER I'd get the first line instead of the newest
<5> gleam_: is there any way I can sort the data by timestamp and then GROUP?
<7> threnody: http://pastebin.com/728982
<0> try selecting max(tscol) along with your other fields
<2> BriteLeaf: hold on
<7> k
<2> BriteLeaf: what are your permissions on /var/log/mysqld.log?
<2> BriteLeaf: sorry
<8> hey guys, how could I check out some stats on my mysql db, I am trying to figure out if I should get a dedicated db box or not.
<3> why does nobody uses MySQL++ in C++? -_-
<4> one sec
<3> let me rephrase..
<3> why does nobody use mysql++?
<4> ummm... How do I check permissions again?
<2> What is the operating system?
<4> FC 5
<2> ll /var/log/mysqld.log
<4> thanks
<2> BriteLeaf: tell me the owner, group and permissions
<4> ll /var/log/mysqld.log
<4> -rw-r----- 1 mysql mysql 1569 May 20 18:34 /var/log/mysqld.log
<4> Greek to me
<4> I see read write, and read
<2> BriteLeaf: so the mysql user has read/write permissions on the logfile.
<4> don't know how it is working (Which part is for which I mean)
<2> BriteLeaf: do 'cat /etc/p***wd | grep mysql' and see if the user is there.
<4> ok... So theoretically, BriteLeaf should be able to do ANYTHING within the mysql directory, right?
<4> this is strange... 'cat /etc/p***wd | grep mysql'
<4> bash: cat /etc/p***wd | grep mysql: No such file or directory
<2> BriteLeaf: In your install/uninstall you've deleted the mysql user accoung in linux.
<0> no, uh
<0> brite, does cat /etc/p***wd even return anything?
<2> Uh-oh
<3> why does nobody uses mysql++?
<2> BriteLeaf: don't use the single quotes
<4> actually, threnody, that is kind of what got all this started. I was a freaking idiot. Welll... I was ignorant, not an idiot. That being the case, I thought it best to backup the database I NEED, then uninstall mysql then reinstall. Unfortunately, I seem to have only made matters worse =(
<4> oh. My bad
<4> .cat /etc/p***wd | grep mysql
<4> mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash
<2> BriteLeaf: the user is still there
<3> is there ANY way i could access mysql through C++?
<9> fushuing: by using the straight C api.
<3> ...that one doesn't works either :/
<9> yes, it does.
<4> I know this sounds dumb, but where? I don't see user_name=BriteLeaf anywhere in that line lol
<3> got an tutorial/example? :P
<9> !m fushuing C api
<10> fushuing: (MySQL C API) : http://dev.mysql.com/doc/mysql/en/C.html
<9> like, the second comment iirc
<3> wait, i have to build the mysqlclient too after i have built the server?1
<9> actually, wait.
<2> BriteLeaf: you want to run the mysql server, mysqld, as the linux user mysql. The user is there, the log file has the proper permission, and the command mysqld_safe --user=mysql should do it.
<4> agreed... it SHOULD do it. But watch...
<3> 20MB?!!?
<11> how can i see if a table is MyISAM or ISAM?
<9> what's 20 megs?
<11> oh nevermind i just found it
<2> BriteLeaf: do 'll /var/' and tell me what the permissions are on the log directory.
<9> Fushuing: http://www.linuxforums.org/forum/linux-programming-scripting/1876-mysql-c-api-tutorial.html
<3> i've already read that :S
<9> Fushuing: and of course it "works." I know from personal experience, and it is also used for numerous other language- and domain-specific implementations.
<3> i need mysql51-client before i can use the C api, rightg?
<9> well, don't read that, follow the links therein for examples.
<3> i don't need mysql51-client?
<9> probably mysql-devel
<3> -_-
<3> someone is going to die, REALLY OSON
<9> er, well, I dunno offhand which package/tarball the library is kept in.
<12> I know this question probably has an incredibly simple answer, but I'm new to MySQL and I can't find anything on why this wouldn't work. Can anyone tell me why this statement isn't working for me: CREATE TABLE quotes(id int(6) NOT NULL auto_increment, quote TEXT, author TEXT)
<4> threnody: http://pastebin.com/729007
<3> those tutorials are crap, btw
<0> k2v, what error are you getting?
<0> and what's int(6)?
<9> well, I didn't write them, so complain to their respective authors. *most* web tutorials are crap. so buy a book.
<0> i know what you think it is, i'm asking you waht it reall is
<3> infi: there is no book
<9> I managed only from the reference.. so ymmv.
<4> drwxr-xr-x 10 root root 4096 May 20 18:43 log
<3> ymmv?
<12> I can't see any errors because I can't access MySQL directly. I have to access it via PHP.
<0> php.net/mysql_error
<0> what's the error?
<2> BriteLeaf: Very strange.
<4> strange to you. Impossible to me lol
<4> is it fixable though?
<12> I'll look, gleam_...
<9> Fushuing: http://www.amazon.com/gp/product/0672326337
<2> BriteLeaf: Unfortunately, I don't know what is broken.
<4> do you know how to COMPLETELY REMOVE it?
<4> then start it from scratch?
<2> BriteLeaf: Did you use 'yum remove packagename" ?
<9> Fushuing: also, the channel wiki, as mentioned in the topic, has an incomplete tutorial, but should be enough to get you started.
<9> well, maybe not..
<4> yume remove mysql
<4> yum install mysql
<9> you're smart. you can figure it out.
<4> yum update mysql
<2> BriteLeaf: 'yum remove mysql-server"
<2> BriteLeaf: 'yum remove mysql"
<4> I'll try it and see
<2> BriteLeaf: 'yum install mysql mysql-server"
<0> solaris, we don't care.
<13> how i copy all databases in an unique file?
<13> i got 25 databases
<3> infi: i am already failing at including the mysql.h file...
<3> it says it cannot be found, while it IS there
<13> how i copy all databases in an unique file?
<0> dude turn off that script and stop asking every 2 minutes and maybe someone will answer you
<0> right now i'm boycotting you because of that stupid script
<13> K
<13> okz
<4> Installed: mysql.i386 0:5.0.18-2.1 mysql-server.i386 0:5.0.18-2.1
<4> Dependency Installed: perl-DBD-MySQL.i386 0:3.0002-2.2.2
<4> Complete!
<0> !m S0l4r1s mysqldump
<10> S0l4r1s: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
Return to
#mysql
or
Go to some related
logs:
#sql
anidnmeno
#centos
vsftp.conf simple debian
F5D7050 troubleshooting
#css
e17 bling deb
#math
realtek rtl8239 drivers
zend optimizer fpdf
|
|