| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> are u magic ?
<0> if so im the magic mushroom monster
<1> they call me mr wizard..
<0> im tryna import a .sql file onto a new webhost
<0> using phpmyadmin 4
<0> mysql 4 even
<2> HarrisonF, what about using a CASE flow?
<1> super!
<1> take this potion.
<3> ahhhhhhhhh
<3> I see now
<3> !!
<2> HarrisonF, like CASE the demographic ID ?
<1> may it provide you light in dark places.
<3> thanks will
<4> :)
<5> 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?
<4> I've never used it, so... good luck!
<3> lawl
<3> just used the old pw thing ehh?
<3> its what I did
<4> !m liran backup
<6> liran: (Database Backups) : http://dev.mysql.com/doc/mysql/en/Backup.html
<4> Dark-Fear, Yep
<3> but apprently my friend tried with my server config
<3> and old p***words thing
<3> and it refused to work
<4> Maybe he did it wrong. He's not as smart as you.
<3> he dl'ed this phpdev pack
<3> and it worked find
<3> *fine
<3> I looked at the config files
<3> and I see nothing weird about them
<3> I think I might try to install what he did on my server and see
<3> if it works he messed up
<5> thanks
<5> 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?
<4> mysql [options] < file.sql
<7> mysql db < file.sql
<5> oh i see. that's rather easy. so mysqldump just dumps an .sql file format?
<4> Yes
<5> thanks again.
<3> thats exactly what they did will
<3> they matched the client versions
<3> runny a older version of mysql
<3> like version 3.somfin
<4> somfin?
<4> That's not a version
<3> :P
<3> its like 3.1.14
<3> Im not sure
<8> hah
<3> but they did match the client versions up
<3> sheeshe sooo literal
<3> :P
<4> ****s to be them
<3> ?
<3> whys that?
<4> They are dumb. You are so much smarter. You should take over their job.
<3> har har
<3> its a friend
<3> I just like to understand whats going on
<4> You should steal his girlfriend. You deserve her more.
<3> now I know for next time I do a server
<3> his gf left him
<3> or he left her
<4> For you!
<3> not sure which
<4> Must have been because he was dumb.
<3> hes a bright fella
<9> Maybe she was ugly anyway
<3> just doesn't do much with webservers
<4> If he's so bright, how come he can't figure out MySQL?
<8> the gf?
<4> It's piece of cake.
<3> he was using IIS!!!
<3> I almost cried
<4> IIS is great.
<3> Im not a fan
<4> Maybe you should
<3> I like apache alot more
<4> alot huh?
<3> yuppers
<4> Is that like Apache2?
<4> Apache Alot, ?
<3> no
<3> :P
<4> What is "alot"?
<3> argh!!
<4> What?
<3> I just prefere it then
<3> happy?
<3> I haven't done much with IIS I guess so to be fair
<2> is creating a mysql table with 100 rows a bad idea?
<2> err
<2> fields ;)
<3> and the last time I played with it was when it was open to IIS hacks
<4> If you need the fields, no it's not bad.
<2> will, I'm suffering a situation here.. and am going to go type up the issue ;)
<4> ok!
<4> Until you do, I will continue mocking Dark-Fear
<2> lol
<4> What is prefere?
<3> until I what, will?
<4> Until you explode!
<10> boom
<4> ewww, he's all over me.
<4> Are you doing that in a ***ual way?
<10> sure
<11> 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... :-/
<11> .. mysqld_safe mostly restarts it, sometimes it doesn't work - I get corrupted tables in Syslog - fixing them, some minutes later same problem..
<10> amette: what does the error log say?
<11> .. when I try to do a backup of my databases, I get: Can't find file: 'file.frm' (errno: 23) when using LOCK TABLES
<10> !perror 23
<6> System error: 23 = Too many open files in system
<10> something is ****ing up file descriptors
<11> 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
<11> 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.. :-/
<10> ok
<10> amette: debian-sys-maint is the user that Debian creates to run a 'CHECK TABLES' whenever you start the server
<10> amette: it sounds like there are a lot of processes with open files
<11> 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
<10> amette: can you pastebin the contents of /proc/sys/fs/file-nr and /proc/sys/fs/file-max ?
<11> http://hashmysql.org/paste/viewentry.php?id=1481
<2> Can anyone give me any suggestions as to? http://pastebin.com/569261 ? I've dug myself into a hole here ;)
<2> will, if you've got the time, I wrote up the situation
<10> amette: ok, so I don't think it's a file handle issue
<2> HarrisonF, provided me w/ a nice example.. however I don't know how it'll scale
<10> amette: perhaps it's a ulimit issue
<11> 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.. :-/
<10> amette: can you pastebin a section of the logs that shows everything, start to finish?
<11> 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
<11> Darien : one moment
<10> amette: what version of mysql again?
<11> mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
<10> ok
<10> are you running stable, testing, or unstable?
<3> lawl
<3> he did it wrong
<3> worked for me
<3> my friend i mean will
<11> stable mostly
<3> the old p***word thing is all I did ever
<10> amette: try doing an aptitude update && aptitude upgrade
<11> Darien : did today - now new packages to install
<10> 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
|
|