Make sure /var/run/mysqld exists and wrtable by mysql user
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]> wro
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 if
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 detai
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 certa
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 id)
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 app
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.
>
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.
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
> > s
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.
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
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
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 L
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
16 matches
Mail list logo
