date:20041124

Re: difference command

2004-11-24 Thread James Weisensee

 Do you know what is differnet between command
 mysql_connect and
 mysql_pconnect
 
 Thankx
 

This is a PHP question.  This should've been the first
place you looked:
http://us2.php.net/manual/en/index.php


mysql_connect
http://us2.php.net/manual/en/function.mysql-connect.php

mysql_pconnect
http://us2.php.net/manual/en/function.mysql-pconnect.php


HTH,
James





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lost Connection To Mysql....................................Roime

2004-11-24 Thread roime puniran


i have mysql server located in in machine that used Red Hat 8.0
and my mysql server version was 3.23.58. I am trying to connect
using my machine..And currently i used Red Hat Fedora...But when
i am trying to connect to mysql server i got this error
message.

ERROR 2013: Lost connection to MySQL server during query

And i am also trying to killall my mysqld and start the mysql
server through mysql kernel

/usr/libexec/mysql -Sg --user=root

After that, when i tried to reconnect it, it's hang up
!.nothing to be done and i need to start my machine back to
run mysql...

Can anyone help me?...Do u guys have any idea?...

Thanks !
-
Free POP3 Email from www.Gawab.com 
Sign up NOW and get your account @gawab.com!!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Data loss problem with mysql

2004-11-24 Thread ravi.ramachandra


Andy,

Thanks a lot for the response.  We are using Linux OS.   Is there any
configuration parameter that enables more frequent flush or a parameter
that enables direct write to disk and any idea about performance
implications.

Thanks once again,
Ravi


-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 1:28 PM
To: Ravi T Ramachandra (WT01 - EMBEDDED  PRODUCT ENGINEERING SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: Data loss problem with mysql


On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote:


 Dear all,

 We are running mysql 4.0.17 on linux environment.  Our database
resides
 on external disk connected via FC cables.   We recently noticed a loss
 of data in the following scenario.

 Inserted a row in a table in a separate transaction by a java
 application, queried a row in the table in a separate transaction by a

 java application and was successful.
 Then the FC cable connecting to external db disks was pulled and after
 sometime put it back
 Now the inserted row is missing in the database.

 From our logs, we have a query log that shows the inserted statement
 prior to FC cable disconnection.  After cable pull, we have taken
 database dump that reveals the missing row that was inserted prior to
 FC cable disconnection.

 If somebody would have accidentally deleted, then we can expect the
 delete statement in the query log.  But there is no delete statement
 in the query log.

 Can anybody help.

What operating system(s) are you using for the system you are making the
query from and also for the external database server?

mysqld makes as much use of database server system memory as possible
and a lot the live database will be cached in memory. If you insert a
row and then read it back, it will be in the table but the table is in
memory and hasn't necessarily been written to physical disk. Also, UNIX
and Unix-like systems normally work with disk buffers so that when a
file is written to, it is the disk buffer that is written to, not the
physical disk itself. The disk buffers are then flushed out to disk
every 30 seconds.

It could be that the FC cable was unplugged during the buffer flush,
causing the operating system to abort the flush and not update the file
on the physical disk.

Andy




Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or 
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL 
PROTECTED] immediately
and destroy all copies of this message and any attachments.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: order by question

2004-11-24 Thread Harald Fuchs

In article [EMAIL PROTECTED],
dan orlic [EMAIL PROTECTED] writes:

 i have an question about ordering a set of records...
 ab   c d
 -
 1Tax 120001.33
 1Tax 115002.5
 1Tax 110003.25
 1Tax 10 4.5


 But I want the records to return as such:
 ascending by (c) with the zero being the last record:
 like below:

 1Tax 110003.25
 1Tax 115002.5
 1Tax 12000 1.33
 1Tax 10  4.5

 any suggestions?

ORDER BY c = 0, c


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: I need to understand INNO better.

2004-11-24 Thread Heikki Tuuri

Titus, Jeff,
- Original Message - 
From: Jeff Smelser [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 23, 2004 11:24 PM
Subject: Re: I need to understand INNO better.

--nextPart3014813.KeZKZSIgGj
Content-Type: text/plain;
 charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
On Tuesday 23 November 2004 02:12 pm, Titus wrote:
I have converted some tables from MyISAM to INNO
using an ALTER TABLE statement.  It seems to work
fine.  However, when I copy that database to another
directory for purposes of backup, a subsequent 'use'
statement on the backup directory (db) reports that
  Didn't find any fields in table 'tblAssays'
After exploring I get a report that
Can't open file: 'tblAssays.InnoDB' (errno: 1)
the table data is in ibdata files. If you simply cp the .frm file to another 
directory, it does not change the ibdata files. See:
http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html

Can anyone shed any light on this problem?  Many
thanks.
Only two ways to make copies of innodb..  mysqlhotcopy (its not free)
mysqlhotcopy is free, but it works only for MyISAM.
See:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
and=20
mysqldump.. This is assuming your not coping the entire db directory 
tree..

Maybe someone else knows of another.
Jeff
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reset permissions

2004-11-24 Thread Ian Gibbons

On 23 Nov 2004 at 22:36, Tim Trice wrote:

 How can I reset the permissions on my database?  I have no clue when I did
 it (at least several months ago), haven't used it until today but I cannot
 for the life of me figure out how I can create a new user with all
 permissions.  The only user I have does not have grant or create privileges.
 Am I screwed?

Hi,

Take a look at:

How to Reset the Root Password
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

Regards

Ian
-- 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

upgrade from mysql 3.23 to 4.1

2004-11-24 Thread Hristo Chernev

How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
risk and downtime?

Background: Heavy loaded mysql server, only one database but it is huge -
5GB.The database is replicated to another server.Mysql 3.23.58.Linux OS.

Here is the my plan, please correct me if there is a better way or if I am
doing unnecessary actions:

1. Stop the site and mysql servers and backup database.
2. Upgrade mysql versions on the two machines.
3. Compiling apache and php with new mysql 4.1 client lib.
4. Recreate users and rights ( the provided script fix_privilege_table will
not work correctly form 3.23. to 4.1. will it?).
5. Start main mysql server without replication.
6. Rename database to olddb.
7. Create new database named db.
Do one of 8a or 8b:
8a.Dump olddb with mysqldump, then run the result file to fill the new db
(in order to have native 4.1 database ).
8b.Using SQL queries (or phpmyadmin) copy all tables from olddb to new db
(in order to have native 4.1 database ).
9. Assure that all is correct then delete olddb, copy database to the slave
and start mysql servers.
10. Confirm replication is ok, then start the site.

--
Hristo Chernev

Work Travel in USA - Ñòóäåíòñêè áðèãàäè â ÑÀÙ.
Èñêàø ëè äà ñïå÷åëèø $$$? Êàêâî ÷àêàø îùå? Çàïèøè ñå!
Ïîäðîáíîñòè íà àäðåñ: http://www.vega-exchanges.org

62 matches

Mail list logo