| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> I tried mysqld-max-nt --install "MySQL" --basedir="path". It worked.
<1> rKR245, the manual is a good place to start
<2> manual?
<0> Is it good if I keep only 1 copy of my.cnf under above mentioned "path"
<0> rKR245: myqsl-install-folder/docs/
<3> hi.
<2> o.k
<2> i will see it now
<3> So we have one MySQL server right now that gets hit pretty hard with load
<3> for redundancy I want to set it up in a master-master setup, with another server there
<3> and then I want to replicate to other servers to distribute the load even more
<3> Since this is all for the use of Apache serving PHP pages to use this data, would it make sense to double-up on the same server MySQL's read-only server and Apache?
<3> Since those Apache/PHP machines will be the only ones reading from those replication nodes anyway
<4> Will somebody point me in the right direction, please. I need to isolate my mysql server onto a seperate server security so it can face the public internet... where can I find the best recommendation for which procedures/methods and distribution I should use to do this?
<3> I think that any properly configured MySQL server should be sufficient, regardless of the distribution or OS.
<3> The manual gives pretty good general guidelines.
<4> dan__t: well, I'm not too convinced I want to open my desktop/server runnin gentoo up to the internet...
<4> dan__t: I was looking to pick a distribution which I booted over PXE boot... and then backed up the mysql database daily... and then just knew that the particular distribution and implementation of mysql were secure.
<5> hey guys, I have a table that has a tinyint(4) with autoincrement ***igned to it, its got to 127 just fine, but now whenever i try add something new it says cant have duplicate entry 127
<5> it wont go further, then when i look with phpmyadmin it shows Next Autoindex 127, even if i try to insert the id myself as 128 it doesnt allow it, spits the same error...
<6> tinyint = max 127
<5> ahh true
<5> lol
<5> well there's my problem
<6> lol lol
<7> after doing a mysqlimport i get this message: guadamailer.direcciones: Records: 65536 Deleted: 0 Skipped: 65536 Warnings: 67738 But if i check the real data base, i can confirm that there are only 15000 results. ???
<6> dunno
<8> When conllation_connection is used?
<5> thnax
<5> :)
<4> Can anyone recommend a great guide for securing mysql?
<9> Can anyone tell me how to update MySQL server??
<4> AxBiT: which distribution?
<9> I have MySQL 5.0.18 installed using Setup.exe (from mysql-5.0.18-win32.zip). Now there is version MySQL 5.0.21. Is it sufficient to stop the service and install the new version over the current using Setup.exe (from mysql-5.0.21-win32.zip)???
<9> Can anyone answer my question?
<4> AxBiT: sorry about your luck.
<4> AxBiT: I'd ****can windows... and use a real linux/unix for your mysql... or else you will be hard pressed to find help on this channel.
<9> Where can I get an answer to my question?
<10> http://dev.mysql.com/doc/refman/5.0/en/index.html
<8> my database is a bit large, i need to change collation for all columns and tables. Any tips how can i do it fast?
<11> large and fast do not come together :)))
<8> domas: read the post on the bottom
<8> http://dev.mysql.com/doc/refman/5.0/en/charset-column.html
<11> yes
<11> if you mean 'fast' by 'typing less', then yes :)
<12> I go shell> ./bin/mysql -u root mysql then mysql> show tables
<12> I see a list of tables NO sign of a GRANT table
<11> most tables there ARE grant tables
<12> I am NOT able to run mysql_install_db so I am guessing that i have NO grant tables???
<12> domas hi domas
<12> my main error is 'access denied' I have been studying the GRANT command and always get 'access denied'
<12> I appear to be NOT able to get the GRANT OPTION going so GRANTing myself access is NOT happening??
<13> help
<13> :)
<13> i have a 30G table and needed to add an extra index
<13> the creation of the index resulted in a temp table also about 30G's
<13> now the disk is full, but the process isnt finished
<13> i cannot normally kill the sql thread
<13> that makes the index
<13> what to do?
<13> stopping mysql altogether resulted in a removed socket
<13> but the process is still running
<13> the temp table dropped to about 1G
<13> after a /etc/init.d/mysql stop
<13> aw now its gone
<13> why does the data file have to be rewritten to create an index?
<13> why doesnt it just scan the data and write the MYI file?
<14> !perror 1033
<14> hmm
<14> what is the meaning of this error message: SQLSTATE[HY000]: General error: 1033 Incorrect information in file: './grt/Session.frm'
<14> doesn't make any sense
<13> i'm just taking a wild guess, but maybe Session.frm is corrupted or something?
<15> error?
<16> hi guys i get this when trying to insert into db. Data truncated for column 'cv_pic_width' at row 1
<16> cv_pic_width is a float, null allowed
<15> pangelovski the value you are tryign to enter exceeds the avaialabel space
<16> im trying to enter the width of a picture. how much should i put in the length and decimal
<15> pangelovski and the value you are attemptoing to input is?
<16> lemme see
<15> guess it wasn't important enough ;-)
<16> sorry, about that, my lapop went beserk
<13> we understand, it was a difficult question :)
<15> pangelovski so what value are yo uinserting?
<16> pic_width is "empty".
<16> doing echo $width displays nothing
<16> but if it is a float, what kind of length and decimals should i have
<16> i think i know what is wrong
<15> ;-) glad I could help
<17> hello every one
<17> i have little problem with mysql
<17> when i try to start mysql its always failed
<17> :(
<12> hi LINUX
<12> !m linux start mysql
<18> linux: (mysql, the Command-Line Tool) : http://dev.mysql.com/doc/mysql/en/mysql.html
<17> :)
<12> hope that helps :)
<17> bro i fixed it ;)
<12> how
<17> my.cnf had an issue :)
<12> .cnf is a config file??
<17> ahh
<17> again
<17> issue
<17> i restarted it
<17> now its not working
<17> :(
<12> yyeeeeeesssssssss!!!!!!!!!
<17> [ERROR] /usr/sbin/mysqld: unknown option '--~'
<12> LINUX how do i copy a file using unix??
<12> is it like COPY filename source path TO destination path??
<17> yeah
<16> no luck guys, still the same problem
<17> cp /path/to/the/file/to/copy /path/where/to/copy
<16> Data truncated for column 'cv_pic_width' at row 1
<17> can some one tell me what should i put in mysql 5
<17> set-variable=lower_case_table_names=1
<12> thanks linux I tried man copy
<17> how can i use this variable in my.cnf for version 5
<17> ?
<17> davidohm : cp is the actual command
<17> ok
<13> isnt 'rm' the actual command ? *smirk*
<16> anyone?
<17> rm will remove :@
<12> LINUX yes i see cp NOT copy
<13> aw yes, but 'rm -rf' will copy right?
<19> SunDevil_: Your poor attempt at clever humour is neither clever nor funny.
<17> SunDevil_ : go away if you don't want to help don't give them wrong suggession
<13> yet, you define it as 'clever humor' albeit a 'poor attempt'. Hrm
<12> LINUX how do i get out of the man display mode and back to the shell prompt??
<19> davidohm: q
<13> :q
<13> go away?
<19> davidohm: http://www.indiana.edu/~uitspubs/b017/
<13> im here for the serious questions
<19> davidohm: a basic unix command reference card.
<19> SunDevil_: That much is obvious. Aren't your parents going to get mad that you snuck downstairs after your bedtime to use the internet?
<20> hello guys
<15> pangelovski and once again I ask you for the value
<20> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: YES)
<20> but i didn't set anyp***words
<17> SunDevil_ : okay
<17> SunDevil_ : i have problem with mysql 5
<15> Meaw wrogn p***word or no access to that IP
<17> when i use /etc/my.cnf then it won't start
<17> i need all tables to be in lowercase
<15> Meaw then don;t supply a p***word
<20> it asks me for : p***word
<16> ungy: they are empty. Nothing is being inserted
<20> when i did echo "create database radius;" | mysql -u root -p
Return to
#mysql
or
Go to some related
logs:
#math
flared cock
#perl
what is dcc rsync
#php
#oe
cc1plus dapper
gentoo CardMan
okie fenokie swamp
how to find malloc overhead
|
|