"Ooks Server" <OoksServer (AT) emberts (DOT) com> wrote: It's a known behaviour of MySQL. MySQL removes trailing spaces at the end of VARCHAR and...

Egor Egorov

07-08-2003 09:48 PM
Paul DuBois

Hi I need to know if is there anyway to clone a existing database (structure and data)? If yes, how can I do this? I looking for a SQL...

Boris Villazon

07-08-2003 09:45 PM
Paul DuBois

Not sure where these came from, but in my users I've got a root@localhost and a root@%. Is this redundant, or is there a reason for this? The...

Jim McAtee

07-08-2003 09:32 PM
Roger Davis

------_=_NextPart_001_01C34555.BD820F60 Content-Type: text/plain Hey Folks I'm having a tough time finding any information in the...

DePhillips, Michael P

07-08-2003 09:29 PM
Paul DuBois

I have just installed MySQL++ 1.7.9 using the RPMs from Rpmfind.com. It installed all Ok. The reason why I installed the RPM over the source was...

Peter Moscatt

07-08-2003 09:24 PM
Martin Gainty

I'm kinda new to administering MySQL. I have a remote db that I want to backup to my local MySQL server (windows). I can do a dump of the db from...

GL

07-08-2003 09:18 PM
GL

I've been having a little trouble creating users cross-platform. I have a little script that works just fine on Solaris 8 using this command: eval...

Michael Iatauro

07-08-2003 09:09 PM
Paul DuBois

------=_NextPart_000_050C_01C3455E.1C7D6C50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Yeah,...

Steve Quezadas

07-08-2003 09:06 PM
Paul DuBois

What is the syntax for setting the client to use the compression protocol in my.cnf? I am using some high level components which don't expose...

My Deja

07-08-2003 08:12 PM
My Deja

David Wilson wrote: For starters have you attempted to disable mysql at start up in services.msc? Try this for now. If your system is still bogged...

UID_0

07-08-2003 06:59 PM
UID_0

------=_NextPart_000_03D1_01C3456A.1BA390A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This question...

Ryan R. Tharp

07-08-2003 06:01 PM
Ryan R. Tharp

I have a shopping cart which creates temporary tables in the format of zorder_<phpsessionid>; These tables are used to hold a customers order while...

Jonathan Villa

07-08-2003 03:59 PM
Jonathan Villa

You're using Windows, so I can't make any promises because this is what I'd do under *nix, but when I first set up mySQL if I type: # mysql -h...

Dan Anderson

07-08-2003 03:40 PM
Dan Anderson

Hello, I have a database randomly scattered with 'NULL' values, being a newbie to mysql, I was wondering if there was a single command to replace all...

Rahat

07-08-2003 02:57 PM
Rahat

Greetings... We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS bug. http://www.mysql.com/doc/en/InnoDB_news-4.0.14.html says...

Christian Nelson

07-08-2003 02:51 PM
Christian Nelson

Is it possible to set up replication on a shared mySQL server, i.e. have the replication only concern the databases that I have access to, without...

Stein Rustad

07-08-2003 01:58 PM
Stein Rustad

------=_NextPart_000_0007_01C3458B.F34DAAB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, can...

awarsd

07-08-2003 01:11 PM
William R. Mussatto

It would be great if someone could give me a hint about what I did wrong with the following query, which takes ages and lets mysql toddle around in...

Harald Kirsch

07-08-2003 12:41 PM
Harald Kirsch

Sorry to post the same question again .. last time when I sent I = received a couple of mails with some error messages .. so, not sure if = my...

Subhakar Burri

07-08-2003 12:34 PM
Heikki Tuuri

dear all, what is the problem sql error : 1036 ...table is read only. please help...

HA. Mooduto

07-08-2003 11:40 AM
gerald_clark

Hi. I'm trying to install MySQL. Our system administrator says that MySQL4.0 consumes a lot of resource such as memory, thus he has to reboot every...

lan

07-08-2003 11:32 AM
lan

I've noticed a server running with a higher load recently and I believe I've narrowed it down to mySQL. Taking a look at Cpu/Memory/Mysql Usage...

