I think you are using .ini files present in the source directory .
Can you copy the .ini file to your datadir ( eg : my-innodb-heavy-4G.ini conf
file for 4GB RAM ) and pt out the same at startup ?
Not sure whether iam in the right path .. Correct me if iam wrong
--Praj
On Mon, 24 Apr 2006
Check where u resolve . that could help you
I guess this DNS problem ,correct me if iam wrong .
--Praj
On Thu, 20 Apr 2006 18:43:39 +0200
Kai Schmidt [EMAIL PROTECTED] wrote:
Hi @all
i have a Problem with Login into a MySQL 5 Server. When i try to login from a
remote Machine into the
Hi
Restart mysqld with the --skip-grant-tables option
More info : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
--Praj
On Mon, 10 Apr 2006 12:57:32 +0600
Kosala Atapattu [EMAIL PROTECTED] wrote:
Hi people,
I have a small problem. I forgot the password for user root in
Hi
Can you through us more lights on error ? where does this occur ?
-bash-2.05b$ perror 10 30
OS error code 10: No child processes
OS error code 30: Read-only file system
-bash-2.05b$
-Praj
On Wed, 5 Apr 2006 08:48:08 +0700
Truong Tan Son [EMAIL PROTECTED] wrote:
[S] Dhandapani wrote:
2006 14:02:06 +0700
Truong Tan Son [EMAIL PROTECTED] wrote:
Prasanna Raj [EMAIL PROTECTED] wrote:
Can you through us more lights on error ? where does this occur ?
**ERROR:
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB
Hi All
Correct me if iam wrong
You might have run the create table syntax from hrdb database .So it gives you
the create table also when you do mysqlbinlog .
CREATE TABLE intra.table1 AS SELECT * FROM NO DATABASE NAMEtable2 , which
means you are under hrdb database.
Else you can use below
On Wed, 2006-04-05 at 09:02, Prasanna Raj wrote:
Hi All
Correct me if iam wrong
You might have run the create table syntax from hrdb database .So it gives
you the create table also when you do mysqlbinlog .
CREATE TABLE intra.table1 AS SELECT * FROM NO DATABASE NAMEtable2
Try creating INDEX on id column
I think that will do the trick ;)
--Praj
On Mon, 3 Apr 2006 19:07:34 -0600
Ariel Sánchez Mora [EMAIL PROTECTED] wrote:
This table holds latest data from an app:
mysql select * from ultimas_respuestas_snmp limit 10;
Subquries will help you .
--Praj
On Thu, 30 Mar 2006 21:11:56 -0500
Rich [EMAIL PROTECTED] wrote:
Hi there. Any quick way of killing duplicate records?
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Is tat query is the problem ?
Then turn on your slow queies and try optimizing those slow queries ?
Post your queries and table description for further help :)
--Praj
On Wed, 29 Mar 2006 12:33:20 -0500
Jacob, Raymond A Jr [EMAIL PROTECTED] wrote:
After a 23days of running mysql, I have
Try Using Select into outfile
More Info : http://dev.mysql.com/doc/refman/5.0/en/select.html
--Praj
On Wed, 22 Mar 2006 12:59:44 +0530
Mohammed Abdul Azeem [EMAIL PROTECTED] wrote:
Hi,
Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
is there any other tool which
I guess u had 2.5 million records splited into 1600 tables if iam not wrong :)
Why you split the tables to 1600 is there any specific count ?
Why you moved to merge table reason behind ?
Since 2.5 million records to 1600 is a huge count on nos of tables :( instead
of one ;)
--Praj
On
Hi
Iam not sure about the answer correct me if iam wrong :(
Dont use single quotes in count_of_logons ..
Try : $sql = UPDATE members
SET count_of_logons = count_of_logons + 1
WHERE logon_id = '$logonid'
AND logon_pw= '$logonpw'
AND
Hi Tom,
Use -q option on mysqldump ;)
-q Won't buffer query, It will dump directly to stdout.
--Praj
On Tue, 14 Mar 2006 11:56:42 +
Tom Brown [EMAIL PROTECTED] wrote:
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the
I guess you are Not selecting the database .. any error msg ?
eg : mysql_select_db( '' ) or die( 'Could not select database' );
--Praj
On Wed, 8 Mar 2006 07:45:20 -0300
Kleiton L R Soares [EMAIL PROTECTED] wrote:
Please, i'm a crazy ! i dont can write in a table, please anybody can help me
Hi
Simple way is show table status; there is a column Type : value MRG_MyISAM is
the base table.
--Praj
On Tue, 7 Mar 2006 14:02:44 +0100
Martijn Tonies [EMAIL PROTECTED] wrote:
Hi there,
How do you know what the sources are for a MERGE
table?
SHOW TABLE STATUS doesn't show it, as
Oh yeah got it u meant UNION clause .
Still i have no idea about that i usally see it in show create tables
statements .
Sorry :(
--Praj
On Tue, 7 Mar 2006 15:10:51 +0100
Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
Simple way is show table status; there is a column Type : value
Yes ..u can use older version as master and 5.0 version as slave
http://dev.mysql.com/doc/refman/5.1/en/replication-compatibility.html
http://linux.com.hk/penguin/developer/mysql/manual_Replication.html#Replication_Compatibility
Ciao
Praj
On Fri, 3 Mar 2006 12:32:24 +0200
Octavian Rasnita
18 matches
Mail list logo