Re: Strange table problem

I dont think product_beta.test is a table...It seems to be a view.. what is the create statement for it.. show create table product_beta.test; ??? -Lakshmi Ruan wrote: Hi everybody, I have a very strange table problem - a table was created in one of our databases, but I can't seem to drop

RE: Strange table problem

Hi, The dump revealed this: + | View | Create View | test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `test` AS select `beta_users`.`user_id` AS `user_id`,`beta_user s`.`user_type` AS

Re: Unlimited client connections for MySQL

Dwight Tovey wrote: Brent Anderson wrote: Hello. I'm developing a client application for several platforms that will need to connect to a remote MySQL database. Unfortunately, MySQL refuses connections from external IP's that aren't allowed and since the clients using this will be on unknown

Linux Installation

I have a Debian Linux server, and I would like to install MySQL on there. Potentially to use it in a Cluster configuration, but for now, just as a play thing. However, I'm very green when it comes to Linux. I can get to a command prompt, and list files, but the extent of my Linux knowledge is

phpmysql don't answer

Hi! I'm a beginner with phpmysql, and after an installation, I can't access to my page http://localhost/phpmysql on Debian Etch. Is a problem of restarting mysql ? Thanks for help, Thibaud. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Linux Installation

On 12/15/06, Jesse [EMAIL PROTECTED] wrote: I have a Debian Linux server, and I would like to install MySQL on there. Potentially to use it in a Cluster configuration, but for now, just as a play thing. However, I'm very green when it comes to Linux. I can get to a command prompt, and list

RE: Strange table problem

At 03:44 AM 12/15/2006, Ruan wrote: Hi, The dump revealed this: + | View | Create View | test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `test` AS select `beta_users`.`user_id` AS

RE: Strange table problem

LOL - Now I feel silly. Thanks that worked. R -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Friday, December 15, 2006 5:37 PM To: mysql@lists.mysql.com Cc: mysql@lists.mysql.com Subject: RE: Strange table problem At 03:44 AM 12/15/2006, Ruan wrote: Hi, The dump

Re: phpmysql don't answer

Thibaud Hulin schrieb: Hi! I'm a beginner with phpmysql, and after an installation, I can't access to my page http://localhost/phpmysql on Debian Etch. Is a problem of restarting mysql ? Thanks for help, Thibaud. Errors, warnings, logs? -- Smileys rule (cX.x)C --o(^_^o) Dance for me!

solved : Re: system : Install Mysql 5.x binaries with php4 on Debian

Thank you Ian, I used the link method {the least change} { It turned that the mysql.sock was in /tmp , I missed it because I tried to find it with the locate command } Create a symbolic link from the mysql.sock to the place where php expects to find it: ln -s /current/location/mysql.sock

Re: phpmysql don't answer

Thanks for your answer. This is the error message : Not Found The requested URL /phpmysql was not found on this server. Apache/2.2.3 (Debian) PHP/5.2.0-7 Server at localhost Port 80 For the logs, I don't know where looking. I suppose the base is corrupt after a hard reboot ? Barry a écrit

Re: phpmysql don't answer

Is your apache looking for index.php file as well or just for index.html file? Give a trial in this. Thibaud Hulin [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] Thanks for your answer. This is the error message : Not Found The requested URL /phpmysql was not found on this

insert into some table show status like 'foo'

Hello, Say I wanted to log some various server status variables to a table. What I'd like to do, ideally, is something like this: insert into SomeLogTable (Threads) show status like 'Threads_running'; MySQL does not allow this, of course. But, is there some other way to see the

RE: insert into some table show status like 'foo'

Hi Chris, If you are running on *Nix you could write a script generally structured like: do - show status | grep 'what_ever_string_you_want_to_see' - insert into table - sleep [seconds] done I am not sure how to do the same in Windows Regards Mikhail Berman

Re: insert into some table show status like 'foo'

On Friday 15 December 2006 11:23, Mikhail Berman wrote: Hi Chris, If you are running on *Nix you could write a script generally structured like: do - show status | grep 'what_ever_string_you_want_to_see' - insert into table - sleep [seconds] done Yes, we are, and

path Stored in MySQL

Can someone help me with getting a path stored in MySQL, Links ? Snips would be great thanks a lot -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.20/588 - Release Date: 12/15/2006

Re: insert into some table show status like 'foo'

At 11:12 AM -0800 12/15/06, Chris Comparini wrote: Hello, Say I wanted to log some various server status variables to a table. What I'd like to do, ideally, is something like this: insert into SomeLogTable (Threads) show status like 'Threads_running'; MySQL does not allow this, of course.

interesting date/time query issue

I have data that is broken into anything from 30 sec to 15 minute time series (with a DATETIME field). I need to transform all of this into 15 minute data. Does anyone know off the top of their head if there a way I could use GROUP BY to make this happen? Nothing I have tried thus far has

mysql cluster show table status

Hi, we are using MySQL Cluster 5.0.27 on Solaris 9 Sparc. The packages are from mysql.com. Doing an show table status on a database with the ndb engine returns 0 for rows count, average row length etc. Hm, i have read that such a bug existed and has been fixed with 5.0.3. So i am wondering what

Re: insert into some table show status like 'foo'

On Friday 15 December 2006 11:53, Steve Edberg wrote: At 11:12 AM -0800 12/15/06, Chris Comparini wrote: Hello, Say I wanted to log some various server status variables to a table. What I'd like to do, ideally, is something like this: insert into SomeLogTable (Threads) show status like

Re: Workaround for distinct?

The table structure is in my original post. On Dec 14, 2006, at 11:49 AM, Rolando Edwards wrote: Just change your table name and you are all set. If you have the table structure, send it and I'll make the query if you want. -- MySQL General Mailing List For list archives: