- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 12:05 PM
Subject: pls help ...
hi ,
when i try to get mysql data to the web browser via
php , always it is showing
Parse error: parse error,
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: Eve Atley
Sent: Tuesday, February 24, 2004 2:15 AM
Subject: Re: MySql and php
thanx alot for ur reply , i think better to send my
script to u .In third collom , there is two different status . I want to
Togochog Enhebatu [EMAIL PROTECTED] wrote:
I am new in PHP, and I would like to create some user interface with PHP.
Could anyone tell me what is the easiest way to do this?
It's better to use PHP mailing list which is better decicated for this purpose:
What client are you using to connect to the server?
If its MyODBC 3.51 then that is your problem. It doesn't support
unicode yet.
If you are using the mysql command line client try select
Hex(your_column) from your_table; to see if the proper hex values are
being inserted into the table.
Hi Paul,
Using the following fixed things. However, I am surprised at why it is
not working in 4.0.18 (Win32)? Previously I had 4.0.17 (Win32) and
things work perfectly. I guess you are right, it's a bug.
[mysqld]
there must be some problem in concatenation of strings and number variables. If you
can send the lines, we'll be able to suggest the exact change.
Hope that helps
Nitin
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday,
Hi!
I have installed the mysql server and client on an RedHat 7.3 but after
installation I can't login as root. The message I get is:
I installed by using rpms
mysql -u root mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
The access rights to the
that's called, cache-hit
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 5:25 AM
Subject: Re: run query second time
Hi Mike,
- Original Message -
From: Mike Mapsnac
Sent: Monday,
Matt, Thomas,
Oh we are using Red Hat Enterprise Linux WS ver 3.0
Please enter a bug report at http://bugs.mysql.com. Thank you.
Thomas Taylor wrote:
what platform are you on?
On Feb 23, 2004, at 4:27 PM, Matt Silva wrote:
I am using the ~new~ MySQL Administrator and i'm trying to load
Hi
From: Maria Yndefors [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 11:35 AM
mysql -u root mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Try of following;
-
#mysql -u root -p password
-
connected in then
-
Hi, Thanks for the fast reply,
I have not set the root password and I get the same result
[EMAIL PROTECTED] gms]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Best Regards
/Maria Yndefors
-Original Message-
From: Davut
Maria Yndefors [EMAIL PROTECTED] wrote:
I have installed the mysql server and client on an RedHat 7.3 but after
installation I can't login as root. The message I get is:
I installed by using rpms
mysql -u root mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
Hi,
From: Maria Yndefors [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 11:54 AM
I have not set the root password and I get the same result
hmm..
You should set root password :)
Regards,
Jack..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Maria Yndefors [EMAIL PROTECTED] wrote:
Hi, Thanks for the fast reply,
I have not set the root password and I get the same result
[EMAIL PROTECTED] gms]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Do you have installed
are you using MySql 4.x?
try only
mysql
Hope that helps
Nitin
- Original Message -
From: Davut Topcan [EMAIL PROTECTED]
To: Maria Yndefors [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 3:37 PM
Subject: Fw: install problem
Hi,
From: Maria Yndefors [EMAIL
Randy Paries [EMAIL PROTECTED] wrote:
Hello
I have a number of servers.
I have one running RH7.3 with mysql-3.23.56-1.73
one running RH9 with mysql-3.23.58-1.9
My question is when i do a ps -ef
on RH7.3 a get a number of /usr/libexec/mysqld
on RH9 i only get one.
can someone
hi,
I wish to provide some more information too regarding MySQL
Server hangup.
Once after I execute the C sample program, WinMySQLAdmin tool
and query commands from *mysql* console never responds.
During this time if I try to start mysqld from another console
produce the following error
Hello All,
I have a very strange problem which makes no sense to me whatsoever.
I am trying to find the number of queries that the people have dealt with
in a database between two dates. The dates are generated from some drop
down boxes and dropped into a variable. This is the code for the
SQL
Hi, All!
Is 4.1.1 replication compatible with 4.0.x?
I have problem to replicate data from 4.0.17 to 4.1.1
show slave status show all are OK
perlicate position and the exec position are the same.
But if I update data on master, slave is not update own data :(
Best regards.
hi,
I have created the COBOL coding to test those C API from
MySQL. Upon executing this COBOL program too hangup the server
but here using mysql_error() I got the error message in a
variable as
*Can't open shared memory. Request event don't create (2)*
These Error I captured after running
$sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
and \'$Date2\' GROUP BY Username';
The strange thing is if I replace the $Date2 variable with a date manually
it works -. i.e.
Not a MySQL issue,
The following works on 4.0.16, for those of us who'd like to stick to the
stable release:
update controltable set nextid = 1 + (@prevval := nextid)
Note. There was a problem with this in 4.0.13--namely, the value of
@prevval sometimes was garbage. I reported this via the list, but got no
Hi,
No I have not have MySql installed before and I am using version 1.4,
but I used an my.cnf from another host with mysql 3.x
Now I can't even manage to start it I get the following in the log file
040224 14:39:01 mysqld started
040224 14:39:04 InnoDB: Started
040224 14:39:04 Fatal error:
MySQL baby [EMAIL PROTECTED] wrote:
Anyone using TONS of Query Cache for a high-traffic site?
Our search server is really sweating.
I was about to jump through a LOT of software loops to program
query caching at the app level, when I realized that MySQL had
it built-in already. (We're
Fantastic! This was indeed the problem and has solved it. Many thanks!
On Tue, 24 Feb 2004 13:14:51 +0100, Jigal van Hemert wrote:
$sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
and \'$Date2\'
Hi
Is it possible to make a column of TEXT data type as PRIMARY key ?
How to give the lenght for the below error ?
ERROR 1170 (42000): BLOB/TEXT column 'colname' used in key specification
without a key length
Thanks
Devashish Rughwani
--
MySQL General Mailing List
For list archives:
Maria Yndefors [EMAIL PROTECTED] wrote:
Hi,
No I have not have MySql installed before and I am using version 1.4,
but I used an my.cnf from another host with mysql 3.x
Now I can't even manage to start it I get the following in the log file
040224 14:39:01 mysqld started
040224 14:39:04
Thanks for the help, changing the privileges and resetting the root
password I managed to log in.
Best Regards
/Maria Yndefors
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: den 24 februari 2004 14:14
To: [EMAIL PROTECTED]
Subject: Re: install problem
Rughwani, Devashish (Devashish) [EMAIL PROTECTED] wrote:
Is it possible to make a column of TEXT data type as PRIMARY key ?
How to give the lenght for the below error ?
ERROR 1170 (42000): BLOB/TEXT column 'colname' used in key specification
without a key length
For BLOB/TEXT column you
Hi list,
I'm trying to get mysql replication set up for a distributed development
environment. The master is the production server, whereas the slaves are
part of the developers' sandboxes (on their own machines).
The master machine is using MySQL 4.0.15, the slaves a nice mix of 4.0.15+
and
Mark Maunder wrote:
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
There is:
REPAIR TABLE t1 USE_FRM
--
Sasha
embedding PHP scripts in between your HTML tags .. use vi or emacs
editor
:-)
sree
On Tue, 2004-02-24 at 11:44, Togochog Enhebatu wrote:
hi,
I am new in PHP, and I would like to create some user interface with PHP.
Could anyone tell me what is the easiest way to do this?
thanks a
[EMAIL PROTECTED] wrote:
I wrote a cold fusion script to migrate data from an access 2000 db to a
mysql 4.0.18 db and when I display the data with cold fusion I see these
little box characters in different spots.
I'm assuming that it's an issue with the encoding. How do I correct this?
Looks
Colin O'Connor wrote:
Hi,
I'm bundling MySQL with a Java app, and it is currently working on Windows
and Mac OS X. Right now I'm porting it to Solaris.
The problem I'm having is when I try to create a database (CREATE DATABASE
mydb) I get the error: ERROR 1006: Can't create database 'mydb'.
Jim Austin wrote:
Hello Folks,
Am trying to upgrade MySQL with rpms. rpm -Uvh
MySQL-shared-compat-4.0.17-0i386.rpm worked fine. When I try to upgrade
the client or server I get warnings that the files conflict with the
older versions that are currently installed. I've tried to erase the
Can MySQL store German characters such as ä, o, u and ß
Thinking the Problem all the way through
Michael Johnson
Managing Director Humphrey Consulting Limited BPEnet
13 Austin Friars
London
EC2N 2JX
[EMAIL PROTECTED]
tel:
fax:
mobile:
Hi
I have an application which uses Mysql 3.23 and a latin1 character set.
In a near future I will have to deal with texts in french, italian,
korean and japonese. I'm looking into UTF-8 for mysql.
I did not see anything which enable UTF-8 for mysql 3.23 or 4.0 :
character set list does not
I've found a performance issue with a series of mysql queries that I make
to generate a web page. But, when I go to investigate it, reloading the
page a few times, I find the performance of the pages within a couple tries
becomes very fast.
So, it's hard to track down and work on the queries
From: Bill Marrs [mailto:[EMAIL PROTECTED]
I've found a performance issue with a series of mysql queries
that I make to generate a web page. But, when I go to
investigate it, reloading the page a few times, I find the
performance of the pages within a couple tries becomes very
fast.
Are you logging slow queries? Have you run an explain plan for the
queries in question?
Original Message
On 2/24/04, 10:29:33 AM, Bill Marrs [EMAIL PROTECTED] wrote regarding
disabling optimizations to identify slow queries:
I've found a performance issue with a series of mysql queries
(Asking again)
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with 'mysqldump --opt' began failing with the
message: 'mysqldump: Error 1030: Got error 12 from table handler when
dumping table `reference` at row: 255233'. The table has about
Hi Beau,
basically, you can use anything from MySQL 3.x, as you like it. I'm on an
Internet Newsboard System for a while and switched that to UTF-8 for all
data handling, display and storage. (Even sending out UTF-8 e-mails and
Jabber messages...) You just have to give MySQL the UTF-8 encoded
Hello All,
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2 different DBs.
And I want to run the SAME where clause on both tables...
Thanks in advance,
-Lorderon.
--
MySQL General Mailing List
For list archives:
At 11:35 AM 2/24/2004, Mike Johnson wrote:
It sounds like query caching is working against you.
There are a variety of ways to get around it. While it'll be a PITA, you
may want to have you script call `RESET QUERY CACHE` at the begining, and
then include `SQL_NO_CACHE` in your SELECT
Hi list peeps
In many of my projects I have the need to insert a new record into a table and then
later on in the script update this record, Right now I am doing this by doing the
insert, then immediately doing a Select to return the latest id (unique id) which I
store later for my update.
Nope, this would yield a 'Column: 'avg' in field list is ambiguous'
error. I'm still trying to work out a better way of doing this. I also
need to get standard deviations now, and the method I mentioned in my
original post doesn't even work for that. So now I'm left with actually
getting all
On 24 Feb 2004 at 12:00, Bill Marrs wrote:
Actually, I just noticed that even after I restart mysql, the speed
stays. That doesn't make any sense, maybe there is some other unknown
factor influencing this.
Sounds like it's your operating system's caching of the disk reads.
--
Keith C. Ivey
Suppose I have two tables like this:
keystone_storesmanagers
=
id | store_nameid | manager_name | manager_type |
store_id
+---
At 19:04 +0200 2/24/04, Lorderon wrote:
Hello All,
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2 different DBs.
And I want to run the SAME where clause on both tables...
What's the problem with using UNION?
--
Paul DuBois,
At 17:02 + 2/24/04, David Scott wrote:
Hi list peeps
In many of my projects I have the need to insert a new record into a
table and then later on in the script update this record, Right now
I am doing this by doing the insert, then immediately doing a Select
to return the latest id
Paul DuBois [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
At 19:04 +0200 2/24/04, Lorderon wrote:
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2 different DBs.
And I want to run the SAME where clause on both
You could try creating a function in Java or C/C++ or whatever your
preference is that wraps the select statements up for you and returns the
insert ID.
Original Message
On 2/24/04, 11:02:51 AM, David Scott [EMAIL PROTECTED] wrote regarding
INSERT returning ID:
Hi list peeps
In many
Would creating a merge table be a solution for you?
Original Message
On 2/24/04, 11:04:53 AM, Lorderon [EMAIL PROTECTED] wrote regarding
Union EXACT Tables:
Hello All,
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2
At 12:07 PM 2/24/2004, Keith C. Ivey wrote:
Sounds like it's your operating system's caching of the disk reads.
Yikes... that would explain it.
um... anyone know how to disable disk caching on Linux 2.6 kernel?
-bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 19:18 +0200 2/24/04, Lorderon wrote:
Paul DuBois [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
At 19:04 +0200 2/24/04, Lorderon wrote:
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2 different DBs.
And I want
Sounds like you want to do:
Select store_name, t1mgr.manager_name as 'type_1_manager',
t2mgr.manager_name as 'type_2_manager'
From (keystone_stores ks left join managers t1mgr on ks.id = t1mgr.store_id
and t1mgr.manager_type = 1)
Left join managers t2mgr on ks.id = t2mgr.store_id
and
but there are ways to get this value. The Java API handles this case
just fine, and I'd be willing to bet other API's do it as well.
here's some simple code to do with the Java API:
String sql = some insert sql statement;
Statement stmt = getConnection().createStatement();
At 10:25 -0700 2/24/04, Jeff Mathis wrote:
but there are ways to get this value. The Java API handles this case
just fine, and I'd be willing to bet other API's do it as well.
I know that, but that isn't what he asked.
here's some simple code to do with the Java API:
String sql = some insert
Thanks for your help... appreciate it...
MERGE table type is what I searched for :-)
Thanks
-Lorderon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi,
what's about http://bugs.mysql.com/bug.php?id=2915 [Bug: Installation of
Grant Tables failed!] ??
I have the same problem, how it described in this bug report. but nobody
could say me if this is a bug or merely a mistake on my part.
I would be really great if anybody could answer, because I
Hello there guys,
I needed to transfer my db from one MySql server to another, and
exported the table in a .sql file. The problem is that when i try to
import it gives an error. Here is the code that is giving the error:
INSERT INTO `phpbb_posts_text` (`post_id`, `bbcode_uid`, `post_subject`,
I am converting from Access 2.0 to MySQL and I am going through all of
my code to make it compatible with MySQL. I was testing my Update for
one of my queries and I don't know if I found a bug or if MySQL was
designed to do this.
In my program I pass an UPDATE string to MySQL. There can be
Quoting [EMAIL PROTECTED]:
Sounds like you want to do:
Select store_name, t1mgr.manager_name as 'type_1_manager',
t2mgr.manager_name as 'type_2_manager'
From (keystone_stores ks left join managers t1mgr on ks.id =
t1mgr.store_id
and t1mgr.manager_type = 1)
Left join managers t2mgr on
I attempted to create a merge table across two identical InnoDB tables
and it seemed to work without error. But when I went to use the table I
got a file not found my_table.MRG (error number 2) error. The file does
in fact exist, but it is only 54 bytes.
I'm guessing that I can only create
Thanks Sasha. It helped trim down my table a bit
Eric
Sasha Pachev [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Eric B. wrote:
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid`
At 14:30 -0300 2/24/04, Tenchi Muyou wrote:
Hello there guys,
I needed to transfer my db from one MySql
server to another, and exported the table in a
.sql file. The problem is that when i try to
import it gives an error. Here is the code that
is giving the error:
INSERT INTO
I think you may have introduced the From typo, but it is one regardless. I
don't think the parens are necessary. Try it out.
Ted Gifford
-Original Message-
From: Gregory A. Swarthout [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 9:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Might sound like a silly question, but have you checked the write
permissions to the data dir? Am not sure if it is the mysql daemon that
needs write access or if it is the user logged on
Colin O'Connor [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I'm bundling MySQL
At 9:36 -0800 2/24/04, Jacque Scott wrote:
I am converting from Access 2.0 to MySQL and I am going through all of
my code to make it compatible with MySQL. I was testing my Update for
one of my queries and I don't know if I found a bug or if MySQL was
designed to do this.
In my program I pass an
I'm not 100% sure, but this type of programming would seem to be opening the
doors for bugs down the road that get difficult to trace and to track. If
you are using a multi-threaded app, then you have to make sure that you
prevent any mods to the DB after your insert and before your select. If
Sorry guys, i only seen i sent directly to Paul after i sent it ...
Forwarding to the list.
Original Message
Subject: Re: Inserting values with ;. How?
Date: Tue, 24 Feb 2004 15:05:59 -0300
From: Tenchi Muyou [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
References:
At 15:06 -0300 2/24/04, Tenchi Muyou wrote:
Sorry guys, i only seen i sent directly to Paul
after i sent it ... Forwarding to the list.
Original Message
Subject: Re: Inserting values with ;. How?
Date: Tue, 24 Feb 2004 15:05:59 -0300
From: Tenchi Muyou [EMAIL PROTECTED]
To:
Hi!
On Feb 23, Gelu Gogancea wrote:
Hi,
TABLE CREATE DESCRIPTION :
CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC
INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC));
RUNNING CONDITIONS:
-use persistent connection.
What do you mean persistent connection ?
Persistent PHP connections ?
Hello everyone,
I'm new to the list and did a little searching on the archives but
wanted to ask my question to the group.
I have a requirement to encrypt all data stored into a database. I was
wondering if there was a different way of doing this or should I use the
encrypt/decrypt functions?
I am converting an Access95 DB to mySQL. The interface will remain in Access95. I
encountered a problem with one of the existing queries. The code for the query is:
SELECT DISTINCTROW ManualChecksPrinted.AccountNum, ManualChecksPrinted.CheckNumber,
ManualChecksPrinted.AccountID,
Hi,
I am currently running mysql4.0 and I will like to upgrade to 4.1 to
support unicode for languages such as korean, Japanese, Spanish and so on.
I do not want to upgrade but simply perform a fresh install and create
new databases to support unicode. When I perform this upgrade, the MYSQL
Hello List:
First my apology: I have previously asked this question and saved the
response. But we lost our Win NT server and all the saved data, so I ask the
same question again. I have looked in archives for the last three months and
have not been able to find my previous Q/A. I will be setting
Mail messages start with From. When you begin a line with From in
the body of your message, your mailer, like most, prepends a to
prevent it from being interpreted as the start of another message. You
can usually avoid this yourself by prepending a space.
Michael
[EMAIL PROTECTED] wrote:
I
Mike Koponick wrote:
The idea is that if someone stole the hard drive or computer, it would
be hard for someone to break into the database. It seems to me the best
way would be to encrypt the drive space, and use the login to
authenticate the encryption space on the hard drive.
How about sth like
[EMAIL PROTECTED] wrote:
I think you may have introduced the From typo
historitrivia
! Try looking at a mailbox in a text editor -- you'll notice that
the string 'From ' occuring at the beginning of a line is used as
the message separator.
Thus when that string occurs within a message body, it
What is being logged to the *.err log in the data directory?
Original Message
On 2/24/04, 12:42:19 PM, Dale Goolcharan [EMAIL PROTECTED] wrote
regarding Fresh/New install of MySql 4.1 :
Hi,
I am currently running mysql4.0 and I will like to upgrade to 4.1 to
support unicode for
MySQL is designed to do that. If no data is changed, then MySQL will not
perform the update.
Original Message
On 2/24/04, 11:36:39 AM, Jacque Scott [EMAIL PROTECTED] wrote
regarding Updating a Record:
I am converting from Access 2.0 to MySQL and I am going through all of
my code to make
Configure your my.cnf data_dir parameter to point to the raid Hard Drive.
Original Message
On 2/24/04, 12:44:13 PM, Kirti S. Bajwa [EMAIL PROTECTED] wrote regarding
How to install data on a RAID HDD??:
Hello List:
First my apology: I have previously asked this question and saved the
I have no problem installing MySQL on the main HDD but can not figure out
what changes are needed so all the data goes to RAID disks. I am a newbie so
please, give direction!!
The easiest way to do this would be to move the data directory and
all its contents onto the RAID disks. Then
Hi,
Is there a useful list of updates that have gone in to Mysql since late 3.0 releases?
I'm always having to manually coax replication between a couple of servers and was
wondering if replication has become more resilient in later releases.
I've reloaded the database on the slaves and once
Hello
OS: Unix MySQL:4.0.16
OS: Linux MySQL:4.0.17
I am trying to limit the size of the MyISAM tables in a MySQL database. As far as I
can tell, my only option is using the MAX_ROWS parameter on a table. I am not looking
to do this limit at the OS level.
I wanted to test how the max_rows
Hi All,
Thank you very much for the kind and ample help !
I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have
created a new user 'mysqladm' to run the server.
I manually start the server now via :
sudo mysqld_safe --user=mysqladm
I have two questions :
1. Why does
Greetings,
I used the 'scp' command to copy the file.MYD, file.MYI and file.frm files
from one linux box to another linux box.
On the source linux box, the table is like this:
mysql desc file;
+--+---+--+-+-+---+
| Field| Type
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
that comes with it). I decied to install 4.0 and used
this command to install it:
rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm
I didn't see any obvious errors thereafter. After rebooting
noticed that looks like the mysql daemon is
At 15:46 -0600 2/24/04, Bing Du wrote:
Greetings,
I used the 'scp' command to copy the file.MYD, file.MYI and file.frm files
from one linux box to another linux box.
On the source linux box, the table is like this:
mysql desc file;
I wanted to test how the max_rows parameter works. I set it to 3 on a
table. And, I was able to add 33 records [I stopped at this point]. It
never prevented me from adding more records. The result is NOT what I
expected. I expected that upon attempting to add the 4th record, I would
have
At 16:26 -0500 2/24/04, Tristan Fiedler wrote:
Hi All,
Thank you very much for the kind and ample help !
I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have
created a new user 'mysqladm' to run the server.
I manually start the server now via :
sudo mysqld_safe
At 15:37 -0600 2/24/04, Database Administrator wrote:
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
that comes with it). I decied to install 4.0 and used
this command to install it:
rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm
I didn't see any obvious errors thereafter. After
Hill, Keith wrote:
I am converting an Access95 DB to mySQL. The interface will remain in Access95. I encountered a problem with one of the existing queries. The code for the query is:
SELECT DISTINCTROW ManualChecksPrinted.AccountNum, ManualChecksPrinted.CheckNumber,
On 24 Feb 2004 at 22:01, Alison W wrote:
Yes: MAX_ROWS is a *guidance* to the system in setting up the table
and not a *limit* in any way.
Well, it is a limit in one way. MySQL uses it (in MyISAM tables) to
calculate the size of the pointer used for positions within the data
file. If the
Paul, your guess was absolutely correct. Looking at the information
pointed to by the URL you sent, seems it's pretty easy to switch to the
old format. That's good. Thanks for the heads-up!
Bing
At 15:46 -0600 2/24/04, Bing Du wrote:
Greetings,
I used the 'scp' command to copy the file.MYD,
Worked like a charm.
Thanks. You are a life saver.
Kirti
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 2:21 PM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: Re: How to install data on a RAID HDD??
I have
I am beginning the process of moving an exising MySQL/Apache server, (or
rather, several of the sites there) to a new machine, to spread the
load, and allow us to upgrade the servers bit by bit.
Versions of MySQL are both 3.23.58
Apache and PHP, etc, is set up and humming along nicely, doing
hi,
I am using mysql 4.0.14. I have a table where one of the fields has a
datatype longblob. What I am trying to do is to enter a genome sequence which
has around 175 characters. the file size is about 1.5MB which is well
within the longblob size. I am using python to enter the sequence
You also need to install the rpm for mysql-client.
Bernard
On Tuesday 24 February 2004 16:37, Database Administrator wrote:
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
that comes with it). I decied to install 4.0 and used
this command to install it:
rpm -Uvh --nodeps
1 - 100 of 115 matches
Mail list logo
