| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<Scubar> are u magic ?
<Scubar> if so im the magic mushroom monster
<RedACE> they call me mr wizard..
<Scubar> im tryna import a .sql file onto a new webhost
<Scubar> using phpmyadmin 4
<Scubar> mysql 4 even
<bricecube> HarrisonF, what about using a CASE flow?
<RedACE> super!
<RedACE> take this potion.
<Dark-Fear> ahhhhhhhhh
<Dark-Fear> I see now
<Dark-Fear> !!
<bricecube> HarrisonF, like CASE the demographic ID ?
<RedACE> may it provide you light in dark places.
<Dark-Fear> thanks will
<will> :)
<liran> im doing webhosting and i've got some users using gallery programs which are based on mysql databases. the problem is that i'm now migrating to a whole new server, how can i migrate those user's db to the new server?
<will> I've never used it, so... good luck!
<Dark-Fear> lawl
<Dark-Fear> just used the old pw thing ehh?
<Dark-Fear> its what I did
<will> !m liran backup
<SQL> liran: (Database Backups) : http://dev.mysql.com/doc/mysql/en/Backup.html
<will> Dark-Fear, Yep
<Dark-Fear> but apprently my friend tried with my server config
<Dark-Fear> and old p***words thing
<Dark-Fear> and it refused to work
<will> Maybe he did it wrong. He's not as smart as you.
<Dark-Fear> he dl'ed this phpdev pack
<Dark-Fear> and it worked find
<Dark-Fear> *fine
<Dark-Fear> I looked at the config files
<Dark-Fear> and I see nothing weird about them
<Dark-Fear> I think I might try to install what he did on my server and see
<Dark-Fear> if it works he messed up
<liran> thanks
<liran> im seeing that it's easy to dump the whole db of a user into a file using mysqldump. once i have this file on my new server, how do i import it?
<will> mysql [options] < file.sql
<HarrisonF> mysql db < file.sql
<liran> oh i see. that's rather easy. so mysqldump just dumps an .sql file format?
<will> Yes
<liran> thanks again.
<Dark-Fear> thats exactly what they did will
<Dark-Fear> they matched the client versions
<Dark-Fear> runny a older version of mysql
<Dark-Fear> like version 3.somfin
<will> somfin?
<will> That's not a version
<Dark-Fear> :P
<Dark-Fear> its like 3.1.14
<Dark-Fear> Im not sure
<sjrussel> hah
<Dark-Fear> but they did match the client versions up
<Dark-Fear> sheeshe sooo literal
<Dark-Fear> :P
<will> ****s to be them
<Dark-Fear> ?
<Dark-Fear> whys that?
<will> They are dumb. You are so much smarter. You should take over their job.
<Dark-Fear> har har
<Dark-Fear> its a friend
<Dark-Fear> I just like to understand whats going on
<will> You should steal his girlfriend. You deserve her more.
<Dark-Fear> now I know for next time I do a server
<Dark-Fear> his gf left him
<Dark-Fear> or he left her
<will> For you!
<Dark-Fear> not sure which
<will> Must have been because he was dumb.
<Dark-Fear> hes a bright fella
<Leithal> Maybe she was ugly anyway
<Dark-Fear> just doesn't do much with webservers
<will> If he's so bright, how come he can't figure out MySQL?
<sjrussel> the gf?
<will> It's piece of cake.
<Dark-Fear> he was using IIS!!!
<Dark-Fear> I almost cried
<will> IIS is great.
<Dark-Fear> Im not a fan
<will> Maybe you should
<Dark-Fear> I like apache alot more
<will> alot huh?
<Dark-Fear> yuppers
<will> Is that like Apache2?
<will> Apache Alot, ?
<Dark-Fear> no
<Dark-Fear> :P
<will> What is "alot"?
<Dark-Fear> argh!!
<will> What?
<Dark-Fear> I just prefere it then
<Dark-Fear> happy?
<Dark-Fear> I haven't done much with IIS I guess so to be fair
<bricecube> is creating a mysql table with 100 rows a bad idea?
<bricecube> err
<bricecube> fields ;)
<Dark-Fear> and the last time I played with it was when it was open to IIS hacks
<will> If you need the fields, no it's not bad.
<bricecube> will, I'm suffering a situation here.. and am going to go type up the issue ;)
<will> ok!
<will> Until you do, I will continue mocking Dark-Fear
<bricecube> lol
<will> What is prefere?
<Dark-Fear> until I what, will?
<will> Until you explode!
<Darien> boom
<will> ewww, he's all over me.
<will> Are you doing that in a ***ual way?
<Darien> sure
<amette> Heya all - I'm runnin MySQL 4.1.11 on a Debian Sarge - some days ago, it crashed - I just restarted it as always, did #myisamchk --recover *.MYI and hoped everthing'll be alright... well, it keeps crashing... :-/
<amette> .. mysqld_safe mostly restarts it, sometimes it doesn't work - I get corrupted tables in Syslog - fixing them, some minutes later same problem..
<Darien> amette: what does the error log say?
<amette> .. when I try to do a backup of my databases, I get: Can't find file: 'file.frm' (errno: 23) when using LOCK TABLES
<Darien> !perror 23
<SQL> System error: 23 = Too many open files in system
<Darien> something is ****ing up file descriptors
<amette> I get mentions about corrupted tables and after that "Improperly closed tables are also reported if clients are accessing the tables *now*. A list of current connections is below." and a table showing, that 'debian-sys-maint' is one of the users
<amette> yes, I checked that error 23, too and then decided, that I'm having to get help here - I was always well off with just repairing the tables, but this time it just keeps buggin me.. :-/
<Darien> ok
<Darien> amette: debian-sys-maint is the user that Debian creates to run a 'CHECK TABLES' whenever you start the server
<Darien> amette: it sounds like there are a lot of processes with open files
<amette> I tried #ps -A|grep mysql - after stopping mysql, there is nothing - restarting it - I get around 7-10 mysqld processes and a mysqld-safe
<Darien> amette: can you pastebin the contents of /proc/sys/fs/file-nr and /proc/sys/fs/file-max ?
<amette> http://hashmysql.org/paste/viewentry.php?id=1481
<bricecube> Can anyone give me any suggestions as to? http://pastebin.com/569261 ? I've dug myself into a hole here ;)
<bricecube> will, if you've got the time, I wrote up the situation
<Darien> amette: ok, so I don't think it's a file handle issue
<bricecube> HarrisonF, provided me w/ a nice example.. however I don't know how it'll scale
<Darien> amette: perhaps it's a ulimit issue
<amette> Darien : I never had those problems before - if it crashed before, it always was no problem to recover - but then it crashed about three days ago and my recovery-tries didn't help, it just says: "Ok, repaired the tables" and then crashes again about 10 min. later.. :-/
<Darien> amette: can you pastebin a section of the logs that shows everything, start to finish?
<amette> Darien : I made a #aptitude upgrade the day before the first crash, that I noticed - but there was no MySQL upgrade included - never the less, I got this feeling, that this is connected
<amette> Darien : one moment
<Darien> amette: what version of mysql again?
<amette> mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
<Darien> ok
<Darien> are you running stable, testing, or unstable?
<Dark-Fear> lawl
<Dark-Fear> he did it wrong
<Dark-Fear> worked for me
<Dark-Fear> my friend i mean will
<amette> stable mostly
<Dark-Fear> the old p***word thing is all I did ever
<Darien> amette: try doing an aptitude update && aptitude upgrade
<amette> Darien : did today - now new packages to install
<Darien> ok
Return to
#mysql
or
Go to some related
logs:
fail2ban vs denyhosts
#sdl
Ubuntu port 1720
0xf5 ubuntu shortcut
renewip
audacity for kunbuntu
puppylinux vlc
gaim webdings
#php
#perl
|
|