Evan Barter

07-08-2003 11:19 AM
Evan Barter

------_=_NextPart_001_01C34567.74074F50 Content-Type: text/plain; charset="iso-8859-1" All; Does anyone know of a more secure way than storing the...

Hubbard, Dan

07-08-2003 10:42 AM
Hubbard, Dan

Hi, I just installed MySQL 4.0 on my PC (Win XP Pro). Problem is, I don't know how to start. I used command prompt to run mysql.exe from...

Mike

07-08-2003 10:28 AM
Mike

------=_NextPart_000_004D_01C3456C.66EFEC50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello The following...

Trevor Sather

07-08-2003 10:18 AM
Trevor Sather

I've done a lot of stuff to try to get mySQL to work. I'm running Mac OS 10.2.6 and Apache webserver. First, I installed mySQL. No problems there....

Nick Boudreau

07-08-2003 10:03 AM
Nick Boudreau

--B_3140504535_1583437 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Hello. Thought I=B9d pass this...

Sean Ian Rice

07-08-2003 09:49 AM
Sean Ian Rice

I'm not very good in mySQL but am trying to modify a script. It has to do with a log table. I want to retrieve the last 2 log records (if any) and if...

gsb

07-08-2003 09:32 AM
gsb

"awarsd" <awards (AT) wanadoo (DOT) fr> wrote: Up to 4 billion rows. -- For technical support contracts, goto...

Victoria Reznichenko

07-08-2003 09:07 AM
Victoria Reznichenko

Hi Jeff, We had similar problems caused by replication crossing a firewall with a 5 minute timeout on its access control list. If the replication...

Martin Waite

07-08-2003 09:04 AM
Dominicus Donny

Hi, I'm new to multi-threaded programming and reading the book "Programming with POSIX Threads" and trying to understand concepts and coding. What...

Ganbold

07-08-2003 04:45 AM
Ganbold

Hi, We use MySQL 4.0.13, Redhat 7.3(kernel 2.4.18.3). Apache 1.3.27 Mysql is alive and there are process but I don't see in ps (process table) and...

melih fidan

07-08-2003 04:09 AM
melih fidan

"Pedro X Gomes-Fabre" <pgf18872 (AT) mh (DOT) uk.sbphrd.com> wrote: No. Yes. -- For technical support contracts, goto...

Victoria Reznichenko

07-08-2003 03:50 AM
Victoria Reznichenko

Mark Depenbrock <mark (AT) adventdesigns (DOT) com> wrote: mysqld isn't running. Look in the <host_name>.err file in the MySQL data dir to see error...

Victoria Reznichenko

07-08-2003 03:42 AM
Victoria Reznichenko

How can I benchmark the perfomance of Mysql with the following setup: Perl 5.8.0 (perl-DBI,...

mixo

07-08-2003 03:37 AM
Heikki Tuuri

oh, i found the solution for this, by doing "SELECT * FROM table1 WHERE STRCMP(field1, 0x61006200630064000000)=0" will work as expected, so no need...

Koh Swee Meng

07-07-2003 10:32 PM
Nils Valentin

I think I know the answer to this question, but.. Just to be sure. Can I take multiple 2GB files in /var/lib/innodb and the corresponding files in...

Wendell Dingus

07-07-2003 04:09 PM
Wendell Dingus

------=_NextPart_000_000B_01C344C9.366F87A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi I'm from an Oracle...

Jeremy

07-07-2003 03:50 PM
Subhakar Burri

Jeff Kilbride wrote: Andrew, They will roll over. We're at -bin.1268 walt -- MySQL General Mailing List For list archives:...

walt

07-07-2003 02:52 PM
walt

When does it get to a point where you would need to use separate (identical column) tables. For instance, google/ragingbull/yahoo message boards are...

Nick

07-06-2003 02:12 AM
Nick

"VisionSet" <spam (AT) ntlworld (DOT) com> wrote Not sure if this would work, but assuming your coordinate fields are indexed, you could restrict...

ventre-à-pattes

06-26-2003 03:07 PM
VisionSet