| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> so you need to create the index on, say, textcol(1000)
<0> to index the first 1000 characters
<0> or textcol(50)
<1> ah
<2> hey, i'm trying to get php working with mysql, and I'm looking for a package something like "PHP-MySQL" however, there are no ebuilds to satisy "php-mysql" anyone know what this package is called? It is for loading mysql extensions
<3> oh, it's you again ;)
<0> ask #gentoo
<2> they say to as at #mysql
<2> because it's mysql specific..
<3> go to #readalittlebeforeyouaskamillionbasicquestions
<0> ask either #php or #gentoo
<0> it's distro specific.
<2> ok
<0> and read funroll-loops.org
<0> and pick a better distro
<3> I don't think debian is the distro for you, honestly
<3> try debian.
<2> ...
<0> or at least one with a better community
<3> seriously, it will do you good.
<2> it's on an xbox and the xbox doesn't support debian as well as it supports gentoo
<4> build php with the mysql use flag
<0> christ
<0> ask #xbox then
<4> people in #gentoo should have helped you
<3> and are you trying to make a web server out of an xbox?
<2> yes
<3> just get a normal pc and get it over with
<4> Fr0zt: that's cool you are challenging yourself
<3> fwiw, php DOES include the php-mysql module you need, so if you installed it all, it should be there
<5> how do i increase the mysql cache ? I have 2gb ram and want mysql to use more memory :)
<0> which cache?
<5> beats me, it says something about cache in the link to "selecting a platform for mysql" on hashmysql.org..
<5> gleam-: whatever makes my db go faster-cache :)
<0> key_buffer_size, innodb_buffer_pool_size, query_cache_size, etc
<5> thanks.
<6> can I do a LIMIT from a row like get the next 30 rows from $key=lastkey?
<7> how do i create
<7> how do i create a user that has full power over a database?
<5> !m GRANT
<8> Biri bana yardmc olabilir mi ?
<3> of course!
<8> yaa bu access'te NOT die snrsz veri tanmlyoruz ya onu MysqL'de nsl yaparm ?
<7> can one user manage multiple databases? and is that a good idea?
<8> I want to use UNLIMITED value in MysqL. not char not varchar. But I dont know.
<9> hi all
<9> how select all records that only have numbers in the field: myfield varchar(250) possible values: 'AAA001','00005004' ...
<9> Moosh
<9> ?
<7> how can i verify that my MySQL server is running?
<5> run /etc/init.d/mysql status is you use linux
<10> yep ?
<11> telnet localhost 3306
<9> dibblego, Moosh anya dvice about:
<9> how select all records that only have numbers in the field: myfield varchar(250) possible values: 'AAA001','00005004' ...
<12> does mysql support database encryption ?
<13> DonJohnny, Yes.
<13> Define "Database encryption" actually.
<14> I have database design issue. I have a table of customers, a table of properties and a table of sales where a customer buys a property and an one-off sale is recorded. The sale is agreed at a price and the customer pays in installments. Any ideas on how I can record each payment transaction?
<14> and link that to each sale perhaps...(maybe reflecting the outstanding balance)
<10> ouch jak2000
<10> I have not better than
<10> 0 = locate('0',field)+locate('1',field)+locate('2',field)+locate('3',field)+locate('4',field)+locate('5',field)+locate('6',field)+ ...
<10> or .. an regexp
<9> with a regexp
<9> but how?
<10> http://dev.mysql.com/doc/refman/5.0/en/regexp.html
<9> thanks
<9> :
<10> I'm not very good with regexp but something like [0-9].
<10> as know that regexp can be slow, banchmarck and compare with my 'so long' version with locate
<9> Moosh: select * from table where field regexp '^[0-9]+$'
<15> i just moved from 4.1 to 5.0 but i'm having problems with autentication, if i telnet to the server it says that my host is not allowed to connect, i tried to add a line to host table in mysql db but nothing changed
<13> Deffie, Don't modify the host table.
<13> !m are you working yet?
<13> Deffie, mysql.com/adding new users
<15> hi will
<13> Hey you.
<15> i'm upgrading, it does have many users
<13> What is the exact error message?
<13> And don't telnet into the server. Use a mysql client.
<15> from the client it simply says access denied
<13> Exact error message.
<13> Copy and paste character by character.
<15> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: YES)
<13> You're using the wrong p***word. Easy one.
<14> could it be that instead of trying to connect to a remote MySQL server his is connecting to a local one (and hence the wrong p***word)?
<14> s/his/he
<13> Yup
<13> I was going to ***ume he knew what he was doing :)
<13> And with that, I must sleep
<13> nite.
<15> thank you
<15> nite
<15> anyway...
<15> yes i'm connecting to local server
<15> hm
<15> is it a problem ?
<15> with 4.1 everything was working
<14> Deffie, I don't even know what you are trying to achieve and what your set up is
<14> where does the MySQL server you are trying to connect lives?
<14> s/lives/live
<15> i'm upgrading from mysql 4.1 to 5.0, on a debian sarge
<14> yes but is this the machibe where you are logged on as well or is it a remote server?
<16> Hi. Does MySQL allow dashes in table names?
<15> i'm logged in via ssh as root so i'm trying to connect from local host
<14> Deffie, ok
<14> Deffie, then you are giving the wrong p***word
<16> no... needs back ticks apparently
<15> eleftherios about 15 different users are getting that errors
<14> Deffie, I don't know what to say :-/
<15> elephantMan hm ok :) thanks anyway
<3> Deffie: you need to do one of two things
<3> 1. dump all tables and import them into your new 5.0
<3> 2. do 1 (anyway) and turn off old p***word compability, if your 'mysql' database has been 'upgraded' by the debian install scripts
<3> if you don't dump/load your entire data from 4.x to 5.x you're asking for trouble -- and they will come.
<15> supastuff damn
<3> you really must dump/restore otherwise you can't rely on your db to perform/work and or return sane data to your queries
<15> fear
<15> really, i'm not joking
<3> why is that? :)
<15> i'm feeling fear
<3> got a few hundreds of gigs to dump/restore? :)
<15> thats one reason
<15> (a good one)
<15> another reason is that i've run the server with --skip-grant-tables
<3> once upon a time debian upgraded mysql from 4 to 5 for me, without even alerting me, of course it didn't dump/restore the data when doing so, so I had a lot of fun.
<3> that's ok, when you run it with this option you can update your 'mysql' table to the new format
<14> supastuff, on what version of Debian did that happen??
<3> but don't forget to restart it without this option soon after ;)
<3> unstable
<14> supastuff, I see
<3> I only use unstable, I really like production systems to blow up from time to time, otherwise it's not fun
<15> yes but in the meantime "the world" worked on the database which was running mysql 5 on 4.1 tables
<3> like now, with a buggie version of grub in unstsable that just won't boot without console access
<14> supastuff, running Sid on production systems in insane! (no offence intended)
<15> sid is testing...isnt it ?
<3> Deffie: I see. I think you should be ok for a dump though.
<3> eleftherios: you think so? Has been running ok for years ;)
<14> Deffie, testing is Etch
<3> I don't like old versions in stable
<3> and since I started using debian, I'm REALLY REALLY lazy about compiling stuff
<3> and I don't like it anymore ;)
<3> because debian keeps the system clean for me
<14> supastuff, neither you should compile stuff when on Debian. There are tens of thousands of packages ready for you.
<15> eleftherios with sarge being stable i tought sid become testing
<14> Deffie, Sid is always the unstable branch
<15> eleftherios ok i'm a noob :P
<3> eleftherios: if you use STABLE and are stuck with say an old version of php4, then sometimes you DO need to compile something, and that ****s.
<15> lets dump the whole world
<14> supastuff, you can always use backports. The point is that stable is really stable and the overall risk you are taking is minimal. With unstable you are taking huge risks in having a broken system for the sake of a few new (untested) releases
Return to
#mysql
or
Go to some related
logs:
ubuntu /boot partition grub file not found
matlab runlevel ubuntu
gentoo crosscompile howto
gentoo could not open default font 'fixed'
Easy Bake Meth Lab + Playa Doh
#gentoo
what is beagle indexing
qgrep error 2
atftpd: can't bind port :69
#linux
|
|