MySQL Database Forum

I am not posting as a troll, rather I am looking to get some information for an implementation that I plan to use with mysql. My first question is why go with sql server or mysql, beyond the obvious reasons such as cost of licenses. My next question is how can mysql be backed up, and somehow have that information be then imported at a later...

Hi every one: I have the followin error just after mysql starts: "/usr/bin/safe_mysqld: line 280: 17018 Killed $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 030725 16:50:07 mysqld ended"

I have a need to get data from the db that requires me to=20 1) do a select and create a new table with the results=20 2) run a query against that new table=20 3) drop the new table=20 I have a script on my server that does this using the root account that has all on *.* for the db. It works fine.=20 I now want to get these results on...

I am trying to use the geometry data types introduced in version 4.1-alpha and the spatial indexing seems to work well. But I have a large volume of data to load, and from the documentation all I can see is that I have to load using a set of INSERT (or UPDATE) commands, which are rather verbose, and which produce a lot of messages each time a...

--B_3141995145_39326071 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit I need to know how to lock single records in a table. I have multiple users logging on to a web site. I need to keep them from changing data on a record at the same time. Thanks in advance... /T

------=_NextPart_000_0009_01C3535E.C763E5F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm doing a project for a local hospital, they want to migrate their = access databases to mysql on a Linux box. The hospital runs a Windows = network and I have MYsql running on a linux box connected...

When using AUTO_INCREMENT, is there a way to set the starting value. Thanks, Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

Hi First at all ... sorry for my poor english. I have the following process: I have a Primary PC that acquires data from an external device. This data is stored in a local database. This external device is sending information all the time. There is a Secondary PC that copies the data from the Primary PC database. There is another...

I have two tables as below: CREATE TABLE domain_types ( type_id INT(4) NOT NULL AUTO_INCREMENT, name VARCHAR(10) UNIQUE NOT NULL, description VARCHAR(75), PRIMARY KEY(type_id) ) TYPE=INNODB COMMENT="Types of domains we store"; CREATE TABLE domains (

--=_603E7359.5B3A569C Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I suspect that this is some kind of issue with privileges. However, the = account I am using has been given 'ALL' privileges to the database I am = trying to insert to. Am I save to assume that ALL...

I would like to copy the values from each record in the Program table to = another table (tblPrograms). This is the syntax I came up with:=20 select * from Program insert tblPrograms set ProgramCode=3DLocation, = ProgramName=3DDescription; However, it fails without telling me why. Perhaps someone could correct me = or re-direct me on this...

Hello, I have a strange problem, maybe some of you will be able to explain me something. I use LEFT JOIN as a substitute for subselects. It's true that many subselects can be rewriten using LEFT JOIN. I have made a query which use LEFT JOIN statement and... when there are many LEFT JOIN's (over 3) on the same table MySQL execute this query...

I'm on a trek looking for fast reliable (bug free) MySQL 4.1 components for Delphi 6/7 for accessing large MyISAM and Innodb tables. Can anyone make any recommendations? I've tried MySQLDAC from MicroOlap and unfortunately support is terrible. (No reply to any of my e-mails in the past 2 weeks). I'm also looking at Zeos (where are the...

Hello, I have a strange problem, maybe some of you will be able to explain me something. I use LEFT JOIN as a substitute for subselects. It's true that many subselects can be rewriten using LEFT JOIN. I have made a query which use LEFT JOIN statement and... when there are many LEFT JOIN's (over 3) on the same table MySQL execute this query...

I'm on a trek looking for fast reliable (bug free) MySQL 4.1 components for Delphi 6/7 for accessing large MyISAM and Innodb tables. Can anyone make any recommendations? I've tried MySQLDAC from MicroOlap and unfortunately support is terrible. (No reply to any of my e-mails in the past 2 weeks). I'm also looking at Zeos (where are the...

Hi. Can anyone stop this guy and this message? I'm getting a ton of them. I might just direct his email to my delete bin. Thanks, Trina -----Original Message----- From: Info Sent: Thursday, July 24, 2003 10:01 PM To: mysql@lists.mysql.com; nils@knowd.co.jp; vikram@w-o-i.com

I have recently set up mySQL on a Mandrake release of Linux (Version 7 of Mandrake, I believe), using the binary 4.0.13 standard release. The set up and start up all were normal, as far as I could tell, with no warnings or error messages. In nearly all respects, the database appears to be running as expected. I have the book "PHP and...

Hi. Can anyone stop this guy and this message? I'm getting a ton of them. I might just direct his email to my delete bin. Thanks, Trina -----Original Message----- From: Info Sent: Thursday, July 24, 2003 10:01 PM To: mysql@lists.mysql.com; nils@knowd.co.jp; vikram@w-o-i.com

I have recently set up mySQL on a Mandrake release of Linux (Version 7 of Mandrake, I believe), using the binary 4.0.13 standard release. The set up and start up all were normal, as far as I could tell, with no warnings or error messages. In nearly all respects, the database appears to be running as expected. I have the book "PHP and...

Hi there, I want to do something ridiculously simple and naturally MySQL is presenting me with problems that the manual doesn't even hint at. Platform is Debian Linux 2.4.21 All I want to do is change the datadir in /etc/mysql/my.cnf from /var/lib/mysql to /DB. I attempted this as follows:

Hi there, I want to do something ridiculously simple and naturally MySQL is presenting me with problems that the manual doesn't even hint at. Platform is Debian Linux 2.4.21 All I want to do is change the datadir in /etc/mysql/my.cnf from /var/lib/mysql to /DB. I attempted this as follows:

Hi, I was using a 4.0.13-server and wondering about why LEFT() doesn't take advantage of an index, the way .. LIKE "X%" .. does. I was wondering if there would be any effort in implementing this optimisation, or if people should just be encouraged to use LIKE (as bug #747 mentions)? -- - Peter Brodersen

Hi, I was using a 4.0.13-server and wondering about why LEFT() doesn't take advantage of an index, the way .. LIKE "X%" .. does. I was wondering if there would be any effort in implementing this optimisation, or if people should just be encouraged to use LIKE (as bug #747 mentions)? -- - Peter Brodersen

Hi All - I'm a newbie to the database area, but have inherited a MySQL database to manage along with my development duties. We have a very large MySQL database, and the designer of the database no longer works for us. I need to re-create the same table structure, but without the content, on a separate machine. I know I can do a show...

Greetings I have a table with the following table structure - Field Type Collation Null Key Default Extra ------- ------------- ----------------- ------ ------ ------- ------ email char(75) latin1_swedish_ci