Having some problems setting root password on MySQL. Can anybody help
me?
I've just installed MySQL 3.23.38 on a Windows 2000 server.
I'm following the directions in the documenation for setting the root
password:
>mysql -u root mysql
mysql>UPDATE user
mysql>SET password=password('mynewpass')
my
I had mandrake 7.2 running on my system. It crashed and I
transfered my back up files to a system running Debian 2.2.
The file were db.frm db.myd db.myi. These are packed files
and the mysql I am now running does not use these.
What can I do??
Need help Eric.
-
Matthew Darcy writes:
> I was aware of the user table as a standard table.
>
> I did a select on it and it all looked fine. Loads of Y's and % for host
> Yet this user still cannot connect. The only explaination is corruption.
It sounds to me like you haven't removed the @localhost entry,
but
I have the database files, now how do I put them back into mysql?
Restore table doesn't seem to work.
Thanks in advance,
~Travis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Hi... I have an interesting problem I don't know which way to solve. I tried
posting this on the PHP site (since I'm coding with PHP and mysql) but they
said I might want to try my odds here.. since they suggested I go with the
mysql solution, but I'm clueless where to start. So I'll shoot it out
Matt:
I don't remember you saying what machine you're running mysql on.
Try adding another copy of the same user only @localhost. My win32 installation
requires that for a dos box. The hosting
service I use doesn't seem to care as it almost seems to ignore the Host column.
GRANT ALL PRIVILE
For the sweet love of god! Thanks Neil. After I wrote you that email, my
head suddenly slipped out of my butt and I realized I didn't run a
reload via the mysqladmin...funny..that seems to make everything work.
thanks for the jolt.
Neil Silvester wrote:
>Did you FLUSH PRIVILEGES?
>
>-Orig
I have a simple table with A LOT of data, 2.1M rows. this is purely a
development/test/learning endeavor.
The table structure is:
ID-> auto-increment
url -> varchar(255)
topic -> varchar(255)
about -> tinytext
Anyone use fulltext indexing under this scenario? The DB server is a P3-866
One word ZEOS http://www.zeoslib.org/ K1 sucks on MySQL support but using
ZEOS I have had no problems. K1 will run on 2.4.4 the earlier 2.4 had memory
issues from what we have seen. Using both K1 and K2 on 2.2 and 2.4.4 RH
boxes
Cheers
M:)
I like to set small goals that might lead into larger
I'm kinda new to mySQL and I set up a user (myself) and a database for
myself on our webserver at work. I did the "insert into" into the User
table and the Db table. However, when I try to log into the database I
get errors. I go to my mysql path on the machine and do:
./mysql -u username -p d
Mike wrote:
> Ok so where is database SQL Mysql in the message anywhere
At the end of the Disclaimer:
> DISCLAIMER: Certain statements.
>
> .. profiled. All information provided about the profiled
> companies may include information provided by outside sources, such as
> research r
Ok so where is database SQL Mysql in the message anywhere
Sorry there Billy but this list happens to be Very clean of Spam. I get
about 190+ messages daily from different lists and the only one I can be
assured to have little to no spam is this one. My poor filter works overtime
on the others.
In
Billy,
Block yahoo.com mail they don't do anything about spammers abusing their
services ;-)
I did that and found that the spam I see dropped by 99%
Billy Harvey wrote:
>
> On Wed, 2002-01-09 at 23:08, [EMAIL PROTECTED] wrote:
> > OTC News Alerts' Last 3 Picks have gained 358%!
> > Here is o
On Wed, 2002-01-09 at 23:08, [EMAIL PROTECTED] wrote:
> OTC News Alerts' Last 3 Picks have gained 358%!
> Here is our next Hot Pick!
Dear MySQL list,
I'm afraid I've had it. I don't post often here - but I probably help
on average one person a day by working directly with them in the
background
OTC News Alerts' Last 3 Picks have gained 358%!
Here is our next Hot Pick!
Single Source Financial Services Corp. (OTCBB : SSFL)
URGENT BUY AT $ .75 PER SHARE!
SELL TARGET $4.50 PER SHARE!
SSFL is the fastest growing, publicly-traded credit card transaction
processor through its contractual ag
I have setup a database that GRANTs a specific user access
to a database, which is theirs and will be their
responsibility to manage.
They have privileges on that database only. Using MySQLGUI
they can log in and manage that database, but from the drop-
down menu they also see the other datab
At 20:22 -0600 1/9/02, Paul DuBois wrote:
>At 9:02 -0600 1/9/02, Robert L. Yelvington wrote:
>>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
>>
At 15:16 -0500 1/9/02, Jeffrey Lomas wrote:
>I'm fairly new to mysql. I have need for certain actions to occur
>within a database at a certain time every month. What is the best
>way to go about doing this? Is there a way to schedule these
>actions from within mysql?
No. Use cron to schedu
At 9:02 -0600 1/9/02, Robert L. Yelvington wrote:
>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
At 17:23 -0800 1/9/02, Kyle Hayes wrote:
>I am putting the finishing touches on a completely reworked replication
>server/client scheme (we cannot use MySQL's native replication for what we
>are doing). The whole thing is written in Perl/DBI and runs
>on Linux (x86). We are using various version
At 18:21 + 1/9/02, David Ayliffe wrote:
>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:
On Thu, Jan 10, 2002 at 10:24:37AM +1100, Sam Russo wrote:
> I have a delimited file sent to me with students ID subjects and when they
> do these subjects. This file (table) looks like:
> ID TimeSlotSubject
>
> 215 3
I am putting the finishing touches on a completely reworked replication
server/client scheme (we cannot use MySQL's native replication for what we
are doing). The whole thing is written in Perl/DBI and runs
on Linux (x86). We are using various versions of MySQL, but all 3.23.x
series. We a
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 0:0:0ô
Two questions regarding multi-table operations:
1) I've got multi-table delete working with a couple of BDB tables,
where it's properly deleting from one or both tables, and all
possibilities of the delete criteria are being exersized. After the
multi-table delete command, I can 'select *' from
Just to check:
you are doing
GRANT ALL PRIVILEGES ON *.* to user@localhost;
FLUSH PRIVILEGES;
previous examples have had grant all privileges _to_ *.* to user@localhost
or is _to_ a synonym for _on_?
Quentin
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thu
> So I designed my "files" and "people" tables without any direct
> relationship with one another, thinking to link them with the SELECT
> statement.
>
> What I completely forgot, up until this point, was that I would need to
> INSERT these records (from pre-written HTML/PHP forms), and there is n
I was aware of the user table as a standard table.
I did a select on it and it all looked fine. Loads of Y's and % for host
Yet this user still cannot connect. The only explaination is corruption.
Although I am still looking at it.
-Original Message-
From: James Montebello [mailto:[EMA
I have a delimited file sent to me with students ID subjects and when they
do these subjects. This file (table) looks like:
ID TimeSlotSubject
215 3 Eng1
648 2 Maths2
901 4
In the last episode (Jan 09), Dennis said:
> I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL.
> Is there an issue with v3.22 related to this?
http://www.mysql.com/doc/T/a/Table_size.html says that 3.22 was limited
to 2gb or 4gb, depending on the OS. Upgrading to 3.23 will let
Hi,
I have two tables, one with a smaller working set of data and one with all
the historic data; both have exactly the same layout.
I want to run a script about every month which will select the oldest data
from the working set and move it into a temporary table. Than I want to add
all data
Walt,
a possible reason is that fsync is much faster in Linux-2.4 than in 2.2.
Check that the combined size of your log files is 50 % - 100% of the buffer
pool size. Small log files cause more disk i/o and more fsyncs.
The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer.
Somewh
Heikki,
Thanks very muich for the explanation. That's an interesting question
for the connection modules in Apache/PHP/DBI etc. Perhaps this is a
problem with the way the connections are opened by those programs. I
hadn't thought of that, so it would definitely be a good thing to test
before
I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL. Is
there an issue with v3.22 related to this?
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Hi!
It is a bug if the sleeping connection is in the auto-commit mode. But we
need more information of the problem. If you encounter it, please send the
exact sequence of SQL commands which leads to the problem.
You may also test
SET AUTOCOMMIT=1
explicitly in your program.
Note that LOCK TAB
Walt,
Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether
things are better than they were on 2.2 kernels but we're updating
tables just about that quickly I'd say. Largest table we have is a log
table which has 50 million rows in it so far. Thanks to Innodb row
locking,
Dan, you can use LIKE RLIKE and MATCH() AGAINST()
If that's what you're asking.
Dan wrote:
>
> Anyone know how to seach for a subsctring instead of the whole field? sql
>
> -
> Before posting, please check:
>http://www.my
Amazing! I've not had a chance to upgrade a server to
2.4 yet, though I've long imagined that the results would
be similar.
I imagine the biggest performance boost you received is
due to the built-in multi-threading that the 2.4 kernel
enjoys which is currently lacking in the 2.2 kernel.
L
600,000 row table?
what are you storing on that bad boy?
- Original Message -
From: "Weaver, Walt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 09, 2002 2:17 PM
Subject: MySQL on Linux 2.4 question
> Anyone else out there been playing with the new Linux 2.4 ker
Anyone know how to seach for a subsctring instead of the whole field? sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Anyone else out there been playing with the new Linux 2.4 kernel?
I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB
tests. The results were dramatic; updating a 600,000 row table went from 21
minutes and change to 6 minutes and change.
Haven't tried 2.4 and MyISAM tables
Walt / Heikki
Yes, I agree - with autocommit on, you do not need to supply COMMIT, and
yes, that's the same as other RDBMSs. What I'm pointing out though is
that I thought Heikki was suggesting that we need to supply the
BEGIN/COMMIT for a single command even if autocommit was on, in order to
In the last episode (Jan 09), D Woods said:
> I'm a novice at setting up a mysql database and don't know the answer to
> this. I usually set up my primary keys as autoincrementing ID fields. Now I
> need to have a primary key that isn't an autoincrementing field as I want to
> store the CFTOKEN an
yes, you can
-Original Message-
From: D Woods [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: primary key that doesn't autoincrement
I'm a novice at setting up a mysql database and don't know the answer to
this. I usually set up my pri
I'm a novice at setting up a mysql database and don't know the answer to
this. I usually set up my primary keys as autoincrementing ID fields. Now I
need to have a primary key that isn't an autoincrementing field as I want to
store the CFTOKEN and use it as the primary key. Can I not have a
non-au
The mysql user permissions are just a table in the mysql database. Whenever
you do a GRANT, you're really just doing an INSERT or UPDATE against this
table. You can do SELECTs, INSERTs, UPDATEs, etc. against this table (the
'user' table), just like any other table. The only way to "corrupt us
* Jerry Rehak
> 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
> a 03
> a 11
> a 12
> a 13 I want
John wrote:
> That's not something that is generally necessary with other RDBMSs.
I disagree. I would imagine all transaction-oriented RDBMS's work this way.
Oracle certainly does. You need to do an explicit commit or rollback to
release the lock. (or close the cursor, etc.)
Unless, of course, a
Not knowing the exact internals of how it works...
Assuming that it works much the same way other RDB's
work in their native GL's (generation languages), the
common practice with a relational database is to define/declare
a "cursor" with the SQL statement executed against the database.
After the
John,
MySQL runs by default in the auto-commit mode. In the auto-commit mode you
do not need to write the COMMIT after each statement.
But if you do SET AUTOCOMMIT=0, then you have to call commit explicitly.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at htt
On Wednesday, January 9, 2002, at 03:06 PM, Rick Emery wrote:
> 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" contain
Heikki,
Hmm. That's interesting. So if you do a single command, say
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
You actually need to write (I'm not sure of the exact transactional
syntax for Mysql) -
BEGIN ; --begin a transaction
INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ;
COMMIT ;
Easier method:
SELECT * FROM people ORDER BY RAND() LIMIT 1;
-Original Message-
From: David V. Edelstein [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 1:08 PM
To: 'Roger Baklund'
Cc: '[EMAIL PROTECTED]'
Subject: Random Select Statement - help please
Hi Roger,
Thanks fo
I was doing a flush privileges.
but this was coming up with the same thing no rows affected which to me was
concerning.
I have now got 1 user working but 1 user not.
I am going to delete all users and start again with the users, as at the
start I was not doing flush privileges and I was also tr
Since you told it to end each line with *END* , the carriage return
after the
*END* is part of the first field of the next line.
Try terminated by "*END*\r"
David Ayliffe wrote:
>I'm having trouble bulk-loading data into a table. I have a file which
>contains:
>
>AYL01ôAYL01-1ôChloeô1979-12-1
I'm fairly new to mysql. I have need for certain actions to occur
within a database at a certain time every month. What is the best way
to go about doing this? Is there a way to schedule these actions from
within mysql?
Thanks
jeff
-
* 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 Bord
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
altog
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 0:0:0ôF*EN
>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 exa
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 se
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 could
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 alter
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 see,
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/
* 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 po
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
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
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)
m
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, it
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 matt@"j
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
relational
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 W
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
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 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 li
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 books
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,
__ ___ ___ __
/
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/
-
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 anywa
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 p
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 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
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 receive
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 F
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 result
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 of
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
-
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 conn
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...
--login-to
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 I
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!
i
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 y
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
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
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.
T
* 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 func
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
>
> -
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: Wed
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
1 - 100 of 158 matches
Mail list logo
