RE: quick questions...

2004-07-05 Thread VWilliams
> -Original Message- > From: Levi Campbell [mailto:[EMAIL PROTECTED] > 1. what do I need to know for the exams? I'm trying to keep this in mind, http://www.mysql.com/training/certification/candguide/, while I use the My SQL Certification Study Guide by DuBois, Hinz and Pedersen. > 2. wo

quick questions...

2004-07-05 Thread Levi Campbell
So now that I know that there's no place around to take courses and where to take the exam I've decided to teach myself and I have two quick questions. 1. what do I need to know for the exams? 2. would it be better to practise on a UNIX-bases system? -- MySQL General Mailing Lis

RE: Three quick questions about using MySQL

2004-06-04 Thread Mechain Marc
See answers in the message below. Marc. -Message d'origine- De : Ben Clewett [mailto:[EMAIL PROTECTED] Envoyé : vendredi 4 juin 2004 10:37 À : [EMAIL PROTECTED] Objet : Three quick questions about using MySQL Three quick questions, I hope you can help me. Using InnoDB on ve

Three quick questions about using MySQL

2004-06-04 Thread Ben Clewett
Three quick questions, I hope you can help me. Using InnoDB on version 4.0.18 Firstly. It's possible to get information on a table. Which includes the number of rows. This returns instantly. However, if I do a SELECT COUNT(*) on the same table, this can take a number of minutes to r

Re: 2 Quick Questions

2004-01-15 Thread john . everitt
> Then the next problem is with WinMySqlAdmin. How in the heck do I change it > to login in as root and show all the databases etc. Right now it is showing > only the test DB and user as Administrator. Everything appears in grey and > can't be changed? Add the following lines to your my.ini

Re: 2 Quick Questions

2004-01-14 Thread robert_rowe
Why use WinMySqlAdmin to view databases? The MySQL Control Center has a lot more features and its usage is very straight forward. If you are referring to the name that you gave it the first time you ran it then I don't know. I'm curious about how to set it myself. -- MySQL General Mailing Li

2 Quick Questions

2004-01-14 Thread Chris L. White
Quick Question Here: I think I may have figured out my little problem with the thing wanting to use localhost as opposed to the actual name of NapMarilu. Could it be that when the server 2003 machine was originally setup before the installing of MYSQL that in the IIS portion of the machine, th

Re: quick questions about redhat and mysql

2002-01-25 Thread Philip Molter
On Fri, Jan 25, 2002 at 10:18:08AM -0500, John Kemp wrote: : Hank, : : 3. Do not use the RH mysql version. Get it from the Mysql website, and : use 3.23.47-max (which includes Innodb support) or higher. What's wrong with the RH mysql version? I've been using it for 5 months without a problem.

Re: quick questions about redhat and mysql

2002-01-25 Thread John Kemp
Hank, 1. RH 7.1 supports files > 2GB if you choose the Enterprise/SMP flavour (you'll be asked to choose which install you want to pursue when you put the install CD in) No kernel re-compile needed. 2. MySQL will support large files. Also, if you use Innodb tables, many of the large file conce

quick questions about redhat and mysql

2002-01-25 Thread Henry Hank
Hello, I am trying to decide which OS to use for a dedicated mysql server for my website. I need filesize >2GB support. I really wanted to use Solaris, but there are no drivers for my RAID adapter (long story). I was considering NetBSD, but I don't know it well. I was then back to thinking

quick questions - wierd

2002-01-16 Thread samit darne
running isamchk -eis and -o gives me following output 1) impossible length!!! does anyone got this before? 2) recordspace used: 100% ??? what does this mean? I have plenty of space on my hard drive # isamchk -o trend_data - recovering ISAM-table 'trend_data.ISM' Data records: 2371874