| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> shabbs, let me check in the site
<1> anyway, I gotta run
<1> but it doesn't have to be a primary key
<2> i want tu mysqldump a database, but only the lines where section=games how could i do that?
<3> micro`: you can have mysqldump use a where clause. see mysqldump --help
<2> thanks
<4> ppl when traying to install the mysql # scripts/mysql_install_db --user=mysql it give me the erro saying that i dont have permissions
<4> but i am running the command as root
<2> hmm -w section=games doesnt seem to work, and -w=section=games doesnt work as well
<5> Extremina: root on which platform?
<4> gentoo
<4> using sshd
<5> Extremina: root@gentoo != root@mysql
<4> e-PUNK i dont get it
<5> Extremina: its not windows mssql
<3> Extremina: you're running gentoo. therefore you must be an expert. so you'll work it out. if any of these ***umptions is incorrect, you're using the wrong distro.
<5> Extremina: mysql got its own users
<4> yes and i have already add the user root to the group mysql
<3> micro`: quoting strings may be a good idea.
<5> arjenAU: good point
<3> Extremina: that step actually shows a tad of ignorance of how unix user privs work
<3> Extremina: which again leads me to point out that you're using the wrong distro.
<6> I believe mysql works with most of the linux distros :)
<5> ????????????
<3> karthik_2000b: it definitely does. however, it needs either the distro handling things automatically for noobs, or the owner being a competent sysadmin.
<5> is it fun or sad?
<7> gentoo's setup of mysql is quite friendly actually
<3> karthik_2000b: a noob with gentoo is like employing your cat as your personal brainsurgeon.
<7> emerge mysql; is usually all that's required
<4> inviso dont works for me
<4> i get an error
<4> aftar the emerge
<4> *after
<7> otoh, I'm now a brain surgeon and an Expert :) This is a great day
<3> inviso: until the next step in trouble and damage. note that the build env on gentoo is not stable. it can have any number of combinations of compiler version, libraries, etc. it's a recipe for disaster.
<6> :)
<3> Extremina: but you are an experienced Unix system administrator, right?
<7> arjenAU: true enough and somewhat more difficult to recover from on gentoo than debian/ubuntu/mandrake/etc
<4> some but not mucth
<3> Extremina: let me rephrase that. your recent step of adding root to another group indicates that you are in every way a noob sysadmin. you are using the wrong distro. PLEASE pick another distro and be much happier.
<7> Extremina: their suggestions are pretty solid. Ubuntu might be a good place for you to start
<6> I use mandriva all i have to do is urpmi mysql :)
<3> Extremina: right now I'd recommend you grab Ubuntu.
<5> Extremina: give me ur root p***wd,plz. i ll hellp u than
<8> or Windows
<3> Extremina: will get you started quickly without h***les. and keep you relatively safe from this kind of stuff.
<6> :)
<5> Extremina: sorry man
<7> e-PUNK: cute...
<3> Extremina: I should perhaps also note that this is not a mysql problem. it purely has to do with the sysadmin end of things.
<9> hello, is it possible to get all the commands used to create a schema and it's tables, to run on another mysql server?
<3> inviso: I just get very depressed with all noobs going for gentoo. it makes no sense.
<3> saif: mysqldump
<3> saif: or use phpMyAdmin
<5> irc sometimes is really bad to people
<9> arjenAU, thanx! :)
<5> i dont like that
<8> be bad to IRC back
<3> inviso: I mean I leave Extremina.
<3> inviso: as there's nada more to add here.
<7> arjenAU: heh, I know. 'twas just too easy :)
<5> often u got kickbanned than
<6> Extremina there is a gentoo wiki on mysql see if this helps -> http://gentoo-wiki.com/HOWTO_MySQL
<7> arjenAU: and I agree. Gentoo is a bad choice for someone just starting out
<6> Actually many who are successful with gentoo like it very much :)
<5> inviso: do u think the same of debian?
<7> e-PUNK: debian isn't too bad for a beginner, but it does have its quirks and it lags a little behind. Ubuntu is a better choice.
<5> what the hell is ubuntu? sounds like an african folk, or something.
<6> e-Punk you should start checking distrowatch.com to see what are all the distros coming up off late :)
<5> i did like debian when i startet with linux at my home
<8> Ubuntu is "Linux for the Rest of Them"
<5> and i still like it :)
<10> SuSE is good for starting too
<7> e-PUNK: it's a debian derivative that's been around for a couple years
<5> with SUSE u dont learn anything about linux
<5> here at my country there is a good word for that: klicky-bunt
<3> e-PUNK: http://www.ubuntu.com/ and if you click on the "Ship-it" link on the right, you can get a CD sent to you for free. CPU arch of choice (x86, i64 or PowerPC)
<11> !perror 5
<12> System error: 5 = Input/output error
<11> Hmm. What can cause an error to be 5?
<7> bye bye disks :)
<3> Neo|Laptop: auch. possibly disks yes. stuffed OS FS drivers. an indication might be WHEN do you get it.
<5> network lags^
<5> http://www.ubuntu.com/ nice ! does it work with "normal" human beeings?
<11> arjenAU: on access of the table, and the error is over the MYD file
<3> Neo|Laptop: ye that's not nice. time to stop the server, make a backup, and then track down which bit in your hardware or OS has gone awall
<5> and what can they do with it? (cont. ubuntu)
<3> e-PUNK: do stop being a git.
<5> git? where is my dictionary
<11> and recovering the MYD file?
<3> Neo|Laptop: depends on how screwed your FS is. RDBMS can't do anything magically to save you from bad hardware. backups help.
<3> Neo|Laptop: the MYD may be fine. perhaps the indexes are screwed. that's easily fixed with a repair
<5> arjenAU: didn't found "git" in my dictionarry
<3> Neo|Laptop: anyway, make a copy now, to another physical drive. whether it's messed up or not, at least you have a copy
<3> e-PUNK: try dictionary.com
<11> !man repair
<12> (How to Repair Tables) : http://dev.mysql.com/doc/mysql/en/Repair.html
<6> git = A person who is deemed to be despicable or contemptible
<5> arjenAU: it was not my intension to be contemptible or something. im really interested in the differance of ubunto to other distros that let non computer scientist feel happy with their pc.
<5> intension= intention
<3> e-PUNK: so you go there and read up, and google for it to read up more.
<3> they've won a few prizes now for best distro and such
<2> INSERT INTO `games`(rls,grp,nuke,info,genre,time) VALUES (nsayon, la, NULL , NULL , GAMES, 3424) i dont understand what seems to be the problem, it says Unknown column 'nsayon' in 'field list'
<5> yes i will do that, i just wanted to make that clear
<7> micro`: if it's text, quote it
<5> cause truely i m a nice guy
<13> Is there any way when you create a backup of a db for the sql file to not have the name of the db it just backed up? Or instead create a new db with a different name so we don't overwrite the old db we did a backup of. Thanks in advance.
<7> Brendon: I'm pretty sure that's the default behavior of mysqldump
<13> inviso: so there is no way besides editing the sql file for the backup to go to a new db?
<6> Brendon open the sql generated by mysqldump and change the db name :)
<14> hi .. little help pls
<7> Brendon: I'm saying I don't think it includes the db name by default anyway
<13> karthik_2000b: Its for a client, they're not comfortable with that.
<7> LuCkYaN: pls is actually spelled please. That will be 5 dollars
<6> :)
<6> i bet inviso made lots of dollars.
<14> i install mysql , and after i install only thing i do is to change p*** to root from phpmyadmin , and after i give in console restart and now give me this error : Starting MySQL database server: mysqld...failed. // Please take a look at the syslog. // /usr/bin/mysqladmin: connect to server at 'localhost' failed // error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' // Check that mysqld is running and that the socke
<14> and isn't on ps .. is not started sure
<7> And did you look at the syslog?
<13> inviso: i've tried with the "No Creates" option enabled and it won't create the tables but the create database dbname still appears.
<6> LuCkYaN then its not running see the error log and see whats stopping it from starting.
<7> !m Brendon mysqldump
<12> Brendon: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<7> Brendon: see --no-create-db
<13> thanks i'll check that out
<15> Wondering if there is a function to compare values
<7> Brendon: and if dumping just 1 database, don't use --databases or --all-databases anyway...
<15> like compare(string1,string2)
<6> = operator dont work?
<14> 2:41:16 /usr/sbin/mysqld: unknown variable 'old_p***words=1' // 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
<14> this is .. and all of that from up
<15> karthik_2000b: not for what i need
<15> karthik_2000b: i want to have a column that says if they are the same or not
<6> then use STRCMP( string1, string2)
<15> karthik_2000b: thanks, not sure why you didnt say that to begin with
<6> because i didnt check function list :)
<6> its always handy to keep one :)
<16> How do you change the name of a server? My server name in mysql is localhost.... that does not match the true server name though. How can I change it?
<14> karthik_2000b, i put # before that on mysql cfg
<14> it's k ?
<6> Tarus /etc/hosts file has your hostname
<6> i believe you change there
<16> karthik_2000b: yes I know but the host name in /etc/hosts is different than the mysql hostname I use to log into mysqladmin
<17> ERROR 1005 (HY000): Can't create table './brodarevo_db/teme.frm' (errno: 150)
<17> guys, how do i check what each error code means?
<3> !perror 150
<12> MySQL error: 150 = Foreign key constraint is incorrectly formed
<17> hm
Return to
#mysql
or
Go to some related
logs:
downthemalll extension
#lisp
lilo append nvidiafb
ubundu start vnc server
gentoo+M675
ubuntu network manager wep airo
#linuxhelp
ubuntu terminal window arrow key problem
gtk+-2.0 >= 2.2.0 PKG_CONFIG_PATH ubuntu
#math
|
|