MySQL Database Forum

Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an...

http://www.etsetb.upc.es/download/sources/dump_grants/ DESCRIPTION This tool dumps the permissions granted to the users of the MySQL database. It also could print a report of dangerous grants. USAGE

Hi. I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... My initial thoughts on how to do this are: 1. Execute a...

Hi. I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... My initial thoughts on how to do this are: 1. Execute a...

Hi,=20 I have a query that runs in Microsoft Access against my mysql database = just fine. It is:=20 =20 UPDATE discussion_categories AS discussion_categories_1=20 INNER JOIN discussion_categories ON=20 discussion_categories_1.parent_1_text =3D discussion_categories.name=20 SET discussion_categories_1.parent_1 =3D =

------_=_NextPart_001_01C35095.401E90C0 Content-Type: text/plain; charset="iso-8859-1" I would like to know if there is a way of building an index on all the words of a column. We want to have an alphabetical search on all the words of a description of a product.

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 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...

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

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

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.

--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.

--=_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

------=_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...

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