I met 'got file handler' error while accessing the
database. I couldn't repair the damage on the related
file and I lost the damaged part. What could be the reason?
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
I installed MySQL in my local dir (~) (RH Linux7.2). Created database
successfully. No problems in operating on this database at mysql prompt.
When I run my JDBC (Java) program it gives SQLException
Server configuration denies access to data source. I am running the MySQL
server using following
Gokhan Yenikaya writes:
I met 'got file handler' error while accessing the
database. I couldn't repair the damage on the related
file and I lost the damaged part. What could be the reason?
Just about anything, I'd say. Are you using the latest
version of MySQL? Was it MyISAM, InnoDB, or
Trond Eivind Glomsrød wrote:
Dennis Jacobfeuerborn [EMAIL PROTECTED] writes:
We are running MySQL version 3.23.43 on one of our servers and have some
stability
Where did you get that? The MySQL site?
Some info about the system:
Dell PowerEdge 8450
4 x Xeon 700
4GB of RAM
On Tue, 08 Jan 2002 20:03:07 -0500
Dennis [EMAIL PROTECTED] wrote:
At 07:07 PM 01/08/2002, you wrote:
Dennis,
You may want to look into using InnoDB tables. I believe InnoDB tables
are immune to the 2gb limit (which usually comes from the filesystem).
Also, InnoDB claims that the innodb
Hi
i've a particular select to do...
here is the order i want :
select *,count(*) as counted from database group by field_to_count order by
counted
this query works but only returns one record per field_to_count (normal
behaviour)
i would want to get all the records (so, group by doesn't
Hello
Recently we have installed mysql ver 4.0.1(from
binaries).We loaded about 1.6 million records in a table.
One of the fields 'ti' is text field. We created fulltext
index on this field.
on giving following :-
1. select ti from p8387 where match ti against ('computer');
1701 rows were
Hi all
I was thinking of hosting our MySQL database on a cluster of Sun Netra's
either tmX1 or tmT1 and was wondering if anyone had any experience of these
boxes and how well they work with MySQL. Our database has about 30 tables
and about a million rows. Anyone have any ballpark figures on the
another approach is using the str_replace() function, just replace the
single quote ' with two single quotes '' and database inserts should be
fine.
http://www.php.net/manual/en/function.str-replace.php
Regards,
Sherwin Ang
Web Programmer / Systems Administrator
Alchemy Solutions
you can run it by issuing the command in the dos command prompt like
mysql -u username -p textfile.sql
but place use yourdatabasename; at the beginning of your text file.
USE YOURDATABASENAMEHERE;
DROP TABLE IF EXISTS NAME;
CREATE TABLE NAME
(KD NUMERIC(3),
OO CHAR(30));
insert into name
Sherwin Ang writes:
another approach is using the str_replace() function, just replace the
single quote ' with two single quotes '' and database inserts should be
fine.
Very funny. Let's say you're making this query:
DELETE FROM t1 WHERE str_field = '$value'
with your way of doing things,
Description:
myisamchk -foe /mail/torba/bucho
- recovering (with keycache) MyISAM-table '/mail/torba/bucho.MYI'
Data records: 66
Found block with too small length at 1928; Skipped
Found block that points outside data file at 1320584
Found block that points outside data file at 1590764
Found
I have clustered Netra's together before using SUN HA and Vertias VCS.
I found for large content avoid the Netra X1 - more so for webstuff, they
run on a very slow IDE bus. They work excellently for say processing like
the middleware box, or actual webservers but disk heavy apps I would avoid
as
Thanks Matthew...
Have you or anyone else tried running MySQL on them?
thanks again
Chris
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 12:12 PM
To: Christopher Thorpe; [EMAIL PROTECTED]
Subject: RE: Sun netra's and MySQL
I
[EMAIL PROTECTED] writes:
Description:
Found block with too small length at 1928; Skipped
How-To-Repeat:
There's no real point in sending bug reports that don't
say anything about what's wrong or how to reproduce the
error. That your table is corrupted could be because of
a power outage,
Chambon writes:
Hello,
No there's no thread in my application,
the program use fork but of course a new connection is create after each fork()
Today before running another test I do the following
- drop then create the tables
- increase the limit for opened file from 1024 to
Ok, I had a problem compiling Mysql 3.23.47 on RH 7.1. I kept getting:
checking return type of sprintf... configure: error: can not run test
program while cross compilingany way, i tried updating gcc to 3.0.3
which didn't help. So i installed all the RPM's for gcc 2.96-85 and it
solved
EDA Peach writes:
Hi,
Thanks ... I got to work, briefly .. then it logged me
out. I got MysqlTool running reliably.
Regards, Mike
All you had to do is follow instructions from README.
Simply click on Options button, fill up all entries and click on
'Save'. Then restart mysqlgui
Have you installed ncurses or termcap rpm's?
Jonas Arvidsson
-Ursprungligt meddelande-
Från: Steve Mansfield [mailto:[EMAIL PROTECTED]]
Skickat: den 9 januari 2002 13:48
Till: [EMAIL PROTECTED]
Ämne: More compile errors
Ok, I had a problem compiling Mysql 3.23.47 on RH 7.1. I kept
http://home.earthlink.net/~jaymzh666/mysql.html
This page mite help?
Simon
-Original Message-
From: Jonas Arvidsson [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 13:29
To: Steve Mansfield
Cc: [EMAIL PROTECTED]
Subject: SV: More compile errors
Have you installed ncurses or termcap
Hi All,
I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance.
Does anyone have advice on the best way in which to import so many files or
any
Il Tue, 08 Jan 2002 13:23:09 -0500, Stephen Abshire andava dicendo...
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
PhpMyAdmin says: You have an error in your SQL syntax near
'distinct ip)
FROM pole_voti' at line 1
I don't have MySQL on the computer I am on to test this but
Jörgen Winqvist writes:
I run RH supported kernel 2.4.7-10enterprise on such a server with
similar problems. All four CPU's runs off with a lot off system. I can
provoke this behaviour by generating disk i/o. A 'cp' might be it. I
often get it when the full backup is running. I've also
Hi,
What about a 2.4.17 with 'aa' patch, as it seems to have much less VM
problem than vanilla kernel or rmap-10c patched kernel... (I have personnaly
installed 2.4.17rc2 + patch rc2aa2 with no problem :
http://www.kernel.org/pub/linux/kernel/people/andrea/kernels/v2.4/2.4.17rc2a
a2.bz2 )
Best
Please help
Hi, I have downloaded and installed mySQL, but when I enter in
c:\mysql\bin mysqld-max --standalone I get an error. What am I doing
wrong? The error is attached as a jpg file.
Many Thanks
Andrew
-
Before posting,
Hello,
My boss is going through the mysql.com tutorials starting at ...
http://www.mysql.com/articles/ddws/12.html
... and currently stuck at ...
http://www.mysql.com/articles/ddws/13.html
The boss is using phpMyAdmin to access the database, and everything
has been working just
You may need to search the Windows registry if WinMySQLAdmin
is not in your startup folder. Run regedit and search for
'WinMySqlAdmin', and if the key is something like 'Run', then
remove it.
Each time that I reboot and logon to my windows 98 server,
WinMySQLAdmin starts and then starts
Andrew,
please do not send attachments to the mailing list. They do not come
through.
I have copied parts from the InnoDB online manual, section 2, below. I hope
they help in installation.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at
Clive Bredenkamp wrote:
Hi All,
I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance.
Does anyone have advice on the best way in which to
Ivan,
currently InnoDB allows a NULL in the child column only if there is a NULL
in the parent column.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
Can anybody help !!
$ uname -a
HP-UX dtsipp04 B.11.00 A 9000/871 2004025707 two-user license
$ gcc --version
3.0.1
$ ./configure --prefix=/app/IPPHost/mysql
This runs through ok
i then
$ make
and ultimately get
command line: warning: __STDC_EXT__ redefined
command line: warning: this is
F:\MySQL\binmysql -uroot -e select distinct count(*) from user \G mysql
*** 1. row ***
count(*): 4
Xi2 ('sE-'tü)
-Original Message-
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 5:54 AM
To: [EMAIL PROTECTED]
Hi,
I have connect to the mysql database as root, and added a user called test
one with the host field containing a % and all the other options with a Y.
In theory I should be able to connect to a remote database as test1 form any
host ? is this correct ?
I am have tried using mysqlgui and
* Ilic
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
PhpMyAdmin says: You have an error in your SQL syntax near
'distinct ip) FROM pole_voti' at line 1
I don't have MySQL on the computer I am on to test this but you
might try rewriting it this way:
select
Two quick qux for the gurus on the list!
1. If I needed to do date calculations based upon a TIME STAMP field, what's
the most efficient way to accomplish this with respect to data types (field
types...I already understand how to use the DATE functions and am aware of
locale time and UNIX time
Try, adding
master-port=3306 (or the numebr you are using)
to my.ini (slave file) under [mysqld].
I think it is in the manual.
Andrés.
- Original Message -
From: Remco Ploeg [EMAIL PROTECTED]
To: Mysql (E-mail) [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 8:59 AM
Subject: mysql
Hi,
I'd like to alter a field and change it from being Unique using the alter
table command but can't seem to get the syntax correct? Can someone give
me an example? IE:
alter table hrcontact modify login varchar(70) not null default'' _NOT
UNIQUE';
thanks,
Dan
in the db table there is the db field.
if I put in db1 in this field then the user test1 will only be able to
connect to db1.
the questions I have (I can't quite figure it out from the manual)
1.) how can I get it so test1 can connect to db1 and db2 but not db3. Do I
have to put in 2 entries
I am inclined to think (actually guess) it may be the version of MySQL you
are using. I am using MySQL 3.23.39 and I am able to successfully execute:
select count(distinct field) or select count(distinct(field))
I tried to make a quick check of the docs to see if a certain version was
I have a database of financial data that I am try to
match a holdings file against... The holdings file has
cusips that I look up in a lookup table to identify
what dataset/table they are in.
I need to check that the cusip is in the lookup
table, and that it has the proper type before
I
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
but I would like test1 2 and 3 to be able to type mysql and be either
I think it's like this...
alter table hrcontract drop index login
... assuming the name of the key is login. You can
have key names (which is what a unique constraint
is) and column names of the same name.
If you do a ...
show index from hrcontract
... it'll show you all of the key_name
Matthew Darcy wrote:
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
but I would like test1 2 and 3 to be able to
Matthew Darcy writes:
If I want to connect to the database as root then I understand I must do
mysql -u root -p
Unless you're logged in as root, in which case mysql -p is enough.
but I would like test1 2 and 3 to be able to type mysql and be either
logged
in as their unix username, ie
I read similar notes on this in the manual, saying that invoking mysql
without the username will try to take the unix username if it exists in the
database.
I tried this with test2, it opened an mysql session no problem, but when I
did a connect mysql it said access is denyed for user
Same here:
F:\MySQL\binmysql -uroot -e select count(distinct Host) from user \G
mysql
*** 1. row ***
count(distinct Host): 2
F:\MySQL\binmysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server
You can also try replacing quote marks with their HTML-equivalent entities.
Put this function in your code somewhere:
function PrepareQuotes($Var)
{
$Var = str_replace(',#039;,$Var);
$Var = str_replace('',#034;,$Var);
return $Var;
}
And on variables that might have
COUNT(DISTINCT was introduced in 3.23.2:
URL: http://www.mysql.com/doc/N/e/News-3.23.2.html
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
This will help, it seems: http://www.mysql.com/articles/wizard/page3.html
Xi2
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:11 AM
To: [EMAIL PROTECTED]
Subject: mysql query
I am trying to write a query that gets the name of
Rember that the sum function sums the total of all
of the colum specified. Is there multiple rows where
the same c.cid_no occurs many times? If so, then you
need a group by and having clauses. If not,
then you don't need the sum function.
With a group by, it'd look like this... I think ...
Hi!
i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in
one string separated with ';' but i does not work.
some ideas?
blestan
-
Before posting, please check:
http://www.mysql.com/manual.php (the
* Jonathan Hilgeman
So something like Joe's Farm will look like Joe#039;s Farm. It gets
inserted into the database without any addslashes, and when you
retrieve it from the database, it should work fine without any
converting to this or that.
...and when you search the database, you must do
Hi,
I have a problem to re-import sql dump from Linux 2.2.19 running
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
into the same mysqld under different database.
while running the same commandline on the source at least.
$ mysqldump --extended-insert
At 11:26 PM 01/08/2002, you wrote:
On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
At 07:07 PM 01/08/2002, you wrote:
Dennis,
You may want to look into using InnoDB tables. I believe InnoDB tables
are immune to the 2gb limit (which usually comes from the filesystem).
Also,
When you are told to fill in fuel and turn the key to drive, I suppose
you don't care how the fuel runs the car. Do the same things in any lib
you use, pushing the buttons in told order would work. Well, you may
dig deeper if you like since the code is available.
Alex Shi wrote:
Yesterday I
tired that but I am getting
Query OK, 0 rows affected (0.00 sec)
don't understand why it is not granting to the user ?
Matt.
-Original Message-
From: Ho, Kam [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 16:10
To: '[EMAIL PROTECTED]'; Gerald Clark
Cc: MySql List
Subject: RE:
I have a table with the columns names and id. I want to be able to find all
names with an id of '03' that do not have other records with id values of
'10','20' or '37'.
Is this even possible to do?
name id
a03
a11
a12
a13 I want 'a' because it has a 03 and
The Query OK, 0 rows affected indicate that the user table is updated so
test2 on localhost can access the mysql databases.
Do you still get the access is denyed for user @localhostto database mysql
message?
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent:
Hi;
Mysql is not like the Linux/Unix command line. You can't perform such an operation.
Sun
root wrote:
Hi!
i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in
one string separated with ';' but i does not work.
some ideas?
blestan
* blestan (root)
i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in
one string separated with ';' but i does not work.
some ideas?
Where are you trying to send it to/from?
The mysql client (or 'monitor') accepts statements separated by ;, but for
instance the PHP function
In the last episode (Jan 08), Dennis said:
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
If you can SELECT from it, create a new MYISAM table with the RAID
option, or create an INNODB table with multiple 2gb tablespace files.
Enable large file support:
[root@xxx array0]# du -h bigfile
2.9Gbigfile
[root@xxx array0]# ls -al bigfile
-rw-rw-r--1 root root 30 Jan 9 11:06 bigfile
[root@xxx array0]# uname -a
Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown
Hello, everyone --
I have received a great deal of help from many members of this list, so
I'd like to acknowledge that now. Someday, when I have my head wrapped
around this stuff, I hope to return the favor. In the meantime,
however, I have come across my worst brainbuster yet. Any help on
Dear Friend:
The first time I received this in my e-mail I deleted it! And later
wished I had it back! I had to wait months before someone E-mailed me
again with this offer! I always thought I would wait until later to try
this. I
wish I had done it sooner now! Don't do what I did! Make Sure
Can't be done. I know. I tried. I asked the same question several months
ago.
I wish we could do so.
-Original Message-
From: root [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:36 AM
To: [EMAIL PROTECTED]
Subject: How to send multiple statements to the server?
Hi!
At 12:09 PM 01/09/2002, Dan Nelson wrote:
In the last episode (Jan 08), Dennis said:
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
If you can SELECT from it, create a new MYISAM table with the RAID
option, or create an INNODB
Basically, the mysql_query submits the sql statement
to the database engine, and the mysql_fetch_array
allows retrieval of selected information returned from
the query into an associative array with each columnname
of the query an associative key in the array
Example...
Hi
I have a table that I want to add a new field to while running on the
server, however, when I try to add a new field, it comes up with the
error13 message, saying it doesn't have permission, yet the files and
folder are all chmod 777. Can it be due to the fact that there is a
permanent
Hi,
Can anyone shed some light on this problem I got when trying to compile on a
Linux platform?
/usr/local/mysql/lib/mysql
../libmysql/.libs/libmysqlclient.so: undefined reference to `atexit'
collect2: ld returned 1 exit status
Thanks,
Kevin
Needs to be done programmatically
-Original Message-
From: Jerry Rehak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:53 AM
To: [EMAIL PROTECTED]
Subject: Complicated Query?
I have a table with the columns names and id. I want to be able to find all
names with an id
I like the explanation using the automobile and key. Very good :-) Yet at
the same time if I understand what effect using the different grades of fuel
in my car will have on its performance, I can optimize how the car operates.
Much like the original question, if I know when MySQL caches
On Wed, Jan 09, 2002 at 12:23:27PM -0500, Dennis wrote:
is the 2GB limit only in linux 2.2? (ie does 2.4 not have that
limit?). Running a 2.4 kernel is the easiest option in that case.
Right.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax:
I deleted it too! Guess what, I don't miss it either!
-Original Message-
From: Reports [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:12 AM
To: [EMAIL PROTECTED]
Subject: AS SEEN ON NATIONAL TV: MAKE OVER $500,000 EVERY 20 WEEKS!!
Dear Friend:
The first time I
Hello!
I use a MySQL database table to store the name of several countries in
several languages. This table is used to create a country list for a
registration form on a website. As the list contains the names in several
languages they are sorted alphabetically only in one language but not in
all
As I said in my message (although I've still not had time to look further
into this) this will not solve your problem completely. My 2.4.17 testbox
will happily create 4gig flies - but as soon as my mysql myisam table
reached 4gig I got a Table full error when trying to insert.
Going InnoDB is
Hi, have two tables. One contains the names of ppl along with an id for
each person and a date of the entry. The second table contains some
added info for those ppl, and I would like to have one of the fields in
the 2nd table to be in the first table in irder to make it easier to manage.
The
I've had no problems with MySQL RAID, and the performance is excellent
as long as you have your indices set up properly. One caveat I might add
is that MySQL RAID does not apply to index files (.MYI). If your index
files are going to grow 4 GB, you'll need to consider alternate
filesystems
Hello,
while using the MySqlGui 1.7.5, I cannot get the
create table Menu Option (F9) to work. Is there
anything I've missed.
thanks
chris
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
chc chc writes:
Hello,
while using the MySqlGui 1.7.5, I cannot get the
create table Menu Option (F9) to work. Is there
anything I've missed.
thanks
chris
Nope.
It hass not been implemented.
You can use CREATE TABLE comand ...
--
Regards,
__ ___ ___ __
/ |/ /_
I'm new to MySQL. Does MySQL have archive logging and can you recover to
the point in time of failure in the event of disk crashes? Also, Besides
the manual and classes, what is the fastest way to get up and running on
MySQL considering I am a seasoned Oracle DBA. Are there practical
Hi Roger,
Thanks for your reply and I apologize for my lack of specificity on my
previous email, thanks for your patience :).
I have a people object that has 4 entities. name, pword, user_id, picurl
This data is stored in the people table. Each user is identified by
a unique user_id. I would
I recently switched to InnoDB persistent connections from PHP.
Lately I've been getting these errors Lock wait timeout exceeded; Try
restarting transaction on an UPDATE on table. The system is in
development so there is at most one other user ( a back end Perl script).
When I switched PHP
Hi All:
I have problem linking my c++ program in solaris. The same program link
correctly in Redhat linux.
I'm using mysql 3.23.47 source build using gcc 2.95.3 (source build on
solaris using Sun pre-build gcc 2.95.3)
Here's the output from gcc:
Undefined first referenced
Hi,
I had this too - in the documentation, although maybe not highlighted
enough, there are instructions for overcoming 4G - you have to set MAX_ROWS
for you table to a 'large' number to tell mysqld to use 4 byte pointers
for the file.
Regards
Quentin
-Original Message-
From: Chris
Hi,
MySQL, being a relational database (quiet, you guys from other camps), is
good at storing relational data.
To store purely XML data, you may be better off using an XML database e.g.
Tomino from Software AG.
The line is a fine one, though. If your XML is purely a representation of
query ok I would expect to see, but no rows affected ??? this must mean it
has not altered the database at all ??
I created a 2 new users, dba and matt
I did grant all privileges to *.* to dba@%
I cannot conntect from anything host as dba.
I then did
grant all privileges to *.* to
Hi
Error 13 is from the OS - nothing to do with locks or whatever.
However, when you add a new field (or change the table structure in (nearly)
any way), mysqld will create a temporary table in the database directory -
are you sure that the permissions on the directory are correct?
Remember,
Hi SAm,
I actually had a similar problem myself, but was unable to prove it was
the persistent connection itself causing this. I'm wondering if this
means that INNODB thinks that a connection that is now 'sleeping' (ie.
where a connection was created, used, but is now unused but still open)
Matt:
Try the following:
Use mysql
select * from user (take a note on users that you're granting rights to)
run the grant command
select * from user (see if there is any differences)
OR
try
grant all privileges to *.* to matt@ipaddress (where ipaddress ==
999.999.999.999 your real ip address)
Your new best friend:
http://www.phpwizard.net/projects/phpMyAdmin/
Original Message Follows
From: P.Agenbag [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Subject: Error 13
Date: Wed, 09 Jan 2002 19:13:51 +0200
Hi
I have a table that I want to add a new field to while running on the
* David V. Edelstein
I would like to create a mySQL query that will find the max
user_id, use this value to calculate a random value of the
user_id from [1 thru max], then return the entire row for
that person(user_id) filled in with that persons(row) four
entities, which I can use to
I've found that using PreparedStatement.setString() takes care of any
apostrophe's within a given sql string field.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Are you doing 'flush privileges' are documented?
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 8:26 a.m.
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
query ok I would expect to
You must do a FLUSH PRIVILEGES after making any changes to the user
permissions before they will actually take effect. This is documented.
james montebello
On Wed, 9 Jan 2002, Matthew Darcy wrote:
query ok I would expect to see, but no rows affected ??? this must mean it
has not altered
I installed the binary rpm version of MySQL 3.23.47 yesterday and set
up the necessary permissions. This is a single user computer, not on a
network, so I'm both 'root' and 'user'.
Today I tried to start working on the tutorial in the manual and found
that I couldn't create a database and
Hi!
Looks like your are not committing your transactions. Every UPDATE and
INSERT automatically sets row level locks, which are only removed when you
do a COMMIT or ROLLBACK.
Or you have set innodb_lock_wait_timeout too small in my.cnf.
InnoDB does not set table level locks. Only LOCK TABLES
From the Manual (21.11 Problems with File Permissions)
By default MySQL will create database and RAID directories with permission
type 0700. You can modify this behavior by setting the UMASK_DIR variable.
If you set this, new directories are created with the combined UMASK and
UMASK_DIR. For
I'm having trouble bulk-loading data into a table. I have a file which
contains:
AYL01ôAYL01-1ôChloeô1979-12-1 0:0:0ôF*END*
AYL01ôAYL01-2ôMelissaô1985-3-2 0:0:0ôF*END*
AYL01ôAYL01-3ôDavidô1979-1-12 0:0:0ôM*END*
COL01ôCOL01-1ôSimeonô1989-12-14 0:0:0ôF*END*
DAV01ôDAV01-1ôMurialô1990-2-2
First, you are describing a one-to-many relationship, bceasue one file
record can be referenced by many people records. If this is the case, you
may wish to re-design your tablse such that a people record contains a
file_id field. You can then do away with the filespeople table
altogether.
* Martin MOKREJ
I have a problem to re-import sql dump from Linux 2.2.19 running
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
into the same mysqld under different database.
while running the same commandline on the source at least.
$ mysqldump --extended-insert
1 - 100 of 154 matches
Mail list logo