Hi All,
Is it possible to restore the database from an XML file (
generated from mysqldump -X)?
Please provide me the syntax. (mysql database < xmlbackupfile is not
working ).
But restore is working fine with the normal backup file.
Please throw some light on it.
Thanks i
Hi
I set the wait_timeout in my.cnf.
Sometimes it works well and there is no idle process 120 seconds time.
But sometimes there are idle processes with 1900s time.
What the reason can be?
On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
Hi
According to the VARIABLE "wait_timeout" [de
In the last episode (Nov 07), Michael Fischer said:
> Given:
>
> * A table TABLE_DESC, which is rather like a system table,
> in that it contains the names and column_names of other tables.
>
> * A table MY_TABLE, which contains "ordinary" data, and has a set
> of rows in TABLE_DESC.
>
> What I
I suspect, from experimentation, that substr() is not binary safe,
in that if some part of the field contains an all-bits-zero byte,
it will "stop short".
What I wish to do is to pick out byte ranges of arbitrary length,
at an arbitary offset into a BINARY(N) column.
Perhaps LEFT() and RIGHT() m
Ok, here's one. Either its impossible, or someone might
be able to point me to the light.
Given:
* A table TABLE_DESC, which is rather like a system table,
in that it contains the names and column_names of other tables.
* A table MY_TABLE, which contains "ordinary" data, and has a set
of rows i
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, there is a very good
reason for doing this, and not using an auto increment integer.
Michael
--
Michael Fischer Happiness is
>On 11/7/06, Eric Lommatsch <[EMAIL PROTECTED]> wrote:
>>I have accidently droped a table from one of my database's. The table was
>>an innodb table. Is there anyway that I can recover the table or is that
>>information gone for good if I don't have a current backup of that table?
At 11:09 PM 11/
Eric, as far as SQL is concerned, there is no way to recover dropped tables
and, to my knowledge, there is no MYSQL-specific way to do that either, so,
your only hope is to have a rather fresh backup of your database.
BTW, this gives me an idea: I suppose that dropping a database table is a
two-t
There is only ONE SLIM HOPE.
Is your binary logging enabled ???
If yes, how far back ??
You could theoretically recreate the table from the binary logs
up to the moment just before you accidentally dropped the table
if the binary logs contain the moment you first created the table
along with all
Only if you had enabled the "log" or "bin-log" options, and the log's
history contains the information you need (depending on the log's
creation date).
Carlos
On 11/7/06, Eric Lommatsch <[EMAIL PROTECTED]> wrote:
Hello,
I have accidently droped a table from one of my database's. The table was
Hello,
I have accidently droped a table from one of my database's. The table was an
innodb table. Is there anyway that I can recover the table or is that
information gone for good if I don't have a current backup of that table?
Thank you
Eric H. Lommatsch
Programmer
MICRONix, Inc.
2087 South
> > At any rate, does anyone know what I could use instead, as
> > semi-graphical interface, on Apache? (FreeBSD). I'm ready to
> > do away with phpMyAdmin.
> >
> > Thanks,
> >
> > - Mark
> Just a couple of hours ago Vittorio Zuccalà suggested dadabik -
> http://www.dadabik.org/ - which looks pre
Mark wrote:
Hello,
Ever since I upgraded to MySQL 5.0.x, phpMyAdmin has appeared to be buggy
as hell (and yes, of course, I updated the client API in PHP). I guess it
really was more of a MyQL 4.0 thingy.
At any rate, does anyone know what I could use instead, as semi-graphical
interface, on Ap
Hello,
Ever since I upgraded to MySQL 5.0.x, phpMyAdmin has appeared to be buggy
as hell (and yes, of course, I updated the client API in PHP). I guess it
really was more of a MyQL 4.0 thingy.
At any rate, does anyone know what I could use instead, as semi-graphical
interface, on Apache? (FreeBSD
We have been using older versions of mysql without any problem (5.0.19)
I updated our test server to 5.0.27
senario is.. temp table performs data conversion, master table is never
deleted/updated, only new records insert, insert takes 30-40 minutes for
bulk loads
under old mysql versions we
Vittorio Zuccalà wrote:
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication mode
it will ask the us
Vittorio Zuccalà ha scritto:
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Uff...
I didn't remember...
If it is not enought you can use Dadabik (www.dadabik.org)
It is great: do not be impressed from its simple interface. It is very
completed softw
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Hello,
i am looking for a simple Web interface,
for normal users (non admin), that will only have access to their Database,
and have the possibility to manage their tables (create,delete,insert,...).
for root access, i already have phpMyAdmin installed on the server.
--
MySQL General Mailing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 7 Nov 2006, at 12:35, Jochem van Dieten wrote:
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
interleavi
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
interleaving, join and suspend/resume it supports XA. I think that puts it
about on par with Ingres and Firebi
Hi
According to the VARIABLE "wait_timeout" [default: 28800 seconds] a running
MySQL daemon clears up idle connections if their
"idle period" > "wait_timeout".so the sleeping threads will be
automatically cleared if the time exceeds 'wait_timeout' variable value.
'wait_timeout' variable :
We've added a new appendix to the MySQL Reference Manual:
- Frequently Asked Questions About MySQL 5.1
(http://dev.mysql.com/doc/refman/5.1/en/faqs.html)
- Frequently Asked Questions About MySQL 5.0
(http://dev.mysql.com/doc/refman/5.0/en/faqs.html)
The FAQ answers frequently asked questions
Thanks again
I have some questions that may help me explain my problem well.
1- What's this mean:
mysql> SHOW PROCESSLIS;
+--+---+--++---+-++-+
| Id | User | Host |db | Command | Time | State |
I
Hi
Try command line option, like
mysql >set @@session.wait_timeout=15;
mysql> show variables;
Thanks
Visolve DB Team.
- Original Message -
From: "Sayed Hadi Rastgou Haghi" <[EMAIL PROTECTED]>
To: "Visolve DB Team" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 07, 2006 3:21 PM
Subj
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
> Thanks
> But this sets. GLOBAL wait_timeout variable.
> Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
Ah, yes, MySQL is very confusing about this special variable:
You have to use "interactive_timeout = XXX" to change what is called
"
Thanks
But this sets. GLOBAL wait_timeout variable.
Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify it at the command line : set wait_timeout=x
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify it at the command line : set wait_timeout=x
or start mysqld with --wait_timeout=x along with other options.
Thanks
ViSolve DB Team
- Original Message -
From: "Sayed Hadi Rastgou Haghi" <[EMAIL PROTECTED]
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
> Dear All,
>
> I want to set wait_timeout variable on mysqld startup.
> Is there any way to do that?
Put "wait_timeout = XXX" into the "[mysqld]" stanza of your
/etc/mysql/my.cnf (or wherever your global config file is).
bye,
-christian-
--
MyS
Dear All,
I want to set wait_timeout variable on mysqld startup.
Is there any way to do that?
--
Sincerely,
Hadi Rastgou
A Google Account is the key that unlocks the world of Google.
http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";> Get
FireFox!
30 matches
Mail list logo
