MySQL Database Forum

Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which was working fine until a while ago. I haven't watched it recently, and haven't changed anything I am aware off right now. After I realized the...

Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb > out.sql but returns this .... -- MySQL dump 8.21 --

I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson jake@plutoid.com ______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and...

I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0...

------=_NextPart_000_00FC_01C35142.4E7FDE00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there any way to create a symlink of table in two different = databases which belongs to the same user. It will be great help if I get the solution for above mention task. =20

------=_NextPart_000_00FC_01C35142.4E7FDE00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there any way to create a symlink of table in two different = databases which belongs to the same user. It will be great help if I get the solution for above mention task. =20

I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it contains confidential client information. It has to be Window because applications accessing the database are written in Windows. The problem is laptops do get stolen quite often, even when running on someone's unattended desk. Most security chains can be cut with a...

Hello Guys, I have Risc/AlphaServer ES40 with processor EV6 500mhz running RedHat 7.2/Mysql. Could you please send me Bench test ? I like to try tks, Julio

--0-474210375-1058976151=:31789 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Note: forwarded message attached. __________________________________

Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0 |

How do I fix this error? My tables have data. Regards, Jake Johnson jake@plutoid.com ______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts.

Hello all, I wonder if is there any way to select from a table all the records which has a Date Field that is at least five minutes old? In other words, I have a table with a date field and I need to select all the records that are older than five minutes, has their date field updated before five minutes.

------=_NextPart_000_0000_01C35111.935D6050 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, Mysql Version 4.0.11a-gamma When I try and run the following query

------=_NextPart_000_015D_01C35115.AD04EC90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everyone. I have copied the results from and explain on a query = that I want to use. And I am wondering if anyone could tell me if these = results are bad or good? If everything below is coming up...

--=_4C1260B9.7C1D656D Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it up I get an hourglass for a second, then nothing happens. Has anyone had similar issues or any ideas as to what could cause this? Thanks

I have two tables: bc_post and bc_message. This is what I have so far: select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid where bc_post.post_status = '1' and bc_post.user_id = '1' group by

Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high...

Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik

Hi All, I am running mysql-3.23.52 on OS X (10.2.6) and I'd like to install the mod_auth_mysql module for a job I'm working on that used it under a different platform. I compiled the module using: apxs -c -D APACHE1 -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -lmysqlclient -lm -lz mod_auth_mysql.c

What is the easiest way to import an XML Datafeed from a URL into a MYSQL Database? Possibly using PHP Regards Joe PS Please answer to group and joe@joesharman.co.uk

------=_NextPart_000_005F_01C35137.8729F1B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any way to restrict UPDATE without a WHERE clause? Mohammad Khan Software Engineer

Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to either database server are replicated to eachother. Basically even though we have a 4:1 ration of read/write the writes...

I'm basing some work on Joe Celko's excellent idea of using nested sets to represent an organizational structure as opposed to an adjacency list. By and large it's a great idea, but not without its pitfalls. I'm writing now to ask your collective opinion of the best practice. I've got my nested set table, and since the left bound is unique,...

Degan, jumping in to try and solve some problems that look pretty obvious to me ... > #options for default service (mysqld2) > (mysqld2) It should be , not (mysqld2).

------=_NextPart_000_0266_01C35140.F8B40510 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this is not related to MySQL questions, but we are looking for a = savvy PHP/MySQL guru to fill a position at my organization. The job = description and requirements are below. Strong English...