#mysql
05 October 2007
Total 19 pages. You are browsing page 3/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
03:00 <****> balwww: I believe quite a few, but it SHOULD be backwards compatible
03:01 <****> TheFearow: well, the question I guess is did 5 introduce a capability or syntax with group that is being used in that statement that did not exist in 4
03:03 <****> i got linux installed...got apache working.... now how do i use sql...
03:04 <****> i got it instalelled.. and learned html myself.... just need to know how to make the database... anyone?
03:04 <****> Fiveothree: do you have mysql installed?
03:04 <****> yes
03:04 <****> guys
03:04 <****> Fiveohthree: use phpmyadmin
03:05 <****> how can i delete all the item's in my item table that have class1 like '90%', but only if (SELECT n_factor1 FROM code_value WHERE code='THISSTORE') IN (33,53,3300)
03:05 <****> open in the terminal?
03:05 <****> and how do i send messege to you showing in red like that?
03:05 <****> Fiveohthree: get it here http://www.phpmyadmin.net/home_page/index.php
03:05 <****> baalwww: Probably a few
03:06 <****> Fiveohthree: Use their name somewhere in the message
03:06 <****> Fiveohthree: download it and drop it into your html directory, and you can use it to create and manipulate mysql db's
03:07 <****> TheFearow: ok...I guess it's time to RTF(old)M
03:07 <****> baalwww is php mysql?
03:08 <****> Fiveohthree: php is a script language, typically the one used with LAMP (Linux, Apache, Mysql, php) ... I would install that too if you don't have it already
03:09 <****> baalwww lamp?
03:09 <****> oh l a m p
03:09 <****> got it
03:09 <****> i got Ubuntu and apache and mysql
03:09 <****> Fiveohthree: and phpMyAdmin is a tool for mysql written in php
03:10 <****> Fiveohthree: ok, no hablo Ubuntu, so I can't help ya there
03:13 <****> hello
03:14 <****> I am having an issue trying to create a view
03:27 <****> so i i want to make web data base with picures and hyperlinks. then mysql will work right?
03:27 <****> Supermaniak: Did you have a question?
03:28 <****> Fiveohthree: Right.
03:29 <****> baalwww: can you give me exact link to download from so i dont get the wrong thing
03:29 <****> baalwww: there lots of stuff there
03:29 <****> Xgc: hi, yes I'am having a strange error, on one server I can run a view without problem (easyphp2.0b) but I can't do the same on my hosting, the error is "#1271 - Illegal mix of collations for operation 'concat'"
03:30 <****> both run MySQL community 5.0.x
03:30 <****> since this works once locally and not remotely, I find it strange
03:31 <****> i did.. i got it from sudo apt-get install mysql-server
03:31 <****> Supermaniak: your php scripts are exactly the same?
03:31 <****> MySQL 5.0. right
03:31 <****> yes, I actually run it from phpmyadmin and the exact same query
03:32 <****> with exact same tables
03:32 <****> Supermaniak: check your web browser charset
03:32 <****> is it the same version of phpmyadmin?
03:32 <****> so i can use phpmyadmin to make mysql databases?
03:33 <****> Supermaniak: try "show variables like 'char%'" from both phpmyadmin and compare the result
03:33 <****> no, one is 2.9.1.1 and one is 2.11.1
03:33 <****> Supermaniak: try "show variables like 'coll%'" from both phpmyadmin and compare the result
03:34 <****> Supermaniak: that might make a difference, collation in mysql is configurable on the client side, and connection dependant
03:34 <****> except character_sets_dir value it's all the same
03:35 <****> dir is not important, if the rest are the same including the collation part, then it is the phpmyadmin scripting issue
03:35 <****> in the different version
03:35 <****> so I can downgrade server phpmyadmin and try it again
03:38 <****> k so i cant extract the phpmyadmin i downloaded cause says i dont have permissions.
03:49 <****> well even with downgrade of phpmyadmin it doesn't work !
03:59 <****> anyone knows what ./mysqld/mysqld-bin.000004 is for?
04:04 <****> any idea ?
04:14 <****> eromero: binary log, all your updates.
04:14 <****> for replication or point in time recovery
04:31 <****> anyone wana help walk me thru using phpmyadmin?
04:31 <****> how so
04:32 <****> Fiveohthree, step1: delete /phpmyadmin; step2: install navicat; step3: profit?
04:32 <****> SDr: is it really better?
04:33 <****> Fiveohthree, in the sense, that you don't need to wait a full HTTP req/response, html rendering, post submit, etc, but rather use the rich client features? yes.
04:33 <****> SDr, im total newbe to lamp
04:34 <****> SDr, just want to start making databases
04:34 <****> Fiveohthree, the only disadvantege you might come across is crappy hosting providers, who doesn't allow direct access to mysql; you'll need phpmyadmin there
04:34 <****> SDr, im runing box in my house
04:35 <****> then navicat is a more ideal choice
04:35 <****> SDr. has ubuntu, mysql 5. apache
04:35 <****> im also having issues with permissions in linux
04:35 <****> hi
04:35 <****> how to recover mysql root password for windows
04:35 <****> can you explane how they work?
04:35 <****> version 4.1
04:36 <****> whats the diffrence between mysql 5 and 4
04:36 <****> Fiveohthree, can you connect to mysql via the command line interface?
04:37 <****> is that in the terminal?
04:37 <****> Fiveohthree, yeah
04:37 <****> pbmh: 5 and 4.1 or 5 and 4.0? 4.0 and 4.1 are VERY different
04:37 <****> im so new to this.. i know html up the ass, but thats it
04:37 <****> !ell kareena about reset root
04:37 <****> !tell kareena about reset root
04:37 <****> kareena See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
04:37 <****> mysql what do you get?
04:38 <****> thank you
04:38 <****> i moved to a dedicated server
04:38 <****> SDr: probably an error
04:38 <****> and they only support mysql 4
04:38 <****> my old server has mysql 5, all my dbs are under 4
04:38 <****> pbmh: 4.1 or 4.0?
04:38 <****> when i try to port over all the databases i keep getting errors
04:38 <****> i have to manually remove stuff
04:39 <****> SDr, Error 1045(20000):Access denided for user 'brandon@localhost'(using password: NO
04:39 <****> Fiveohthree
04:39 <****> mysql -uroot
04:39 <****> the_wench this work also for version 4.1 ?
04:39 <****> kareena: the_wench is a bot and yes
04:39 <****> ayepp, what chadmaynard said
04:40 <****> type mysql -uroot?
04:40 <****> ok thx
04:40 <****> kareena: click on the 4.1 link on the top right hand corner : )
04:40 <****> :)
Total 19 pages. You are browsing page 3/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last