| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> thanks
<1> Yup
<0> do i have do chown -R mysql /var/lib/mysql on every boot
<0> ?
<1> No.
<0> ok THANKS a LOT :)
<1> Sure.
<0> bye
<1> Madeye, I don't believe there's a mechanism to go through all tables with an OPTIMIZE query because, well, you just don't do that normally.
<1> Bye.
<2> thanks dan__t , I'm looping over db's
<1> ok.
<1> Well have fun with that.
<3> dan__t, i found that there is no /var/run/mysald/mysqld.sock , that's why i cannot start mysql-server
<1> Interesting to place it in /var/run
<3> suddenly i can't find it neither on my backup-harddisk
<3> it says: "Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!"
<1> ls -ld /var/run/mysql
<4> I can't get mySQL working
<3> drwxr-xr-x 2 mysql root 4096 2006-04-15 12:26 /var/run/mysqld/
<1> ****s.
<1> ok, rdz.
<3> seems ok?
<1> there should be an error prior.
<1> Yes.
<4> When I run 'rcmysql start' it just says 'failed'
<1> I don't know what rcmysql is.
<4> It's the Suse command to try and start SQL
<4> but I can't find any SQL logs anywhere to see why it failed??
<5> dan__t I just like get unique entries...
<1> look for a file named hostname.err, hyphenex.
<5> exclude does having same entry in a col
<1> Look into using the 'DISTINCT' keyword.
<5> WHERE 'thiscol'=DISTINCT ???
<1> http://dev.mysql.com/doc/refman/5.0/en/distinct-optimization.html
<1> I have not used it but one time, and that wa sa while ago. I'm no expert on it.
<5> k
<5> SELECT DISTINCT t1.a FROM t1, t2 where t1.a=t2.a;
<5> will this stop the query from running if found=?
<1> Beats me. Try it.
<4> Wow, sorry, I had a bit of trouble
<4> does anybody know how to get mySQL working for me?
<1> Did you look for those logs?
<4> I can't find the logs
<4> all I get is this.. Starting service MySQL ..failed
<1> does /var/log/messages say anything?
<1> You need to find the logs. We can't guess what your problem is. We need details.
<1> And that's the best answer you're gonna get until you can show something else.
<1> Sorry, sparky.
<4> dan__t, Sorry, but I'm new to all this and am having trouble even finding the logs. There is so much stuff in the messages file, I can't tell if there is anything in there
<1> type 'tail /var/log/messages', that will print the last 10 lines of that file. That's the part which you're concerned with, if the messages are going there.
<1> check in /var/lib/mysql, see if logs are in there.
<3> dan__t, you were so right. there was a prior error: it couldn't find /etc/mysql/my.conf. i took the one from my backup, but this one says, that the socket is on /var/run/mysld/mysqld.sock, but in my actual configuration there is no socket there
<4> dan__t, YOU FOUND IT... in the /var/lib/mysql/log thing there's this a few times
<4> 060415 20:44:37 mysqld started
<4> 060415 20:44:37 InnoDB: Started; log sequence number 0 43654
<4> 060415 20:44:37 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
<4> 060415 20:44:37 mysqld ended
<1> ok... check /var/lib/mysql - what else do you see there? You can use http://pastebin.com to print your answers instead of the channel, please.
<1> There ya go, rdz.
<4> What am I looking for?
<1> some directories - test, mysql, maybe some others
<1> those directories are actually database names.
<4> there's test
<4> I think I may have dropped a database that I wasn't susposed to
<1> do you see the 'mysql' dir?
<4> yes
<1> what do you see inside it?
<4> a lot of things
<1> ok, i think there's more to that error.
<1> what do you think you deleted which was important?
<4> now I'm getting a different error: MySQL is not running on your system - database list could not be retrieved.
<1> yeah
<4> I just clicked all the tables in webmin then hit the drop button
<1> all the tables?
<4> yeah
<4> I couldn't remember creating them
<4> so I figured I didn't need them :s
<1> ok, you're f'd
<4> hehehehe
<1> run mysql_install_db, that will reinstall all the mandatory databases and tables
<1> only do that immediately after installation, and when stuff is completely f'd
<4> Still not starting, same error
<1> which?
<4> Ahh, found this in the log though - Can't find file: './mysql/host.frm
<1> Before or after we ran mysql_install_db?
<4> ???
<4> should i clear the log then try it again?
<1> na
<3> ok, i just consulted the my.cnf of a freshly installed mysql-server. it also says: "socket = /var/run/mysqld/mysqld.sock". but it is nothing there. can i create the socket file manually?
<1> what I do with logs...
<1> I do tail -f /var/log/messages&
<1> launches the log to the background, scrolls it in realtime, so I don't have to always check the log - it just scrolls.
<1> no, rdz.
<4> hehehe, but the log file is in /var/lib/mysql/mysqld.log
<1> MySQL creates the socket for others to connect to.
<1> hyphenex, tail -f /var/lib/mysql/mysqld.log&
<6> can any body help me to connect to mysql server at localhost from dream weaver
<1> then try to start it up.
<1> what's wrong with it, lamers_inn.
<6> i installed mysql on my windows xp and made a database in it with one table also added a user
<4> still can't find ./mysql/host.frm
<6> but when i try to connect to it from dreamweaver it says"unidentified error occured"
<1> you saw that as a new error in the log, hyphenex?
<1> I think you should identify the error before moving on, lamers_inn.
<4> dan__t, Yep, whenever I try to start SQL
<1> What does basedir= say in my.cnf, hyphenex?
<1> er, datadir
<6> <1>: how to detect ?:( do i need tomake extra changes before connectring it from dream weaver
<7> I have a from with a textarea and the text the user inputs goes strainght into a MySQL table. Do I need to 'normalise' the text input in some way?? (I am doing this in PHP)
<1> Sounds like it. Which distribution did you use to install on Windows, lamers_inn?
<7> lamers_inn, hahahah, awesome nickname
<1> You need to clean it up, eleftherios.
<4> dan__t, I can't find my.cnf
<1> is it in /etc, hyphenex?
<6> i downloaded "complete " 37 mb from mysql.com
<8> how biggest can be a mysql database? What will happen if my database gone 10 GB?
<7> dan__t, how do I do that? what kind of characters do I need to clean it up from?
<6> and installed it
<1> eleftherios, escape all of it, etc etc.
<7> dan__t, ok, I'll ask at PHP what functions are available for that
<1> Yup.
<1> That's the best way to do it.
<1> I don't know, lamers_inn. Need more information.
<9> Poison3R: 2^64 bytes is the current limit
<1> Look at logs, see what they say.
<9> 18446744073709551616 bytes
<9> 18446744073709 megabytes
<9> 18446744073 gigabytes
<9> so i think you will run out of diskspace before mysql runs out of addressing space Poison3R :)
<4> There's no basedir= in there
<6> <1> : i am stuck :( can u help me what to du now:(
<1> lamers_inn. You look at logs.
<1> You figure out what "undefined error" means instead of shooting in the dark.
<6> from where??
<1> google.com. your LOGS.
<6> okies i try
<1> okie.
<1> I'm going to bed.
<1> I have to go to FL tomorrow.
<8> Apachez: but it the mysql will be slower when is bigger?
<4> dan__t, Night, wish me luck :D
<1> Good luck. Later.
<9> Poison3R: why should it if you have proper design and index used ?
<8> Apachez: i dont know what is proper for so big database, i must read something about this
<10> hi there
<10> what's the correct syntax to do this -> ALTER TABLE {each table name} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
<11> aloha my friends
<10> hi
<12> hi
<13> hi, can somebody tell me whats wrong with this ?
Return to
#mysql
or
Go to some related
logs:
libstdc++ scalix
xorgconf frontend
#perl
#kernel
Fatal error: Call to undefined function: escape_data()
debian enable smp kernel 2.6.8
akcom hdd record
nvagp agp aperture
cpu lithography
Fedora transparent xconfig
|
|