\\session\\sess_v1ssm27k1hc7
f8ffp23fh2k4l4, O_RDWR) failed: No such file or directory (2) in Unknown on
line 0, referer: http://localhost/pma/
[Fri Aug 17 10:38:59 2007] [error] [client 0.0.0.0] PHP Warning: Unknown:
Failed to write session data (files). Please verify that the current setting
Hi,
What does exactly happens when the AUTOINC lock is
happening ?
Why is it not a problem on our amd (quadcore) machine
with the data sitting on a raid10 partition, we have
never seen this problem before, its apparently
happening so fast that it doesn't matter.
With the intel machine
that problem be fixed and still using MySQL
5.0.32 ?
Could you please help ?
Thanks in advance for your help,
Mariella
Please find below a snapshot of show innodb status
\G
INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 15
seconds
Hi all,
I believe to have found a bug in MySQL's union implementation. Can someone
confirm this, please or convince me that this is not a buggy behaviour of
mysql :
UNION seems to behave like DISTINCT by default:
mysql select 2 c1
- union
- select 1 c1
- union
- select 2 c1
is
specified then.
Cheers
/Karlsson
list account wrote:
Hi all,
I believe to have found a bug in MySQL's union implementation. Can
someone
confirm this, please or convince me that this is not a buggy behaviour of
mysql :
UNION seems to behave like DISTINCT by default:
mysql select 2 c1
- union
implementation?! Confimation or Explaination
please
Hi all,
I believe to have found a bug in MySQL's union implementation. Can someone
confirm this, please or convince me that this is not a buggy behaviour of
mysql :
UNION seems to behave like DISTINCT by default:
mysql select 2 c1
- union
- select
On Wednesday 11 July 2007 00:34, Anders Karlsson wrote:
UNION will only return distinct rows. This is according to spec and to
the SQL Standard.
And of course, to no one's surprise, this also matches the mathematical
definition of union:
j
--
Joshua Kugler
Lead
This should work
DELETE Item FROM Item,ItemTag WHERE Item.ProductID =ItemTag.ItemID AND
ItemTag.TagID = '168'
Mark Kelly wrote:
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
Hi.
On Thursday 05 July 2007 17:35, you wrote:
I want to delete from the 'Item' table
all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can anyone help?
Thanks
Mark
--
I want to delete from the 'Item' table
all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
The following query should work if I understand what you're attempting
correctly. Use at your own risk though ;)
DELETE FROM Item USING Item, ItemTag WHERE ItemTag.ItemID =
Item.ProductID AND ItemTag.TagID = '168';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
dear sir or madam,
please i need the following files in order to enable arabic display of data
stored in MySQL database, v4.0.12-nt:
cp1256_bin
cp1256_general_ci
where can i find them ?
Regards
Hiam
_
Windows Live Hotmail
As Dan mentioned, you're searching on the 'tag' field which has no
index. But since that field is in the table you're joining on, adding
an index on it might not help. You actually searching on the tag_id
in the join field, not the 'tag'.
Add an index on 'object_type' in the
Yes I already did try adding an index on tag, but as you said it didn't work
as its using the primary key from the freetags table for the join , anyway I
will try adding an index on object_type, and see if that helps ...
Thanks
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/20/07, Brent
Thanks a bunch for the suggested workaround. This method was exactly
what I was looking for.
Thanks again.
CL
At 01:33 AM 6/20/2007, Ananda Kumar wrote:
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 binlog_sql.sql.
This will give you all the
-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 20, 2007 10:23 AM
To: Brent Baisley
Cc: mysql@lists.mysql.com
Subject: Re: Slow query examining 10 Million Rows, please help !!!
Yes I already did try adding an index on tag, but as you said it didn't
work as its using the primary
Guys,
I'm attempting to reapply a number of bin-log files in a effort to
restore all changes that was made to a database. I'm performing the
following command, but continue to get a foreign key constraint error
message when doing so. Has anyone ever ran into this issue, and if
so, what is a
Hi everybody,
we have this super slow query which is going through more
than 10 million rows to retrieve results, here is the query and other
information, I tried a few things to make this faster , but failed , so any
help from you guys in making this faster is greatly
I would try adding an index on the freetags.tag column as you are querying
against that column with
WHERE tag = 'shot'
HTH,
Dan
On 6/19/07, Kishore Jalleda [EMAIL PROTECTED] wrote:
Hi everybody,
we have this super slow query which is going through
more
than 10 million
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 binlog_sql.sql.
This will give you all the data present in oca-bin.000554. Then you can set
the
foreign key check to 0 at the session level and then apply the
binlog_sql.sql.
Comment our everything
amount depending on what its sorted by!! For example, if I sort it by 'url'
it seems to generate 569 elements!
Can anyone please spot the undoubtedly obvious error I've made here?! I've
been scratching my head for days, to no avail!
Many thanks in advance,
Ben Benson
above, it
simply refuses to put more than 14 elements in the array.
Then, to confuse it even more, if I sort the query, it gives a different
amount depending on what its sorted by!! For example, if I sort it by
'url'
it seems to generate 569 elements!
Can anyone please spot the undoubtedly
We recently switched to mysql5 and while we were at it we also changed
our logs from text to bin as suggested by the migration script we had
(probably created by debian people).
Now I unfortunately had to reconstruct what had happened during a faulty
run of our application and I could not get
Fionn Behrens wrote:
We recently switched to mysql5 and while we were at it we also changed
our logs from text to bin as suggested by the migration script we had
(probably created by debian people).
Now I unfortunately had to reconstruct what had happened during a faulty
run of our application
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote:
You can have both, AFAIK. The general query log keeps all queries,
including SELECTs. Binlog only has data-modifying queries.
Thanks very much for your answer.
Maybe the fact that binlogs apparently are quite different from normal
text
Fionn Behrens wrote:
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote:
You can have both, AFAIK. The general query log keeps all queries,
including SELECTs. Binlog only has data-modifying queries.
Thanks very much for your answer.
Maybe the fact that binlogs apparently are quite
Hi,
I'd really appreciate help with reading this db deadlock notice.
Essentially, I'd like to understand:
-what holds the lock that TX2 is waiting on index `token` of table
`eviltwin/user_sessions`? I thought it'd be TX1 (hence deadlock ?), yet
it appears that TX1 holds no locks
-if the
Nikita Tovstoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Do both of your SELECT statements use the same index (`token`) when setting
locks on the rows? My guess is that the situation is as follows.
TX2: SELECT ... WHERE id = ... FOR UPDATE
TX2 sets an exclusive lock for a row
Dear List,
As recently as last Sunday January 14, 2007, we have enabled
replication between two servers in our organization.
The master server runs MySQL 4.1.10a, the slave runs 5.0.18.
Since then, we have had a number of interruptions in replication when
the slave server stopped replicating
VeeJay wrote:
How and at What place, can I configure the Makefile under
/usr/ports/databases/mysql50-server/
to have MySQL server working with above mentioned configurations?
Why not just use MySQL that comes from ports?
If you really want to build from source, read:
Hello there
I was wondering if someone having great knowledge of FreeBSD chroot system
could give me some help. I trying to run MySQL and Apache under a chroot
envoirnment. But I am getting these errors. Could you please help me to
solve these problems. I have googled a lot but did't find any
On Sun, Jan 07, 2007 at 12:50:34PM +0100, VeeJay wrote:
I trying to run MySQL and Apache under a chroot envoirnment. But I am
getting these errors.
[ ... ]
# /usr/local/mysql/libexec/mysqld: Can't create/write to file
'/var/tmp/ibPM3e0d' (Errcode: 13)
[ ... ]
fopen: Operation not
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags=-all-static
I've developed several job tracking applications here at my job.
One of them relies heavily on a series of date stamps in the main table.
Each job has about 6 milestones, each with a respective sibling
column in the same table. The first sibling reflects the job's
predicted date milestone and
Dear List,
Could I get an explanation why 1 fails, but 2 works.
1.
Update statement preceded with explain, fails:
explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES
t on c.ticker = t.TickerSymbol and t.InterimEndingDate =
replace(left(c.date_qtr,7),'-','/') set
At 14:31 -0500 11/29/06, Mikhail Berman wrote:
Dear List,
Could I get an explanation why 1 fails, but 2 works.
Because EXPLAIN is used only with SELECT statements.
Try to use a similar SELECT.
1.
Update statement preceded with explain, fails:
explain update COMPANY_NUMBERS_tmp_Mikhail c
On Wed, 2006-11-29 at 14:31 -0500, Mikhail Berman wrote:
Dear List,
Could I get an explanation why 1 fails, but 2 works.
1. Update statement preceded with explain, fails:
explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES
t on c.ticker = t.TickerSymbol and
Thank you, Sir.
So, there is no way to plan update query?
Regards,
Mikhail Berman
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 2:37 PM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: Re: Any explanation for this, please
At 14
: Wednesday, November 29, 2006 2:37 PM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: Re: Any explanation for this, please
At 14:31 -0500 11/29/06, Mikhail Berman wrote:
Dear List,
Could I get an explanation why 1 fails, but 2 works.
Because EXPLAIN is used only with SELECT statements.
Try to use
Thank you
Mikhail Berman
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 3:30 PM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: RE: Any explanation for this, please
At 14:41 -0500 11/29/06, Mikhail Berman wrote:
Thank you, Sir
All,
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe
and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
I want to use PHP as sever side scripting.
Cheers,
Renish.
--
MySQL General Mailing List
For list archives:
On Wednesday 15 November 2006 18:14, Renish wrote:
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
Please read the documentation before asking questions such as these. Thanks.
http
@lists.mysql.com
Subject: Urgent please..
All,
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe
and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
I want to use PHP as sever side scripting.
Cheers,
Renish.
--
MySQL General Mailing List
Subject: Re: Urgent please..
On Wednesday 15 November 2006 18:14, Renish wrote:
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
Please read the documentation before asking questions
Subject: Re: Urgent please..
Ocourse i read the manual . I was unable to do so..ie the reason I
asked...I
also knew this location mysql@lists.mysql.com
- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Renish [EMAIL PROTECTED]
Sent: Thursday
Thank you very much..excellent support
- Original Message -
From: Logan, David (SST - Adelaide) [EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com; Joshua J. Kugler [EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 12:16 PM
Subject: RE: Urgent please..
Hi
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
my firewall is off and I know it is not the port becuase when I configure it
as 'anonymous it works like a charm. Please help me
I am not able to install Mysql on my 2003 server at home.
error 1045!!
I get an accesd denied for user [EMAIL PROTECTED]
I need the full error, but have some questions:
1. Are you sure that you set a root password?
2. Are you using the command line client or some other administrative tool?
)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
Please send me solution immediately. Then I will try MySQL with these tools
in Network architecture
)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
Please send me solution immediately. Then I will try MySQL
On 7/10/06, Kishore Kumar Barik [EMAIL PROTECTED] wrote:
snip
Please send me solution immediately.
anything else, your highness?
--
-jp
Chuck Norris got in touch with his feminine side, and promptly got her
pregnant.
(Unknown Source)
Please send me solution immediately.
I'll try not to be as sarcastic as others, but I REALLY hope this
sentence is a result of you not speaking your native language! We are
volunteers, not employees. You'll be able to solve this better than
any of us, the problem
Hi,
I have the following Query and Im a lil lost on this one
SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date,
tbe_orders.order_piececount
FROM tbe_orders
The query produces the following results:
+++
+ order_id + order_date +
At 18:51 9.7.2006, you wrote:
Hi,
I have the following Query and Im a lil lost on this one
SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date,
tbe_orders.order_piececount
FROM tbe_orders
SELECT tbe_orders.order_id,
tbe_orders.order_date, sum(tbe_orders.order_piececount)
FROM
m i l e s wrote:
Hi,
I have the following Query and Im a lil lost on this one
SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date,
tbe_orders.order_piececount
FROM tbe_orders
The query produces the following results:
+++
+ order_id +
@lists.mysql.com
Sent: Tuesday, June 27, 2006 5:15 PM
Subject: Re: Please Help - Stored Procedure Issue
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
@cInvNo
replace all instances of this with just cInvNo. cInvNo is already
declared as
an OUT variable, and @cInvNo will be set to that value
This is a text part of the message.
It is shown for the users of old-style e-mail clients
I have the following stored procedure that I'm using:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo VarChar(7))
BEGIN
Declare cPrefix VarChar(1);
Declare cNextInv VarChar(7);
Set cInvNo = '';
IF nChapterID 0 THEN
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
@cInvNo
replace all instances of this with just cInvNo. cInvNo is already declared as
an OUT variable, and @cInvNo will be set to that value when you run:
CALL sp_GetNextInv(-1,@cInvNo);
--
Chris White
PHP Programmer/DBBD
Interfuel
--
MySQL
have the same identifier as the tables. I don't
know if it is possible to have views and tables the same identifier. I didn't
create these views.
Can someone please help me figure this out?
Thanks
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
And would you like to tell me the difference among these editions?
Thanks very much!
[image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz
On 6/2/06, yuan edit [EMAIL PROTECTED] wrote:
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
You notices most of those files are .asc and .md5 used to verify the
integrity of the archive after
, 2006 12:25:50 PM CDT
To: Joseph Alotta [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: please help optimize this query
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize
Greetings,
I generate this report of all the holdings by symbol, summing up over
accounts. It is taking much too long. I was wondering if I can add
an index on something to make it more efficient. The first query
gets the most recent date, the next query sums it up by symbol.
Thank
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize the data so that you have a table
for symbols that is linked to this table via an integer based foreign
key.
Also it seems wierd
and could not find any.
Please help.
Thank you,
Zee
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
?php ?
Project1 2300 1600
250
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
?php ?
Project1 2300 1600
250
Hi, Brian!
First of all I think next time you should better attach your database
structure. It'll be much easier to understand your problem if you will...
Maybe you're asking for something like this:
SELECT project_name, elecremain, controlremain, otherremain, elecremain
+ controlremain +
Brian,
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
Projectname Elecremain Controlremain
otherremain ?php ?
Project1 2300 1600
Please answer to list next time.
Good. Now, what is your Elecremain, Controlremain, otherremain?
How should they be calculated...
P.S.: Why don't you give a try to some numerical data types? ;) To use
varchar everythere isn't a right way I think.
Brian E Boothe wrote:
my database
Brian E Boothe wrote:
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
As Eugene said, VARCHAR values don't sum, since they are not numeric.
Either cast the column values you wish sums of to a
.
Do you really want to drop the 'billmax' database [y/N] y
Database billmax dropped
But it does not do anything.
I have tried restarting the DB and restarting the box as well
Please help
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
:22 AM
Subject: please help, can not delete database
Hello,
Not sure what is going on
i have mysql Ver 12.22 Distrib 4.0.17,
I have a database that i can not delete.
i do this
#mysqladmin drop billmax -u admin --password
Enter password:
Dropping the database is potentially a very bad thing
-
From: Randy Paries [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Sent: Saturday, April 22, 2006 11:04 AM
Subject: Re: please help, can not delete database
when i go back and try to create it , it says it already exisit?
Randy
On 4/22/06, Rhino [EMAIL PROTECTED] wrote:
What makes you think
in the database will be destroyed.
Do you really want to drop the 'billmax' database [y/N] y
Database billmax dropped
But it does not do anything.
I have tried restarting the DB and restarting the box as well
Please help
Randy
Remember that MySQL uses directories to implement databases. When you
drop
can someone post a snippit on Summing tables together of a feild of the
entire Database ? why does everyone Have such a problem with this
question? everyone i ask says the same thing,, let me show what i'm
needing by Visual representation
MySQL databaseworkorders
Brian,
can someone post
a snippit
on Summing tables together of a feild of the
entire Database ?
Do you mean summing
all row
values of a column in a table, grouped by the value of another column?
If so, for example to
retrieve all electprojcost, electprojbilling values and their
differences
Hi all,
My Windows-based database server crashed (no fault of MySQL. probably OS
or hardware), and I managed to copy out the data files. I am using
version 5.0 of the Essentials package.
I tried to install a similar setup on another server, then copy the
data\ folder over. The MySQL service
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
not sure, but it may be worth trying the following
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
Hi all,
My Windows-based database server crashed (no fault of MySQL.
Thanks for coming to the rescue, Mark and Bruce.
Mark Leith wrote:
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset
: Monday, February 27, 2006 6:06 PM
To: Philip Hallstrom
Cc: mysql@lists.mysql.com
Subject: [SPAM] - Re: MYSQL: Unlimited Forums, Scalablity Issues, advice
please? - Bayesian Filter detected spam
Hi Philip, thanks for the reply.
Single master + many read only slaves would only solve the problem
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS
of subforums that simulate full forums would do.
2. Also regarding scalablity, I hope to Add capacity as and when its
needed. So i'll have one server running
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS of
subforums that simulate full forums would do.
2. Also regarding scalablity, I hope to Add capacity as and when its
needed. So i'll have one server running
Hi Philip, thanks for the reply.
Single master + many read only slaves would only solve the problem of
handling many many concurrent read accesses, by distributing the load
across all slaves.
However, I guess the real problem, is that the writes would still need
to be performed across ALL
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
If you feel that there are too much sockets in a TIME_WAIT have a look here:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Logg, Connie A. wrote:
Two days ago, a system that has been running
Two days ago, a system that has been running fine started crashing...It could
be for a variety of reasons which I am researchinig. However (running mysql
5.0.18) I notice the following from netstat:
tcp0 0 iepm-bw.slac.stanford.:1000 iepm-bw.slac.stanford:38672
ESTABLISHED
tcp
No I don't think this indicates orphaned sockets, having many sockets for
mysql in the state TIME_WAIT state is quite normal, as a socket has to be
created for every connection and once a connection is established the socket
goes into a TIME_WAIT state( i am not sure for how long though), the
e2undel and debugfs and certain versions of
mc.
Please let us know, if you need help with these tools.
Good luck!
--
Johannes Franken
MySQL Certified Professional
mailto:[EMAIL PROTECTED]
http://www.jfranken.de/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I made a major mistake with MySQL 4.1.x. While using Navicatt I
dropped my database when I meant to drop a table. Other than backups
which are not that up to date, is there an undo?
Help here is greatly appreciated.
Thanks, I'm desperate.
Rick
--
MySQL General Mailing List
For list
Hello.
If you database contained MyISAM tables, you should prevent any access
to the partition (or logical disk in Windows) and recover deleted files
(*.MYI, *.MYD, *.frm). I'm not sure what to do with InnoDB tablespace
(not per-file), but certainly you should shutdown MySQL and copy ibdata
: PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the source command within the MySQL
CLI?
mysql -uroot -pmypass
(login welcome)
mysql CREATE DATABASE IF NOT EXISTS bcm;
mysql USE
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt (essentials version)
Windows xp
The DB contains tables, vw's and sp's.
It is a
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:07 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate
Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
Thanks again,
I will try this and read the manual again.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's
101 - 200 of 1426 matches
Mail list logo
