Can you post few lines of the code where you are making the connection?
On 4/10/06, marco stagno [EMAIL PROTECTED] wrote:
Wild stab in the dark here - Java I/O permissions not set correctly
on your
machine to allow it? If I recall, Java's sandbox feature means you
have to
supply a
I suppose you could set the suid bit on mysqld binary. But that itself will
be a security risk. I am not sure why your security folks are insisting on
ports below 1024. I hope they realize anything running under 1024 must be
run as root. And anything running root can pose a serious security risk.
If you are knowledgeable about the application and know which tables are
frequently accessed during the time of crash, you can send the create
statements used to create those tables. Also any indexing and how many rows
are in the table will also help.
In my opinion over a hundred tables for an
What is it you are looking for in the application? I use DBVisualizer free
version for most of my mysql and oracle use. You can give it a try and see
if you like it or not.
On 1/2/06, Dan Rossi [EMAIL PROTECTED] wrote:
Hi there i am looking for an alternative gui app than navicat for osx.
Ive
You did not say what these data would be used for. Will there be heavy
reads? What is the time requirement for each query? Proper way to do
this would be by having three different normalized tables.
State:
state_id PK
state_name
County:
county_id (either abbreviate or create unique numeric
You have not said what type of information you will be storing in this
database. Is it going to be just faculty information? Even if it is
just faculty information, you do realize that each school treats
departments a bit dfferently. The faculyt maybe under different
school, may specialize in
Matthew has already responded. But I will also add, you must rethink
how your application is coded. I can not possibly imagine a situation
where a user session needs 200meg insert. No matter what database you
use you will have a terrible time trying to scale this application. If
you give more
You definitely should increase memory sizes in your my.cnf file. The
settings that you have are for a very smal setup. You also need to
allocate more space for innodb table extender. So instead of 10m have
something like 50m or try and see which settings is better. The reason
is under heavy load
The same source that you compiled under VC++ may not work at all under
linux. Especially since the header files will be different. Make sure
you have the proper header files for linux installed. Also I did not
see any linking flags during compilation.
On 7/3/05, Ashok Kumar [EMAIL PROTECTED]
Make sure /var/run/mysqld exists and wrtable by mysql user
snip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am stumped with this compile problem with 4.0.24 src. Not sure what
is causing it. Can anyone provide some insights? Last time I compiled
on the same environment was 4.0.20 source. And all was ok.
gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/ms/svc/mysql/4.0.24\
-DDATADIR=\/ms/data/mysql/4.0.24\
Sure you can. Just move your current data to the location you like to
use and then do either of the followings:
1) supply parameter --datadir during startup (or equivalent in my.cnf file)
2) Create a symlink from old location to new location
- Original Message -
From: VijayKumar Dogra
We have been using innodb tables on our systems and we use netapp to
store all the tables. It will be however wise to put transaction logs
into a different netapp or somewhere else so that even if the netapp
goes kaput (highly unlikely) totally you do not lose any data.
--
MySQL General Mailing
How do you start your mysql now ? In any case you need to supply the
--skip-innodb option either in the option file (which most likely you
don't have) or at the startup time. If you use safe_mysqld script to
start your installation just pass on --skip-innodb to it. And even if
you don't, it is not
Does anyone know mysql handles duplicate key handling during multi inserts?
INSERT INTO test values(1,2),(3,4),(4,5),(1,6),(6,7);
Now the above statement fails and gives duplicate key error and exits.
Is there a way for it to ignore the key violation and continue
processing the batch?
--
MySQL
In all likelihood in your database you have not setup any access
privilege yet. You need to look at GRANT command and assign password
to atleast root account and any other accounts which will be
connecting over network.
On Fri, 23 Jul 2004 11:38:06 -0700 (PDT), john sayre
[EMAIL PROTECTED] wrote:
16 matches
Mail list logo