| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> do NOT pmsg me
<0> i cant reply
<0> and I couldnt care less
<1> frank-: sorry. i don't want send url to public
<0> either way
<0> I dont use phpmyadmin
<1> ok
<0> try with the command line client FIRST
<0> make sure that works
<0> then fix phpmyadmin
<0> also I would never ever send a link to my phpmyadmin to anyone, for security reasons
<0> birk: just reinstall your db then?
<0> if you don't have any valuable data
<2> franc: I just installed it today. Is the database the problem? When I try to change the p***word I get this: 18:48:52 [Warning] Changed limits: max_open_files: 2048 max_connections:
<2> table_cache: 64
<0> just wipe off your mysql install and start over
<2> it was done with appserv to make it more simple to do
<0> I never heard of appserv
<0> what linux distribution are you using?
<2> installs php, mysql, apache, phpmyadmin in one installation. It is a project on sourceforge
<0> what linux distribution are you using?
<2> win32 :(
<0> I never used win32
<0> sorry
<1> birk: I'm using appserv sometimes
<1> appserv version?
<2> Tulga: 2.5.5
<2> thanks frank anyways :)
<0> np
<0> I'm a unix guy
<1> sometimes your apache crash?
<2> no. I just get errors when I try to shut down mysql
<0> google the exact error, for starters
<1> I think it is php.ini problem
<0> aha.
<1> I get same errors sometimes. then I use task manager :D
<2> same here
<1> do you use appserv for server? or only testing?
<2> only testing. is my mysql running without a p***word now?
<1> appserv installation asks mysql user and p***word
<2> I wrote my settings there like it required.
<1> if you get p***word: NO, then your root withour p***word
<1> I suggest you use ubuntu :)
<2> When I change the p***word in the php code I use to connect to the db it says it can not connect because access was not given. Doesn't that mean that I have security on for the mySQL server?
<2> I just want to make sure I am not one big security hole
<1> it is not big security hole. because it is your testing and running your pc
<3> Could someone take a look at this... http://hashmysql.org/paste/1861
<4> is it faster to select an int value than a varchar?
<5> Sure.
<6> __Kaz: you don't have the whole query up nor do you actually indicate what order you want field1 in the second. if you want to sort first field1 descending, then it's ORDER BY field1 DESC, field2 DESC;
<5> __Kaz, ORDER BY field1 DESC, field2 ASC
<5> :P
<4> k... i'm doing a little optimizing and wondering if it's faster to store the string "mm:ss" vs having a "minutes" column (int) and seconds column (also int) and select them instead of the full string
<5> You could store it in the number of seconds... All depends on your application.
<5> Yes, it could be faster to get the data in one way, but if you have to reprocess it for the way you want to use it...
<4> yeah, storing the seconds is what i'm currently doing ... however, i have to process the seconds for every select and transform them into "mm:ss" format ... i'd rather cut down on the select loads and instead would like care of this during the initial write process...
<5> It all depends on what you do with the data...
<5> For example, if you had one DB server and many app servers, you may do the SS -> MM:SS processing on the app server.
<5> Need to look at whole picture.
<4> all i need to do with the data is display the string "mm:ss" when it's selected
<7> hello
<5> The difference between two INTs and one VARCHAR is trivial.
<4> ah ok
<4> thanks
<5> When strictly dealing with retrieval and no processing.
<5> If you need to process, it all depends.
<8> will in the hizzy
<7> how to oder a select starting from a definite number (ex starting from 1000)
<7> ?
<4> yeah, strictly retrieval ... i was hoping to cut some ms off of every select
<5> gleam_ out of the hizzy
<8> what do you mean Onizuka
<8> ?
<4> Oniz: are you familiar with LIMIT? If not check out http://dev.mysql.com/doc/refman/5.0/en/select.html
<7> Styles722: I don't need limits but how to order
<8> i don't think that's what he wants
<8> but i'm not sure
<4> hehe
<7> I need also the results before 1000
<8> so you want the results > 1000 first, and then the results < 1000?
<7> 1000 first and all the rest after 1000 after that the remaining values
<7> 1000,1011,1050,2000,50,60
<8> order by col < 1000, col asc
<7> instead of 50,60,1000,1011,1050,2000
<8> try that
<7> ok
<8> and?
<9> I just dumped a mysql database using the --xml command, how do i import that dump to a new database?
<10> Hello
<10> What version of client files ship with version 5.0.21?
<8> ... 5.0.21
<10> good!
<10> thanks
<11> does anyone have an idea why the examples at http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html aren't working?
<11> I'm trying to use the spatial extensions to develop a reverse geocoding database
<12> i need a free webhosting with php support
<13> www.altervista.org php mysql (italian)
<12> i need a free webhosting with php support
<14> why free, when there're so many nice paid options
<8> because he's cheap.
<12> sinces i don`t have money can u help me to pay then?
<8> how are you on irc w/o money?
<12> what
<12> ?
<12> i don`t understand u
<8> if you don't have any money, how do you afford a computer, internet access, etc?
<8> onizuka couldn't even tell me if it worked. jerk.
<13> smith007: if you can pay for the connection you can also pay for a paid hosting plan that doesn't cost too much (about 36euro/yr)
<8> onziuka, did it work?!
<13> gleam_: nope
<8> darn
<15> smith007: http://www.free-webhosts.com/free-mysql-database.php
<13> onthost-sleep: http://meta.wikimedia.org/wiki/Xml2sql
<8> what was wrong iwth it?
<15> smith007: you're going to have to live with adds, though
<13> gleam_: wrong results
<8> were they ordered at all?
<13> it order starting from the lower value
<8> you did order by col<1000,col?
<13> yes
<8> that sohuld put the ones > 1000 first
<15> Onizuka_, onthost-sleep: note that MySQL's XML dumps are completely different from mediawiki's XML dumps.
<13> Duesentrieb: I've tried it once and it worked
<8> you didn't do col>1000 thinking i was making a typo did you?
<15> Onizuka_, onthost-sleep: Xml2sql converts a mw dump into an (my)sql dump. I don't thin k tehre is a tool to convert a mysql-xml dump to anything mediawiki would take as an xml import.
<15> Onizuka_: you used it for whatexactly? the two dump formats are not even remotely similar.
<15> even if both are "xml"
<13> Duesentrieb: on a normal db
<8> onizuka, i don't believe for a second that what i gave you doesn't work.
<13> gleam_: maybe I've done something wrong because I've to oder using more than one column
<8> well, what do you need to order by?
<13> gleam_: height width depth
<8> what exactly are you trying to do?
<15> Onizuka_: what is a "normal db"? how is it related to mediawiki dumps?
<13> as said before ordere the results of a select to get the values starting from the user input data
<8> yes, onizuka, but do you realize that when you order by multiple columns each column you add ust orders within the results of the previous?
<13> Onizuka_: a mediawiki and a module dump
<8> e.g. if you have col1 = 0,1,2,3,4,4,5 and col2 = 9,8,7,6,5,4,3
<8> and you order by col1,col2
<8> it won't magically return random data
<8> it'll still be 0,1,2,3,4,4,5 but within the rows that are identical for col1 it'll order by col2
<13> I've sorted using width<submittedwidth, height<submittedheight, depth<submitteddepth,
<13> and I've a result that orders a bit as desired except for the first 5 records
<13> (ascending)
<13> Duesentrieb: you are completely right it doesn't work with dumps completely different from wikimedia
<13> Duesentrieb: sorry for the bad information
<16> Hello. Is anyone here familiar with the charset problems occuring when copyinf data frommysql 4.0 -> mysql 4.1?
<14> !m AndreasB upgrading 4.0 4.1
<17> AndreasB: (Upgrading from Version 4.0 to 4.1) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
<8> onizuka, just realize that it doesn't order the rows all at once
Return to
#mysql
or
Go to some related
logs:
#suse
linux 1400x1050 frambuffer
ip_conntrack_netbios
mike12341
#perl
#egghelp
FIREFOX_DSP gentoo
#osdev
suse 10.1 lxml
#ubuntu
|
|