If you are brand new to mysql, you do not want to start with the
cluster. Try the community server distro instead:
here is a link to the 64-bit generic linux version:
http://dev.mysql.com/downloads/mirror.php?id=401067#mirrors
On Thu, Feb 10, 2011 at 10:33 AM, rohit bishnoi wrote:
> *hello ev
hi chuck...
i don't use windows, but are you able to get a cmd window up/running, and
what happens if you type "mysql" in the dir where the mysql.exe resides? do
you also have this dir in your path?
-bruce
-Original Message-
From: Chuck Wildeman [mailto:[EMAIL PROTECTED]
Sent: Thursday,
You might want to look get the mysql admin tool. It will call the query
browser if needed (so don't get rid of that), but its what you use to
supervise the server (set up users etc.)>
Hope this helps.
Chuck Wildeman said:
> Hi,
>
>
>
> I am very new to mysql. In the past I was using Access. I d
-
From: Dave Tiger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 3:32 PM
To: 'alesi'
Cc: [EMAIL PROTECTED]
Subject: RE: New User for mysql
Hi Alesi,
I hate to RTFM as an answer but this is covered on numerous sites but here
is the link to the windows section of post installa
Hi Alesi,
I hate to RTFM as an answer but this is covered on numerous sites but here
is the link to the windows section of post installation
http://dev.mysql.com/doc/mysql/en/Windows_post-installation.html
I hope that helps
Dave Carrera
--
UK Web Hosting @ http://www.ephgroup.com
-Or
Gary,
> [h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
> bpw_db>bpw_db_backup.sql
> bpw_db_backup.sql: Permission denied.
This means that MySQL is not allowed to write in this directory. Which
directory? ;-) Well, as you don't specify a path, bpw_db_backup.sql will
be crea
At 21:12 -0600 1/31/03, Gary Reimer wrote:
I'm a new mysql user running on OS X. I have set up a test database and am
trying to use mysqldump to create a backup. However here is what happens:
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_db>bpw_db_backup.sql
bpw_db_b
pmoscatt,
Tuesday, May 28, 2002, 2:23:00 AM, you wrote:
p> I am new to mysql and having trouble understanding the installation procedures for
linux (Mandrake).
p> I have downloaded the "mysql-3.23.49a-pc-linux-gnu-i686.tar.gz" and unpacked it in
/usr/local as root.
p> I then issued the followin
Jim,
I'd like to help, but I dont answer questions directly. Please post your
question to the mysql mailing list in future. I have crossposted this to the
list.
kind regards,
Mark Maunder.
Jim Chivas wrote:
> Mark:
>
> I work in a School where the teachers want to use mysql.
>
> A while back
Jim,
I'd like to help, but I dont answer questions directly. Please post your
question to the mysql mailing list in future. I have crossposted this to the
list.
kind regards,
Mark Maunder.
Jim Chivas wrote:
> Mark:
>
> I work in a School where the teachers want to use mysql.
>
> A while back
end than VB or any other
programming language!
Good Luck!
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Rodney Broom [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:28 PM
To: [EMAIL PROTECTED]
Subject: Re: new user basic
>I am new to dababases in general and have a few questions. I have been
>building a database in mysql using sql commands in msdos but would like
>to use Visual Basic from here on out to edit the database. After
>completion of the database I need to use it for a program that will also
>be editing t
From: <[EMAIL PROTECTED]>
> I am new to dababases in general...
Learn SQL (which it sounds like you've done). It's almost always going to be the
standard tool between various database vendors and APIs.
> ...would like to use Visual Basic ...to edit the database.
I won't make any MickySoft vs
Hi,
You can use "DESCRIBE [TABLE_NAME]" or "SHOW FIELDS FROM [TABLE_NAME]"
or "SHOW COLUMNS FROM [TABLE_NAME]"
I suggest you read the manual because this is explained thoroughly in
section 6.6.2
http://www.mysql.com/doc/D/E/DESCRIBE.html
Regards,
Jorge
For technical support contracts, visit
Sumit Ranjan writes:
> hi there !
>can anybody please tell me what is the query to obtain the table
> strusture ???
Heh, sort of you give me the impression of an excited puppy
with all those question marks and stuff.
Did you try the manual by any chance? Didn't think so.
http://www.mysql.co
Dear Alex,
> to add a new user with full privileges on only 'abcdb'. How
I assume "abcdb" is a database, not a table. Try this:
GRANT ALL ON abcdb.* TO "newuser"@"localhost" IDENTIFIED BY "pw"
Regards,
--- Stonix <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm new in mysql admin. I have question
On Wed, May 16, 2001 at 03:01:26PM +0300, Heikki Tuuri wrote:
> Andreas,
>
> sorry, it is the default MySQL behavior to create a MyISAM table if
> another handler is not present.
>
> There was a long thread of emails between MySQL developers if MySQL
> should give an error message if a table can
Hi!
At 05:04 PM 5/16/01 +0200, you wrote:
>>>4) Ok, datafiles created overnight. Now trying alter table ...
>>type=innodb
>>on a
>>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>>files
>>this
>>>size is going to be problematic. Machine pegs with load of around 12! I
>
Hi!
I already found an easy solution. Write to the file in 16 MB chunks
instead of 1 MB chunks. Then I got 5 MB/s on our Linux Xeon.
I do not think MyISAM uses fsync at all. I need fsync because in
recovery I must know that some database pages have been cleanly written
on disk.
These fsync thin
>>4) Ok, datafiles created overnight. Now trying alter table ...
>type=innodb
>on a
>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>files
>this
>>size is going to be problematic. Machine pegs with load of around 12! I
>suggest
>>LOTS more testing on BIG tables. Small
Andreas,
sorry, it is the default MySQL behavior to create a MyISAM table if
another handler is not present.
There was a long thread of emails between MySQL developers if MySQL
should give an error message if a table cannot be created to be of
type BDB or InnoDB because the handler is not presen
Hello,
From: Richard Ellerbrock <[EMAIL PROTECTED]>
> Just installed MaxSQL 3.23.38 on a test system to check out InnoDB.
> Here are my observations:
May I add my ones ...
If there are some missing entries in the my.cnf or the INNODB
handler can't be started because of permission problems a
Richard,
I made some measurements with fsync. If I create first the big data file
without O_SYNC and after that make a single fsync, I get a write speed
of 5 MB/s, which is 5 times more than with O_SYNC.
On the other hand, opening a log file in the O_SYNC mode makes commits
much faster than by c
Richard,
thank you for the observations. Some comments:
>Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here
are my
>observations:
>
>1) Manual is not clear on permissions of directories - They should be
mysql.root
>owned. The error in the error log just says cannot create
24 matches
Mail list logo
