How are you exporting/importing the data?
-Original Message-
From: Fajar Priyanto
To: [EMAIL PROTECTED]
Sent: 4/20/04 3:51 AM
Subject: error importing date
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I encounter this error when importing database from one mysql server
into
I am not certain but it appears that you date values are shifting to the
right. Can you create a test case using timestamp(14) and see if the error
occurs?
-Original Message-
From: Fajar Priyanto
To: Victor Pendleton; ''[EMAIL PROTECTED] ' '
Sent: 4/20/04 10:19 AM
Subject: Re: error
Are you exporting/importing the DDL as well? Is the column type the same for
both tables?
What is that column type? TIMESTAMP(14)?
-Original Message-
From: Fajar Priyanto
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 4/20/04 9:16 AM
Subject: Re: error importing date
-BEGIN PGP
Are you logging slow queries? If so, have you looked in the slow query log?
-Original Message-
From: Ronan Lucio
To: [EMAIL PROTECTED]
Sent: 4/20/04 1:58 PM
Subject: Process Monitoring
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our
Do you have any around the approximate time? The timestamp will be will the
query was written to the slow log and how long it took. What are the
symptoms that lead you to believe that it is a slow running query?
-Original Message-
From: Ronan Lucio
To: Victor Pendleton; [EMAIL PROTECTED
captured or
monitored the CPU and memory usage during this time?
-Original Message-
From: Ronan Lucio
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 4/20/04 3:34 PM
Subject: Re: Process Monitoring
Victor,
Do you have any around the approximate time?
I know the time that the problem occurred
The you will need to use the second format.
DATE_FORMAT(queue_time, '%Y%m%d') = CURRENT_DATE()
-Original Message-
From: Dirk Bremer (NISC)
To: [EMAIL PROTECTED]
Sent: 4/16/04 4:09 PM
Subject: Re: SQL Query Question
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED
Are you running the queries in parallel or serially? Are you using the same
connection? Are you issuing Low Priority Updates?
-Original Message-
From: Sahil Aggarwal
To: [EMAIL PROTECTED]
Sent: 4/16/04 8:27 AM
Subject: row locking
hi all,
i have select statements in my java code which
Why not try to create a full text index on the column?
-Original Message-
From: jeroen clarysse
To: [EMAIL PROTECTED]
Sent: 4/16/04 9:00 AM
Subject: Need help with indexing !
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and
only 3 columns. One of these (called
Which logs are you referring to? For you testing purposes, if you have not
already, I would enable the general log and see what is happening on the
MySQL side.
-Original Message-
From: Josh Endries
To: [EMAIL PROTECTED]
Sent: 4/15/04 9:27 PM
Subject: repeated/duplicated query problem
You can rename it at the filesystem level.
-Original Message-
From: Chen, Jenny
To: '[EMAIL PROTECTED]'
Sent: 4/16/04 10:18 AM
Subject: rename database
Experts:
Is it possible to rename existing database ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Can you please post your DDL?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/16/04 10:22 AM
Subject: Foreign Keys
hi,
I am new to mysql. I am trying to create tables with foreign key
constraints.
but the constraintsdoesnt seem to be showing any effect on the
Oversight on my part. This will not work for those table types.
-Original Message-
From: Paul DuBois
To: Victor Pendleton; 'Chen, Jenny '; ''[EMAIL PROTECTED]' '
Sent: 4/16/04 10:43 AM
Subject: RE: rename database
At 10:28 -0500 4/16/04, Victor Pendleton wrote:
You can rename
Paul,
Do you know if there will be an
ALTER DATABASE RENAME curName TO newName
implementation?
-Original Message-
From: Victor Pendleton
To: 'Paul DuBois '; Victor Pendleton; ''Chen, Jenny ' ';
'''[EMAIL PROTECTED]' ' '
Sent: 4/16/04 10:55 AM
Subject: RE: rename database
Oversight
Thanks for the information.
-Original Message-
From: Paul DuBois
To: Victor Pendleton; '''Chen, Jenny ' ' '; [EMAIL PROTECTED]' ' ' '
Sent: 4/16/04 11:18 AM
Subject: RE: rename database
At 11:03 -0500 4/16/04, Victor Pendleton wrote:
Paul,
Do you know if there will be an
ALTER
Try creating your tables as such:
CREATE TABLE test1(ser INT(5) NOT NULL,
age INT(2),
PRIMARY KEY (ser) )
TYPE=InnoDB;
CREATE TABLE test1(serno INT(5) NOT NULL,
name VARCHAR(20),
KEY 'idx_serno' (serno),
CONSTRAINT FOREIGN KEY(serno) REFERENCES `test1` (ser) )
TYPE=InnoDB;
-Original
WHERE queue_time = Now() + 0
Are you wanting just the date or the datetime?
-Original Message-
From: Dirk Bremer (NISC)
To: [EMAIL PROTECTED]
Sent: 4/16/04 2:54 PM
Subject: SQL Query Question
I have a simple table where one of the columns is named queue_time and
is
defined as a
%m%d') = CURRENT_DATE() + 0
...no index usage though
-Original Message-
From: Dirk Bremer (NISC)
To: [EMAIL PROTECTED]
Sent: 4/16/04 3:25 PM
Subject: Re: SQL Query Question
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Dirk Bremer (NISC) ' [EMAIL PROTECTED
Does this happen with a mysqladmin shutdown command as well?
-Original Message-
From: TO
To: [EMAIL PROTECTED]
Sent: 4/14/04 5:23 AM
Subject: Problems with clean NET STOP MYSQL on Win2000 server after adding
INNODB space
Help!
We're running MySQl on Win2000 server.
The other day our
Does this machine have a valid server-id? Run show variables like
'server_id' from the mysql monitor. Also, is there anything in the *.err
file on this machine?
-Original Message-
From: jim
To: [EMAIL PROTECTED]
Sent: 4/14/04 3:26 PM
Subject: Server not configured as slave
Hi,
Can
Have you tried to update an underlying heap table? The heap table will not
be updated. A view is updated when any of the underlying table(s) are
updated.
-Original Message-
From: Abiola Aluko
To: [EMAIL PROTECTED]
Sent: 4/13/04 8:01 AM
Subject: What is the difference Between the mysql
I agree with Peter, 50 queries per second is not a MySQL limit. Have you
checked the slow
query log or the *.err log file to see if anything is being logged or if
`bad-performing`
queries are causing this bottleneck? Have you checked your variables to see
what your
`max-connections` variable is?
You can use mysqldump, then zip up the files. Do not forget to backup your
innodb directories
if you are using InnoDB tables and grab the my.ini/my.cnf file. Once you
have re-installed
windows just place the directories/files on the new file system and adjust
your my.ini/my.cnf
if necessary.
machine.
Victor
-Original Message-
From: Dan Johnson
To: [EMAIL PROTECTED]
Sent: 4/12/04 9:16 AM
Subject: Re: Queries per second average
Victor Pendleton wrote:
I agree with Peter, 50 queries per second is not a MySQL limit. Have
you
checked the slow
query log or the *.err log file to see
You will need to be using MySQL 4.1.x in order to perform sub-selects.
-Original Message-
From: Steve Pugh
To: [EMAIL PROTECTED]
Sent: 4/12/04 11:01 AM
Subject: Multiple SELECTs in one query
Hello, all!
I am porting my Visual Basic app over from MSDE to MySQL, and things so
far are
It depends on the variable. Can you give an example of the variable you are
trying to set?
As far as the load data infile, I believe it depends on how your database
will be accessed.
If you have a need for remote administration or are working with
geographically separated databases then the
Can you create a 'fact' table containing the infomration that you are
querying? This goes
against normalization but if the table will only be used for querying
purposes then this
will eliminate your need to perform joins.
-Original Message-
From: Tim McDonough
To: [EMAIL PROTECTED]
Sent:
What information is being logged in *.err?
-Original Message-
From: Ginger Cheng
To: [EMAIL PROTECTED]
Sent: 4/8/04 10:20 AM
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu
(i386). I
started mysql server
What is your max packet size? Are you able to determine where the `error`
occurs in the process? During the load of the temporary table? During the query
of the temp table?
On Wed, 07 Apr 2004, Ginger Cheng wrote:
Hello, MySQL gurus,
I have been trying to output the result of some large
If you are unsure you should make a copy of the table and perform you test
actions on that table. The answer is yes you can convert your unsigned integer
column to a varchar column.
On Mon, 05 Apr 2004, joe collins wrote:
I have a table that has a column :
session_id INTEGER UNSIGNED NOT
, the server still alive, I have a monitor that
displays all the active connections, the hostname.err file doesn't log
new
lines, do I have to check out something else?...
Thanks in advance
Mikel
From: Victor Pendleton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Mikel - [EMAIL PROTECTED], [EMAIL
Can you add a timestamp field in your table? This field will be updated upon
insertion and updates.
On Thu, 01 Apr 2004, Jeff Cook wrote: Is there any way
to see what date a record was changed on? I am building a database of mostly
imported CSV files. The files would be imported on the day
When this happens are you able to ping the MySQL server? The literal error
message is Resource temporarily unavailable
Have you looked in the hostname.err file to see if anything else is being
logged?
On Thu, 01 Apr 2004, Mikel - wrote: Hi list, I'm having
the following problem when I tried
Are you just wanting to remove the header information? If so, then try
mysql --skip-column-names
On Thu, 01 Apr 2004, Seena Blace wrote:
Hi,
I'm getting output like
select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from
host a,ipdet_temp1 b,makemodel c,software
Try this:
When you add an AUTO_INCREMENT column, column values are filled in with sequence
numbers for you automatically.
For MyISAM tables, you can set the first sequence number by executing SET
INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table
option. See section
Did you check in the hostname.err file to see why MySQL ended?
On Wed, 31 Mar 2004, muhammad alqama wrote:
hello
i am using slackware linux and i installed mysql
server with the installation.
now i am trying to start the mysql daemon but it is
not being start.
i have run
What do you have access to? SSH? ODBC? Port Access?
On Thu, 25 Mar 2004, Erich Beyrent wrote:
Hi there,
I am running a website on a host who has blocked access to mysqldump.
Is there any way I can show all the sql commands for creating and
populating a table from within mysql? Again, I
Does the where clause contain the order by columns? If not, then you will have
a filesort no matter what.
On Wed, 24 Mar 2004, Henrik Schröder wrote:
Hi all,
I have a table of users which contains a lot of information, and also a
column called membershiptype which can either be 0, 1, or 2.
Let me rephrase my statement. Does the index being used include the order by
columns? If not, the optimizer will not be able to perform both row selection
and row ordering in the same pass.
On Wed, 24 Mar 2004, Victor Pendleton wrote:
Does the where clause contain the order by columns
the biggest problem, right?
/Henrik
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: den 24 mars 2004 16:22
To: [EMAIL PROTECTED]; Henrik Schröder; '[EMAIL PROTECTED]'
Subject: Re: How to optimize ugly order by?
Let me rephrase my statement. Does
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote:
I have a series of tables that were created by:
CREATE TABLE ifInOctets (
id int(11) NOT NULL default '0',
-
From: Victor Pendleton [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ]
Sent: Wednesday, March 24, 2004 12:24 PM
To: Jack Coxen; MySQL List (E-mail)
Subject: Re: Index not functioning
The optimizer is informing you that `it` believes a table scan is more
efficient than using
Are you wanting to turn off replication from the master or the slave?
On Tue, 23 Mar 2004, Sam Yathira wrote:
Content-Type: multipart/alternative; name=unnamed
Content-Transfer-Encoding: 7bit
Content-Description:
Remove log-updates option from the my.cnf file.
And remove the master info from the slaves.
On Tue, 23 Mar 2004, Sam Yathira wrote:
That was quick!
I am trying to turn it off from master.
--Sam
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday
This error should be logged. Do you have a file called hostname.err in your
directory?
On Mon, 22 Mar 2004, Daniel Gaddis wrote:
I copied the following from my coldfusion application.log
Error,2152,03/20/04,09:03:13,,ODBC Error Code = S1000 (General
error)P [MySQL][ODBC 3.51
As of now, there is no MySQL equivalent to PL/SQL.
On Mon, 22 Mar 2004, Seena Blace wrote:
Hi,
i want to update couple of columns like
update tablename
set =value1
where columname=value2;
I want to run query on mysql prompt each time and enter value1 and
value2 for diffrent columnname ?
UPDATE table1 t1, table2 t2, table3 t3
SET t1.date = '2004-03-18'
WHERE t1.id_2 = t1.id_2
AND t3.id_1 = t2.id_1
On Thu, 18 Mar 2004, Russell Horn wrote:
I haev three tables:
Table 1
id_2 | date
Table 2
id_1 | id_2
Table 3
id_1
I want to set the table1.date = '2004-03-18'
1. The column types must match in order to establish a foreign key
relationship. Alter the data type would invalidate the Foreign key. Therefore
the key must be dropped first.
2. You can not have a relationship on a column that does not exists. Once again
the key must first be dropped.
3-4.
If the directory structure is the same and the snapshot is consistent then
the answer is yes. If you do not want to purchase a commercial utility, one
method is to schedule mysqldump, compress the file and then backup that file
up.
-Original Message-
From: Ansari, Raza (GEI, GEFA)
To:
A slave can connect to only one master.
-Original Message-
From: Ari Davidow
To: [EMAIL PROTECTED]
Sent: 3/12/04 12:30 PM
Subject: two masters, one slave
Is it possible to have two masters and one slave? I'm trying to
replicate
two master databases so that I have a failover.
The
Is it the same database, same user? Does it follow any maintenance or large
import?
-Original Message-
From: Terence
To: [EMAIL PROTECTED]
Sent: 3/11/04 12:25 AM
Subject: Privilege to single database being revoked occasionally
Dear Lists,
We moved to 4.1.0 when it was first launched,
This display has been fixed in Red Hat 9.0. If you look at the list, the
children processes are not consuming memory, since the memory is shared.
-Original Message-
From: Rocar Peças
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 3/11/04 5:54 AM
Subject: Re: Serveral mysqld instances
Mr
Any reason you can use a version of MySQL that contains transaction aware
tables?
-Original Message-
From: Andy Hall
To: [EMAIL PROTECTED]
Sent: 3/11/04 8:29 AM
Subject: Best practise roll-backs?
Hi,
I have a PHP script that is running 4 queries. If the 4th fails, ideally
I would like
If you are wanting each database to replicate only certain databases then
you should look over the replication commands.
http://www.mysql.com/doc/en/Replication_Options.html
--replicate-do-db=database_name
might be able to solve your issue.
-Original Message-
From: ron
To: [EMAIL
Can you post some sample data and ddl?
-Original Message-
From: Jacque Scott
To: [EMAIL PROTECTED]
Sent: 3/11/04 3:12 PM
Subject: Mysterious 'x' when retrieving records
I have a very simple query
SELECT ProblemReports.* FROM ProbelmReports;
If there is no data in the column
Rough example. Assuming that you are using the same connection since
last_insert_id() is connection specific.
rset.open INSERT INTO table1 values(someValue)
rset.open SELECT last_insert_id() as identity
identity = rset.fields(identity)
-Original Message-
From: Aaron
To: [EMAIL
Are you looking at ps -aux | grep mysql (or some variant) to determine this?
-Original Message-
From: Rocar Peças
To: [EMAIL PROTECTED]
Sent: 3/10/04 4:19 PM
Subject: Serveral mysqld instances
Hi, Folks!
I get a MySQL 4.0.18 server running on a Conectiva Linux Kernel 2.4.5.
The MySQL
Can you supply us with an example? Some explain plans to corroborate your
reported slowness.
-Original Message-
From: Andrey Chernyh
To: [EMAIL PROTECTED]
Sent: 3/9/04 3:35 AM
Subject: Performance problem with 4.0.18
Hello All!
After we converted our tables from MyISAM to InnoDB the
How are you shutting down MySQL?
-Original Message-
From: ikm [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 11:14 PM
To: [EMAIL PROTECTED]
Subject: Shutdown error
Every shutdown MySQL I found error as this
shutdown failed; error: 'Access denied for user: '@localhost'
You will need to place the following at the head of your dump file.
SET FOREIGN_KEY_CHECKS=0
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 10:28 AM
To: [EMAIL PROTECTED]
Subject: mysqldump table order with foreign keys
Hey all,
I'm
What is the MySQL process running at during this time?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 9:19 AM
To: [EMAIL PROTECTED]
Subject: MySQL runs slow on windows 2003
Hello,
I have upgraded win 2000 to 2003 and since this moment, MySQL
What does your Windows Task list -- Processes show when you are running at
a high cpu usage?
Is French your native language?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 11:51 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL runs slow on windows 2003
list.
At 20:25 19/12/2003, Victor Pendleton wrote:
What does your Windows Task list -- Processes show when you are running at
a high cpu usage?
Is French your native language?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 11:51 AM
To: [EMAIL
Do you only have the Microsoft DBF and ldf files?
-Original Message-
From: Mark Graves [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
I run a website using MySQL, PHP, and CFMX.
Try slave start
-Original Message-
From: Andrew Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: replication question
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 1064'
Try the Replace function
replace the `-` character with ``
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: MYSQL-List (E-mail)
Subject: String Functions
Is there any function to strip non numeric characters from a string?
What programming language are you using? You could write a method to compare
each character and return only those 0-9 as the output and discard the rest.
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:26 AM
To: Victor Pendleton; MYSQL
Do not escape the single ticks.
-Original Message-
From: Jorge Infante Osorio. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 8:32 AM
To: [EMAIL PROTECTED]
Subject: Problem whit DELETE
Hi, I new in this list and I have a problemand I hope that
any of you can resolve or
Are you placing the file in the same directory as the MySQL data files? Are
the databases and the location you placed the text file on the same physical
drive?
-Original Message-
From: Hans Kind [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 7:22 AM
To: [EMAIL PROTECTED]
Are the crashes occurring on the same machines? Or random machines? Can you
track the disk activity at the time the table is being marked as corrupt?
Are you tracking the database activity?
-Original Message-
From: fabien marsaud [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003
Can you post what you are trying to do?
-Original Message-
From: Prasad Budim Ram [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 2:17 AM
To: [EMAIL PROTECTED]
Subject: Needing help for JDBC issue
Hi,
I'm getting the following error while connecting to a MySQL databases
Can you check to see what messages are logged in the error log? Did you
install MySQL as a service? Is the service set to start up automatically?
-Original Message-
From: William IT [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 6:41 PM
To: [EMAIL PROTECTED]
Subject: Mysql
Can you please post the error?
-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I
You need to connect as a privileged user. You should delete the anonymous
account for security reasons.
-Original Message-
From: Shane Korosec [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 1:56 AM
To: [EMAIL PROTECTED]
Subject: Access denied error
I have recently installed
you could put the password in your .my.cnf file and change permissions so
that only the MySQL user can read the file.
-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:15 AM
To: [EMAIL PROTECTED]
Subject: mysqldump query
Hi guys,
I have
What seems to be the problem? Are you getting an error message? If so can
you post the message?
The syntax is \. fileName
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a
It seems that 4294967295, the max value for an unsigned int, is not large
enough. Is there an issue with using bigint or storing the value in char
format?
-Original Message-
From: John A. Sullivan III [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:18 AM
To: [EMAIL PROTECTED]
table_privs is going to assign privileges at the individual table level
grant select on database.tablename to user@'192.168.0.10' IDENTIFIED BY
'password'
-Original Message-
From: Nikos Gatsis [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:20 AM
To: [EMAIL PROTECTED]
where to find the file. If I have to point to it, do I then
just type at the mysql prompt
mysqlsource d:/apache/apache2/htdocs/public_html/weather/stations.sql;
Please advice once again
Thanks
Victor Pendleton [EMAIL PROTECTED] 11/17/03 08:22AM
What seems to be the problem? Are you getting
Was there actually a syntax error? Can you please post the query? The
display for the error message appears to be truncated.
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:44 AM
To: [EMAIL PROTECTED]
Subject: Error message problem
I just
, November 17, 2003 9:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysqldump query
Hi Victor,
Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)
From: Victor Pendleton [EMAIL PROTECTED]
To: 'patrick kuah' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE
insert into
...
select
...
-Original Message-
From: Dr M Karthikeyan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: copy the result content from one db to another
I would like to copy the contents of result set by
single command
e.g.,
do a ps -ef | grep mysql (or the equivalent for your system) and see if you
have any other mysql daemons running?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 2:40 PM
To: [EMAIL PROTECTED]
Subject: [Mysql] mysqld ended
Hi, I am
do a show status like 'open_files'
and a show variables like 'open_files_limit'
-Original Message-
From: William Bailey [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: Please help. MySQL Error.
-BEGIN PGP SIGNED MESSAGE-
Hash:
Can you post the error message you are getting?
-Original Message-
From: Quique Luna [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 4:33 PM
To: [EMAIL PROTECTED]
Subject: Inserting Colons in a Table
Hi,
I'm trying to load some data into a MySql table, but some of the
A full table scan was performed on the rwt_screens table. The /* ... */
means that if the dbms is 4.0.x then do not cache this query.
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 8:52 AM
To: Mysql (E-mail)
Subject: Question on slow
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts,
execute show grants for nestor@'%' and see what that user has.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 12:21 PM
To: Nestor Florez; [EMAIL PROTECTED]
Subject: Re: Grant permissions problems - help
I forgot to mentioned that this
'@'%' |
+---
--+
IS the same on both my W2K and my Mac OS X
Nestor :-)
Nestor A. Florez
Victor Pendleton [EMAIL PROTECTED] 11/13/2003 11:01:37 AM
execute show grants for nestor@'%' and see what that user has.
-Original Message-
I forgot to mentioned that this same code works on the same database
mysqldump -uname -ppassword -BDatabase | mysql -uname -ppasswrod -Ddatabase
-hremotehost
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:54 PM
To: [EMAIL PROTECTED]
Subject: Backup question.
I would like to backup databases from a
Create the column as a timestamp and the column will be updated on insert
and update.
-Original Message-
From: Mikel - [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: table creation
Hello list:
Is it possible to create a table with a
You should determine where your bottlenecks are first. Are the updates on
columns with keys? Can you disable the keys during the load? Are you using
extended inserts? Is there available memory? What is the cpu doing? etc...
-Original Message-
From: karthikeyan [mailto:[EMAIL PROTECTED]
have you verified that the number of columns match? That the data types are
matching as well?
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:01 PM
To: [EMAIL PROTECTED]
Subject: LOAD DATA ?
Hello,
My Load data command seems not to load data
Are the é being replaced by another character?
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:05 AM
To: 1Mysql
Subject: Loosing é characters in DB insertion
Hello,
I just took over a site from a client, he used an Access DB, the
Is anything being logged in the error log?
-Original Message-
From: Eric Anderson [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:16 AM
To: [EMAIL PROTECTED]
Subject: Very strange problem
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14). These
What operating system does the MySQL server reside? The ASCII representation
for é is 233. Is this the same value for the host machine?
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:27 AM
To: Victor Pendleton; 1Mysql
Subject: RE
]
Sent: Friday, November 07, 2003 11:44 AM
To: Victor Pendleton; 1Mysql
Subject: RE: Loosing é characters in DB insertion
Red Hat 9.
Looking at the data through Webmin, it appears as though the text is correct
in the DB in certain fields, in some others, there are strange characters...
I think
query your use table and see if the anonymous user is still present. You
will need to delete this account and flush privileges.
-Original Message-
From: Steven Lefevre [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:33 AM
To: [EMAIL PROTECTED]
Subject: Stupid permission
Error 143 suggests that you have conflicting table definitions.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 7:08 AM
To: [EMAIL PROTECTED]
Subject: MERGE tables error
I've created several merge tables from the command prompt. All
Have you tried datanamic.com?
-Original Message-
From: Jeff Weeks [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 1:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: How to get a nice schema diagram
Looking for an open source or commercial tool to help with database
301 - 400 of 459 matches
Mail list logo