Re: Replicating queries to testing server

On Tue, 2006-06-13 at 19:04, Dan Trainor wrote: > Jake Peavy wrote: > > On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > > > wrote: > > > > Hi - > > > > I would like to be able to replicate all queries from a live MySQL > > server, to a testing server at the o

Re: Reset (or Defrag) the AUTO_INCREMENT columns

wolverine my wrote: > Yes, I agree on what you have described. > > However, what should we do when the value is reaching the maximum? To > alter the data type to a bigger one? Yes - convert the data type to a larger one. If you've got a mediumint, for example, you can convert it to an unsigned m

Re: Reset (or Defrag) the AUTO_INCREMENT columns

Yes, I agree on what you have described. However, what should we do when the value is reaching the maximum? To alter the data type to a bigger one? On 6/14/06, Daniel Kasak <[EMAIL PROTECTED]> wrote: wolverine my wrote: > May I know if there is any way we can reset (or defrag?) the values Yo

Re: fixed or dynamic row sizes with point

Hi, RE: > we have a table with many (~0.5 billion) records and a geometry field > which was defined as a simple "point". The `show table status` shows that > the row format is dynamic, however, a simple point in the GIS > representation has a fixed format (see: WKB: 21 bytes: 1 for MSB/LSB, 4 > f

Re: Reset (or Defrag) the AUTO_INCREMENT columns

wolverine my wrote: > May I know if there is any way we can reset (or defrag?) the values You shouldn't do that. It's much easier for you as a database administrator if these values are left up to MySQL. What happens, for example, if you restore from a backup that has rows which you recently del

Reset (or Defrag) the AUTO_INCREMENT columns

Hi! I have the following tables and the data, CREATE TABLE category ( id TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY name VARCHAR(50) NOT NULL ); CREATE TABLE user ( id TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, category TINYINT UNSIGNED REFERENCES ca

Re: Replicating queries to testing server

Jake Peavy wrote: On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world

Re: Replicating queries to testing server

On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. I think that by doing somethin

4 byte utf8 sequences

Any ideas on whether and when MySQL is likely to support 4 byte utf8 sequences? Chris Key

Re: MS access query in mysql

Andrew Zahn wrote: I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when executed in Access and doesn't work at all in MySQL. I believe it has to Last() and with the # symbols around the date. Any insight into this probl

MS access query in mysql

I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when executed in Access and doesn't work at all in MySQL. I believe it has to Last() and with the # symbols around the date. Any insight into this problem would be greatly

Re: Replicating queries to testing server

nigel wood wrote: Dan Trainor wrote: Dan Trainor wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. Hi - So I was th

Re: Windows Compiled Help MySQL Reference Manual -- Error

On 6/7/06, Jake Peavy <[EMAIL PROTECTED]> wrote: On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote: > > At 17:30 -0600 6/7/06, Jake Peavy wrote: > >Hey yall, > > > >I'm unable to open the .chm I just downloaded for 5.1. I get the > following > >error: > > > >Cannot open the file: mk:@MSITStore:C

mluwwmamupnzo

Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - ALERT!!! This e-mail contained one or more infected files. The following attachments were infected and have been repaired: No attachments are in this category. The following infected attachments were dele

Re: How can i decrypt password

Vitaliy Okulov schrieb: Здравствуйте, Paul. Вы писали 13 июня 2006 г., 17:13:52: At 14:09 +0200 6/13/06, Kim Christensen wrote: On 6/13/06, Barry <[EMAIL PROTECTED]> wrote: Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal

Re[2]: How can i decrypt password

Здравствуйте, Paul. Вы писали 13 июня 2006 г., 17:13:52: > At 14:09 +0200 6/13/06, Kim Christensen wrote: >>On 6/13/06, Barry <[EMAIL PROTECTED]> wrote: >>>Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs password Ka

Re: How can i decrypt password

At 14:09 +0200 6/13/06, Kim Christensen wrote: On 6/13/06, Barry <[EMAIL PROTECTED]> wrote: Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal Not possible. It is possible. However, that depends on which version of MySQL you

Does anybody knw the Asterisk app_addon_sql_mysql.c ?

Hello list, First, I apologize for my poor English Second, i don't know if this post will be read by some Mysql expert having some minor expertise on Asterisk (the pbx telephony, but no matter here we are on the Mysql side) I want to modify this script: *app_addon_sql_mysql.c * to travel acros

Re: How can i decrypt password

On 6/13/06, Barry <[EMAIL PROTECTED]> wrote: Kaushal Shriyan schrieb: > Hi > > I have a situation here how can i decrypt the mysql database userrs > password > > Kaushal Not possible. It is possible. However, that depends on which version of MySQL you are using - and which crypt method you are

Re: MySQL crashes constantly and can't get MySQL 5.0.21 to write core-file

On Tue, Jun 13, 2006 at 08:55:59AM +0200, Wouter de Jong wrote: > The symptoms are that MySQL is constantly (eg. within every 30 minutes) > getting signal 11's according to the logfile, and is restarting. Problem finally tracked down and filed bug report. Regards, -- WideXS

Re: How can i decrypt password

Здравствуйте, Kaushal. Вы писали 13 июня 2006 г., 15:36:02: > Hi > I have a situation here how can i decrypt the mysql database userrs password > Kaushal Maybe use Cain & Abel program: Homepage: http://www.oxid.it/cain.html Download for winXP: http://www.oxid.it/downloads/ca_setup.exe -- С

Re: How can i decrypt password

Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal Not possible. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

How can i decrypt password

Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to set host table?

Takanobu Kawabe schrieb: > > Hello, my name is Takanobu Kawabe. > > I use MySQL 4.1.19 server now. > I don't know how to set Host table in mysql database. > > For db table,tables_priv table and so on, can set using GRANT SQL > statement. > > Can I use this statement for setting

Re: insert not working with auto_increment column

On 6/13/06, Rob Desbois <[EMAIL PROTECTED]> wrote: If you are going to specify values for all columns in your insert, you should put NULL as the value for an AUTO_INCREMENT column, e.g. mysql> insert into SalesSupData values (NULL,2,2,'test',140); My preferred way however is to put the column n

re: insert not working with auto_increment column

If you are going to specify values for all columns in your insert, you should put NULL as the value for an AUTO_INCREMENT column, e.g. mysql> insert into SalesSupData values (NULL,2,2,'test',140); My preferred way however is to put the column names and just miss out the auto_increment column:

Re: my-huge.cnf quite outdated (fwd)

Gaspar Bakos schrieb: -- Forwarded message -- Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT) From: Gaspar Bakos To: Barry <[EMAIL PROTECTED]> Subject: Re: my-huge.cnf quite outdated Hello, Barry, RE: Guess we would answer to everyone on the list who wishes to optimize his cnf. I

insert not working with auto_increment column

I have a problem with inserting data into table in Mysql. I have a Auto_increment Column in Table which throws errors when I try to insert into the table. This is table description. mysql> desc SalesSupData; +-+-+--+-+-++ | Field | Type

How to set host table?

Hello, my name is Takanobu Kawabe. I use MySQL 4.1.19 server now. I don't know how to set Host table in mysql database. For db table,tables_priv table and so on, can set using GRANT SQL statement. Can I use this statement for setting Host table? If I can, what SQL statement

Re: SQL naming convention?

wolverine my schrieb: Hi! When writting a SQL scripts, do you follow any standard SQL naming convention? Similar to what described in http://kurafire.net/articles/sql-convention Yes. Most of the time. Depends always on where you work and what conventions were used. Does MySQL provides such

GOOD DAY

Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - ALERT!!! This e-mail contained one or more infected files. The following attachments were infected and have been repaired: No attachments are in this category. The following infected attachments were dele

MySQL crashes constantly and can't get MySQL 5.0.21 to write core-file

Hi, We have major problems with one of our database machines the past few weeks. We've replaced the complete machine about 3 times now, with different memory... no luck. So I doubt it's hardware. It's a SuperMicro SuperServer 6014H-82 ... dual Xeon 3.0, 8GB DDR2-RAM, 4x73GB Maxtor SCSI (RAID10) T