| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> got one other
<0> http://hashmysql.org/paste/1436
<0> I get for both of those Query OK, 0 rows affected
<0> the answer_options table has a foreign key to the answers table
<1> #php
<0> hehe seen that name before
<2> hello everybody
<3> is there a way to LIMIT by percentage?
<0> zaphod: your not perhaps from or in NZ are you?
<2> i have problem with user table crash. How can i repair it?
<4> psykick, he's from Betelgeuse of course
<0> ahhhh ...
<0> had a friend in NZ with the same nick
<5> secretar3000: is mysql.user corrupt?
<4> the second head didn't throw you off?
<5> secretar3000: or some other table
<0> can anyone help with the 2 stored procedures I put on paste bin?
<0> they're just simple delete statements
<6> Psykick: what is the problem then
<2> TodoInTX: [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
<4> [xeno], take a record count, and then a percentage of that
<5> ok.. run 'REPAIR TABLE mysql.user; FLUSH PRIVILEGES"
<2> i cant start server
<5> use skip-grant-tables in [mysqld] of my.cnf
<0> lokus: the statements don't delete what they're supposed to
<2> TodoInTX : ohh thanx:)
<0> lokus: or they just don't delete full stop
<6> Psykick: did you try the delete itself and if that delete anything
<0> if I execute the stored procs from CLI I always get Query OK, 0 affected rows
<4> maybe there are none to affect. did you check the values manually to see if it should delete any rows based on the data?
<6> Psykick: or try a select first to see if any rows match the condition as a test, then delete
<7> hi
<7> is anyone familiar with the regex text importer? i have a simple question
<5> infi: actually Ford was from Betelgeuse.
<4> todointx, I realized that shortly after saying it :\
<4> or rather, "a small planet in the vicinity of Betelgeuse"
<7> how do you extract the name and date form a file like this: "Name: Ford Prefect\nDate: 2000.01.01" ?
<4> bandesz, using what? shell? perl? ruby? pascal? ***embly?
<7> i mean to create a query INSERT INTO hhgttg(name,date) VALUES ('Ford Prefect','2000.01.01');
<7> using the query browser
<4> I don't think load data infile is that versatile. you'll probably have to extract it to a more useful format.
<7> it has a pcre library so it should be able to do it
<7> i just don't know how to p*** the variables to the query
<7> so it's basically perl
<4> pcre != perl
<7> yeah, i know, but close to it :)
<8> Hey folks... I was wondering if I could get a hand with a minor issue
<4> $name =~ /Name:\s?(.*)/; $date =~ /Date\:\s?(.*)/;
<4> or something along those lines. IN PERL.
<8> I'm planning on migrating my webserver from Fedora Core 3 to Ubuntu linux. I'm setting everything up on a Virtual Machine right now as a run through.
<4> pcre may or may not be compatible.
<8> I used MYSQL dump to pull my blog database out and it tells me I have syntax errors when I try to reimport it
<7> thanks infi, i'll give it a try
<8> I don't know much about MySQL so I don't know how to trouble shoot this
<8> anyone?
<5> different versions of mysql?
<5> spazzz: ?
<8> TidiUbTX: Probobly, I honestly don
<8> 't know.. I havent worked on the software on the server in forever because Fedora is so cumbersome
<9> when you open the mysql client and have it connect
<9> it will print the version of the server it just connected to
<8> *sighs* I hate being a noob
<9> i was a n00b once
<8> I'm trying to use mysql help at the command line so I can connect to the server and find that out and all it tells me is access denied
<8> Dosen't tell me what commands do what like normal
<9> mysql -u username -p -h host/servername
<9> is what i use most of the time
<8> ok let me try
<8> It says this host is not allowed to connect
<8> Ok i'll SSH in and do it directly
<9> are you running it on the same pc as the mysql server?
<8> the webserver? Yes\
<9> then you probly dont need the -h
<9> try
<8> Well im not ON the server
<9> mysql -u username -p
<9> but the mysql cmd is being ran there?
<8> ............. I don't understand. I'm on my personal computer, the Server is on a different computer.
<9> yeah
<8> the webserver and SQL are both on that machine but that isn't the machine i'm on at the moment
<8> I'm going to SSH into the server and execute the command from there
<9> but are you loged in remotely with a program like ssh/putty?
<8> No but i'm about to be *heh*
<9> ahh k then the mysql cmd itself is running on the same pc as mysql
<8> Yes in a second it will be
<9> so you wont need the -h option
<8> Right
<8> ok.. Sorry just me *heh*
<9> clever@laptop:~$ mysql -u root -p
<9> Enter p***word:
<9> Welcome to the MySQL monitor. Commands end with ; or \g.
<9> Your MySQL connection id is 5 to server version: 4.1.12-Debian_1ubuntu3.1-log
<8> Welcome to the MySQL monitor. Commands end with ; or \g.
<8> Your MySQL connection id is 89 to server version: 4.1.16
<9> is what i got when i loged in
<9> k
<9> now repeat with the second copy of mysql
<8> ok
<8> Server Version: 20.024_Debian-10ubuntu2-log
<9> hmm
<8> excuse me
<8> I mis typed
<9> mysql> select version();
<9> +------------------------------+
<9> | version() |
<9> +------------------------------+
<9> | 4.1.12-Debian_1ubuntu3.1-log |
<9> +------------------------------+
<9> 1 row in set (0.30 sec)
<8> 4.0.24_Debianyada yada
<9> i think the mysql in uduntu is a older copy
<8> joy so the databases arn't compatable?
<9> you could try downloading a newer/newest from www.mysql.com and upgrade it
<8> ......... I would have no idea how to go about that
<9> they arent 100% backward compt
<9> you cant take a backup from ver 10 and use in ver9 easyly
<8> *sighs* Lovely
<8> I'll have to manualy put everything in
<9> you can also just upgrade the mysql
<9> or manualy remove the offending bits of mysql code in the whole dump
<8> I can't tell what its complaining about to do that. I have the most recent version from the repositories and I have no idea how to build from source
<8> meh... oh well
<8> clever: You don't have to go through all that trouble
<8> Which one would I have to even upgrade the UBUNTU copy or the one on my Fedora Machine?
<9> the ubuntu
<9> its a older version and cant understand whats comming from the newer fedora
<8> The one on the fedora box I think isn't the newest
<9> i think both are old
<9> but the ubuntu is older
<8> well then upgrading the Ubuntu one won't do me much good.
<8> will it?
<9> it will make the backup load properly
<8> Alright
<8> Can you tell me about how long this will take?
<9> maybe 10-20 mins
<8> alright if it won't inconvenience you too much i'll go through it with you
<8> But I may ask alot of questions. I like to understand what i'm doing. I hate just being TOLD to do something. I don't think i learn much that way *heh*
<9> yeah thats good:)
<8> alright
<8> I tried compiling Cedega from source once it didn't work but I should have all the compilers and such I need
<9> do you have any compiling tools installed on the uduntu?
<9> k:)
<8> you read my mind
<8> *heh&
<8> ohh wait
<9> and i had a copy of cedega and wine working before i formated and went to ubuntu
<8> No i don't... Not on the virtual machine
<8> Hold on let me get that.
<9> k:)
<8> Build-Essensial right?
Return to
#mysql
or
Go to some related
logs:
mysql c cast MYSQL_ROW to char **
failed to bind to LDAP server ldap 636
#debian
install python damn small linux
#perl
#lgp
#suse
concating strings bash
AttributeError: JpegImageFile instance has no attribute '__getitem__'
NVRM: No NVIDIA graphics adapter found! +ubuntu
|
|