Check ownership and permissions of MyDatabase_copy directory (and maybe
the files).
On Wed, 2002-03-20 at 02:01, Ashwin Kotian wrote:
I'm using the following syntax to backup one of my Mysql databses using
mysqlhotcopy:
#/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy
There
I am creating a database called Meet_a_Geek at MS DOS prompt. The customer table has
about 30 fields..no time counting..but I noticed that I cannot go beyond 9 fields
without ending with a semicolon. Also another problem crops up when I tried to
recreate the customer table with the remaining
Hi Sasha,
Ooops ok, LANG is for FreeBSD. I misunderstood. I don't know SuSE
Linux but on my Mandrake Linux system I have this:
[ken@nx01 ken]$ set | grep -i lang
LANG=en
LANGUAGE=en_US:en
RPM_INSTALL_LANG=en_US:en
langfile=/etc/sysconfig/i18n
I am not sure how this works (I prefer freeBSD).
Hi all..
I noticed that the current version of InnoDB that is part of MySQL 3.23.47
does not allow using null foreign keys when doing inserts.. Is this
intentional or a bug? This is allowed by SQL Server as a minimum (a test
is being done by a co-worker currently against Oracle 8i to see
Folks:
I think you are on the right track with that Gerald..
I deleted all the files in my data directory (they were just the ones that
mysql_install_db creates) and then ran mysql_install_db --user=mysql
This time, nothing was created, no files, or anything, cant even find an
error message
Hi,
In my mysql .err file I get a lot of the following error...
Aborted connection 121031 to db: ..connection details... (Got an error
reading communication packets)
What does this mean, and is it bad, and what do I do about it?
Any help appreciated.
Howard
This might help
http://ecn.www.ecn.purdue.edu/ECN/Documents/VI/
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 1:46 PM
Subject: Cannot access the Database on same Machine
colin,
Tuesday, March 19, 2002, 11:04:31 PM,
Hi Lance,
On Thu, 2002-03-21 at 03:18, Lance Prais wrote:
Can someone look at this at see what I am doing wrong:
The following SQL returns to records:
50
333
select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID =
107793;
If I include it in the following loop the result
On Wed, Mar 20, 2002 at 11:42:00AM -0800, Lance Prais wrote:
Does anyone know of any good PL SQL Oracle Lists?
How is that considered important let alone on-topic for a MySQL
mailing list?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax:
Hi,
On Thu, 2002-03-21 at 01:03, Leecher wrote:
I installed mysql-3.23.49-win on Windows 2000 to drive D: (the installer
lets one choose the location). After reading the docs, I can see that I need
to start the daemon like this:
mysqld --basedir d:\mysql
However, when I do it I get this:
Hi all,
It's urgent I upgrade my mysql server with some rpm that I found elsewhere
on the web
But when accessing db I was rehected.
Ii d like an easy way to recover my password or to put a blank pass like it
was !
see what I ve got !
www:~# mysql
ERROR 1045: Access denied for user:
The problem isn't inserting table schema/data - I know how to do that.
I'm referring to the process of inserting an actual FILE (txt, .bat, .jpg)
via command line. And of pulling it out and giving it a name (test.txt).
-Original Message-
From: Mark Horton [mailto:[EMAIL
On Wed, 2002-03-20 at 12:56, Paul DuBois wrote:
With Story_Content, we're happy to use the stricter MATCH selects. So is
it possible to do something like Select * from stories where
MATCH(Story_Content) against ('param1') AND Writer LIKE param2% or am I
barking up the wrong (b-) tree?
If
mysql
Ignore this subject, pls..
Dear mysql people:
I am trying set up a dataset in mysql version 3.23.42 on a Mac OS X
Server v10.2.
When I use the load data statement, only one record gets read into the
table.
If I edit the file and remove the top record, then when I give another
load data
command, mysql reads the new
I suggest using one of the windows GUI clients to modify tables, rather
than a command prompt (i.e. winmysql etc).
alan4100 wrote:
I am creating a database called Meet_a_Geek at MS DOS prompt. The customer table has
about 30 fields..no time counting..but I noticed that I cannot go beyond 9
At 15:30 -0500 3/20/02, alan4100 wrote:
I am creating a database called Meet_a_Geek at MS DOS prompt. The
customer table has about 30 fields..no time counting..but I noticed
that I cannot go beyond 9 fields without ending with a semicolon.
The mysql program does not require that you enter an
This is a servlet code example for jdbc using the mm driver.
String DB_NAME = database;
String DB_HOST = localhost;
String DB_USER = username;
String DB_PASS = password;
String DB_DRIVER = org.gjt.mm.mysql.Driver;
String DB_CONNECTION = jdbc:mysql:// + DB_HOST +
/ +
On Wed, Mar 20, 2002 at 11:51:47AM -, Rob Moore wrote:
Jeremy
You can set it up so that the slave only gets updates to certain
databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what put me off slightly was the concept of a master
and slave. My
Normally seen when a client disconnects due to timeout, Or the server
doesn't realize the client has disconnected.
mysql mailing list user wrote:
Hi,
In my mysql .err file I get a lot of the following error...
Aborted connection 121031 to db: ..connection details... (Got an error
a telnet to mysql works :
www:~/MySQL# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
2
4.0.2-alpha-debug9`VmEN7i,
Bad handshakeConnection closed by foreign host.
but still cant erase this password !
www:~/MySQL#
G'day Arjen
FULLTEXT search generally uses an index (the FULLTEXT index), so the
server will not use an index on Writer.
So far for the answer to Kim.
So is an index on Writers worthless in this circumstance? My concern would
be if someone did a query using the writer's name as the
Hi,
I am no major linux guru, I am not even sure this is a bug, but here goes:
OK, my host creates databases on its shared hosting systems (redhat 7 and
latest stable MySQL (or it was about 3 weeks ago)) in the format
username_dbname. You can then obviously create users with the permissions,
It is a big problem for us, and I can only imagine for anyone using
MySQL, when a mysql client hangs on an established connection to
the mysql server because the network to the server is disrupted
(such as someone pulling power to a network hub or many other
scenarios). We have changed the
By any chance are you using DBI, and prepare in the query? If so, have you use
prepare_cached and roled the select statement into a function that accepts the
'CONSTANT' as an input param to the function?
That gave me tremendous perf improvements.
-Original Message-
From: BD
You may also find it more convenient to edit a text file with all of your data and
table creation commands in it, then use the 'source' command inside an mysql session
to execute them. That way when you run into an error, you just edit the file and
repeat.
Another nicety about MySQL is a
The problem is you are not entering any returns. You can do this:
mysql create table customers
--(Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
--First_Name VARCHAR(20) NOT NULL,
--LAst_Name VARCHAR(30) NOT NULL,
Etc, until you get to the last:
--;
That's it.
On 3/20/02 2:40 PM,
Just put a carriage return (e.g. the enter key) in your command every, say 72
characters or wherever the next logical word occurs. MySQL really only cares about
ending all the entry with a semi-colon (or some maximum line length which I think
you've run up against).
In short, hitting the
Hi Kim,
On Thu, 2002-03-21 at 09:15, Kim Kohen wrote:
G'day Arjen
Indeed, hi fellow Aussie ;-)
FULLTEXT search generally uses an index (the FULLTEXT index), so the
server will not use an index on Writer.
So is an index on Writers worthless in this circumstance? My concern would
be if
I executed mysqladmin extended-status.
There was Com_change_db head. But I can't understand what it means.
I know Com_xxx means number of times xxx command executes. But
what does change_db mean?
Please help.
-
Before
mysql
- Original Message -
From: Tony [EMAIL PROTECTED]
To: 'alan4100' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 2:11 PM
Subject: RE: Adding Columns to table
Just put a carriage return (e.g. the enter key) in your command every, say
72 characters or wherever
Try these:
Class.forName(org.gjt.mm.mysql.Driver);
con = DriverManager.getConnection
(jdbc:mysql://localhost/Testing, my username, my
pass);
Make sure the jar file in the mm.mysql-2.0.11 directory is in your
classpath/
mm.mysql does NOT use the odbc driver.
mysql
Thanks..thanks, Tony
I think I am still having problems in replying this note to you because it
had returned to me before. I have found emails redirected to me from other
users. In replying to you, should I add anything key word like MYSQL in the
subject?
It is not clear why, but I am
Hi Again
Thanks for all the responces
Check the manual section on the query optimiser,.I seem to remember that
if
MySQL has to check more that some percentage of a table (30% ?) the
optimiser guesses it can search the entire table just as quickly.
Someone please correct my if I'm wrong.
Hi, I'm developing a web content management system for my website. I'm in a
dilemna over which schema would be best for categorizing each document and
really would appreciate some experienced input on this since I've changed my
mind 4 times already and still can't decide between the two following
mysql
Hi Doug,
I am not sure what you want to tell me. But you may be right about shell
available for Windows. I assume it is an add-on program. I have not used
this shell prompt either; it may be available on Windows XP.
But may I ask you one question?
Do you think I can find
hi,
I think u r right..
because after recovering from the dumped database, when insert a value
in the foreign key column which is not present in the primary key, it
accepts the row inserted.
which is not true when I do the same think from the mysql command
prompt,( before dumping)
Anybody who
Hi Joao,
I will check on it...thanks
I know if I send it directly to you; it will be returned to me while the cc:
goes to the [EMAIL PROTECTED] successfully.
From now on I will just email it to [EMAIL PROTECTED]
I wonder if [EMAIL PROTECTED] has made arrangements to send a personal
copy to
HI everybody!
I am using Linux Red Hat 7.2 and I want to execute
mysqlgui. After I start this program, have a error is:
Can't connect to local mysql server through socket.
Please, show me a way to solve this problem.
__
Do You Yahoo!?
Yahoo!
Thanks...Paul
It appears impossible to reply your note via Outlook Express because it will
return to me like other users. So I am replying this note to
[EMAIL PROTECTED] Hope I will hear the solution soon.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: alan4100 [EMAIL
On Thu, Mar 21, 2002 at 11:26:41AM +0900, °í¼ø¹Î wrote:
I executed mysqladmin extended-status. There was Com_change_db
head. But I can't understand what it means. I know Com_xxx means
number of times xxx command executes. But what does change_db
mean?
That's USE database and the eqivelant
Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same
hardware? Thanks.
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi All,
I am getting following error msg when I try to install
MySQL using rpm -i My*
error: MySQL-3.23.49a-1.i386.rpm cannot be installed
error: failed dependencies:
data-showtable is needed by
Msql-Mysql-DBI-perl-bin-1.1823-1
DBI-perl-bin is needed by
I am running the latest stable version: 3.23.49a
but when I use the LOAD DATA command I get the error below:
mysql load data local infile theme.txt into table theme;
ERROR 1148: The used command is not allowed with this MySQL version
any idea what the problem is?
thanks
I have built a MySQL database for a web based survey. I am trying to decide
between JSP and PHP for my programming interface. The reason I am
considering Java is because I have some Java experience. What would you
recommend for someone like me who is starting out?
Also, my two current hosting
Guys
I have a corporate portal application that use MySQL as backend database and Linux OS
(RedHat 7.2)
For clustering service, i've found so many solutions BUT the problem comes when
i realize that i must cluster data to, not only MySQL data but also public folder,
email and others.
Is that
Aha! That's the reason why my DB has so many Com_change_db.
Thank you for letting me know.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:10 PM
To: °í¼ø¹Î
Cc: [EMAIL PROTECTED]
Subject: Re: What is Com_change_db
On Thu, Mar 21,
PHP all the way.
This will give you a lot of information on what your options are:
http://uptime.netcraft.com/up/graph?site=www.klym.ca
and substitute site=www.yourdomainname.com
It will tell you what modules they currently support etc.
PHP is faster than JSP and I think its a whole lot
Everyone,
I am using the MySQL server version 3.23.44 running on Windows 98 machine, I
just found out that as you view the task manage...mysqld is not alone...I
mean, about 6 of them...I am confuse whos running...so, all I want to know
is...is there a problem about it...as far as my client is
Hi all,
we're using 2 tables master1 and master2, in which master2 table's column1
references table1's column1(Forien key). Both are of same type. Since it is
foreign key, the value which is entered in column1 of master2 should be
already available in master1. But while adding MySql is not
Hi,
I have two tables that i want to link via an outer join:
mysql desc active_monitors;
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| monitor_id |
I changed servers and now nothing works at all.
I am bright green to cgi and mysql and just purchased this site last month.
What is the recommended checklist I can check out to see where the problem is..
I need to get this all working asap before my hair turns green too.
Thank you all in advance
Here is the time for creating one unique index.
Query OK, 211921 rows affected (1 day 9 hours 23 min 43.63 sec)
Records: 211921 Duplicates: 0 Warnings: 0
And its already on the todo to disable unique secondary keys temporarily :)
-Ursprüngliche Nachricht-
Von: Christian Rabe
TAKAHASHI, Tomohiro wrote:
Hi,
Lonnie Wormley wrote:
Is this the correct file to have in your class path?
addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar
Yes, please add it into jdk.config. :)
I have it in there and it still does not work. I have it in my
101 - 154 of 154 matches
Mail list logo
