#mysql
05 October 2007
Total 19 pages. You are browsing page 4/19.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
04:40 <****> ok
04:40 <****> yeah
04:40 <****> welcome to mysql
04:40 <****>
04:40 <****> Fiveohthree, show databases
04:41 <****> Fiveohthree: the next step is "SELECT 'chadmaynard is the MAN' `Motto`;"
04:41 <****> is it possible to modify version or version_comment, both or just one in my.cnf?
04:41 <****> came up
04:41 <****> show databases;
04:41 <****> type a ;, and hit enter
04:42 <****> (Each command is closed by a ; sign)
04:42 <****> so show database;
04:42 <****> assuming ; is the delimiter
04:42 <****> Erro
04:42 <****> Fiveohthree, try again
04:42 <****> databaseS
04:42 <****> you have an err in your sql syntax;
04:42 <****> plural
04:43 <****> cool
04:43 <****> database information_schema mysql
04:43 <****> Fiveohthree, grab this: http://www.navicat.com/download.html ,and try connecting
04:43 <****> any freelance people here?
04:43 <****> im willing to pay somebody to import 20 databases
04:43 <****> haha
04:44 <****> SDr i did sudo apt-get install navicat
04:44 <****> pbmh: what's the error?
04:44 <****> hello, mr. phmh. What $eem$ to be the problem? ;)
04:44 <****> lol
04:44 <****> We don't accept money but we'll help you free of cost if you help yourself
04:45 <****> then help me too :P
04:45 <****> Fiveohthree, wow, ubuntu has navicat in it's software repository?
04:45 <****> SDr i had friend update me
04:45 <****> i've asked 3 questions yet here, none was answered
04:45 <****> SDr but he gone now
04:45 <****> majmun: i addressed you!
04:45 <****> SDr how do i open navicat now?
04:45 <****> majmun: I asked you TWICE whether you were using 4.0 or 4.1
04:46 <****> huh?
04:46 <****> i'm using 5.0.45
04:46 <****> i thought you said you downgraded
04:46 <****>
04:46 <****> no, you must be talking about someone else
04:46 <****> Fiveohthree, uuh, I don't really think apt-get would install navicat, what with navicat being a commercial software, and all, so you're better off downloading it, and running it's own installer ( http://www.navicat.com/download.html )
04:46 <****> majmun: Oh yes i mixed you up
04:46 <****> my problems are:
04:47 <****> open_files_limit = in my.cnf doesn't seem to be interpreted, i'd also like to know if the vars "version" and/or "version_comment" can be modified
04:47 <****> my 3rd question is: how to disable logging? "skip-log" doesn't work
04:49 <****> majmun: there are a lot of different logs. Which one are you disabling?
04:49 <****> Sdr wehre shoudl i extract it to?
04:49 <****> The skip logs, of course.
04:50 <****> SDr where should i extract to?
04:50 <****> Xgc: are you being humorous?
04:50 <****> haha
04:50 <****> Fiveohthree, /home/yourusername would be fine
04:51 <****> well, the system-var "log" is set to ON
04:51 <****> SDr, how come i cant make a file under /media/disk/ program files
04:51 <****> ok great
04:51 <****> as far as i understood that, it's the log mysqld creates for every query
04:51 <****> uh, no...that every-query-log is the bin_log, ...right?
04:52 <****> SDr, kk run in terminal or display?
04:53 <****> majmun: yes the binary log is the one with each transaction that you can't read with a text editor
04:54 <****> SDr, ?
04:54 * chadmaynard is at the beach.
04:54 <****> Fiveohthree, uuh, I'm using windows, haven't used navicat on linux at all, so have no idea; it's a graphical application
04:54 <****> and what is that one which is "log" as system-var?
04:54 <****> k
04:54 <****> i've got it here: "log ON"
04:54 <****> log_bin is of
04:54 <****> f
04:55 <****> SDr, k it opened. said is 30 day trial.. its not free?
04:56 <****> Fiveohthree, get your key at your local warez center ;)
04:56 <****> rofl
04:56 <****> SDr :)
04:56 <****> any ideas to at least one of my questions..? :P
04:57 <****> SDr, k now what.
04:57 <****> Fiveohthree, after connecting, it will display the databases, tables, etc, in a tree-like fashion
04:57 <****> show databases;
04:57 <****>;
04:57 <****> SDr, yea is blank now
04:57 <****> show tables;
04:57 <****>;
04:58 <****> Fiveohthree, file / new connection
04:58 <****> SDr. k
04:58 <****> Fiveohthree, poke it until test connection returns successfull
04:58 <****> hello
04:59 <****> im trying to import a file via shh
04:59 <****> and im getting this error
04:59 <****> ERROR 1064 (00000) at line 12: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci' at line
04:59 <****> SDr, i just clicked test and said test sucessful
04:59 <****> im moving from a mysql 5 to 4
04:59 <****> Fiveohthree, ok, connect, etc
04:59 <****> funpic?
04:59 <****> SDr, should i name the connection?
04:59 <****> Fiveohthree, yeah
05:00 <****> SDr, local host... information_schema .. mysql
05:00 <****> bye
05:00 <****> see ya
05:01 <****> SDr, now just make a table?
05:01 <****> Fiveohthree, create your test database first
05:01 <****> SDr, i want to be able to query it from my website and search all records for key words (so you know my goal)
Total 19 pages. You are browsing page 4/19.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last