Multiple values in the host field

At a bit of a loss here, I hope there are a few savvy phpmyadmin users out there. I generally talk to mysql from the command line, however, I now have a situation where I need to give phpmyadmin access to uses in a shared environment. Currently, I only have MySql running as a datbase server,

Re: Shrinking innodb datafiles?

--- Heikki Tuuri [EMAIL PROTECTED] wrote: Just to confirm if I understand the situation correctly: innodb datafiles cannot be reduced in size to reclaim spaced freed by deleted data? you are right. Once again thanks. One absolutely last question (only just occurred to me): will the

Re: Advise on High Availability configuration

On Fri, Jan 30, 2004 at 10:36:34AM -0800, Gowtham Jayaram wrote: CONFIGURATION: [...] - Additionally, I will setup a SCSII controller in the Primary and Secondary Application machines so that the actual data store (disk drive) runs on another physical machine in a disk-array (RAID). So

Re: BUG on 64bit if a value is quoted (4.0.17 / 4.1.2 / 5.0.0)

On Sat, Jan 31, 2004 at 10:06:04PM -0500, Michael Stassen wrote: Meanwhile, perhaps a simpler workaround would be to change how you build the query in Perl so as to avoid the quotes. Well, I know that this would be easy but I have good reasons to avoid this. The most important one is lru

Re: Shrinking innodb datafiles?

Lawrence, - Alkuperäinen viesti - Lähettäjä: Lawrence Smith [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: [EMAIL PROTECTED] Lähetetty: Sunday, February 01, 2004 1:03 PM Aihe: Re: Shrinking innodb datafiles? --- Heikki Tuuri [EMAIL PROTECTED] wrote:

images from MySQL backend used with MS-Access 2000 frontend

Hi everyone, I am new to MySQL. I am starting a database project for a medium-sized medical office. I chose MS-Access (on 10-terminal pre-existing Win2K intranet) for rapid front-end dev and familiarity to the existing users. I plan to use MySQL on Linux server for backend for its speed, great

RE: Advise on High Availability configuration

Hi, In answer to your questions: - Have any of you seen such a configuration being deployed? No, when we implemented high-availability MySQL servers we used MySQL's inbuilt replication - this has been running here for years now and we have had constant DB availability during that time,

RE: images from MySQL backend used with MS-Access 2000 frontend

I would recommend storing the images on the filesystem and put the information about those images (along with the path to the image) in MySQL. If you plan to have lots of images, implement a nice logical directory structure to keep them in as in my experience linux ext2/3 is fast reading/writing

RE: Multiple values in the host field

Hi, In myuser table, I have something like this: | Php.me.com | database_name | You could use a wildcard like this: | %.me.com | database_name | This would allow any the user to connect from any subdomain on the me.com domain. However it would mean that other servers (e.g. wibble.me.com )

AUTO_INCREMENT in InnoDB

Hi, How do I reset the AUTO_INCREMENT column to some arbitrary number? My table type is InnoDB. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Query problem

Hi, You need: select job,avg(sal) from emp group by 1 order by 2 limit 1; Cheers, Andrew -Original Message- From: Edouard Lauer [mailto:[EMAIL PROTECTED] Sent: Saturday 31 January 2004 19:23 To: [EMAIL PROTECTED] Subject: Query problem Hello, I would like to query the littlest

RE: Slave crashed: error 'The table 'users' is full' on query..

Hi, Whilst you may have space on the box, you may have reached a file size limit on whatever OS you're using (on some linux versions, the max size of a file in 4GB and similar on some windows versions) It may also be a mysql limit on data length. Check the status of your table like this: mysql

RE: 5.0 replication and stored procedure

Hi, 5.0 is sub-alpha at the moment. If you think there is a problem, go to http://bugs.mysql.com/ Cheers, Andrew -Original Message- From: William Au [mailto:[EMAIL PROTECTED] Sent: Friday 30 January 2004 22:35 To: [EMAIL PROTECTED] Subject: 5.0 replication and stored procedure Does

RE: MySQL optimisations for search engine

Hi, Make sure the words.word field is indexed and that the pages.id is an indexed primary key. Cheers, Andrew -Original Message- From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED] Sent: Friday 30 January 2004 21:39 To: [EMAIL PROTECTED] Subject: MySQL optimisations for search

Re: AUTO_INCREMENT in InnoDB

Hassan, - Original Message - From: Hassan Shaikh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, February 01, 2004 5:01 PM Subject: AUTO_INCREMENT in InnoDB Hi, How do I reset the AUTO_INCREMENT column to some arbitrary number? My table type is InnoDB.

Join query for 3 tables

I have three tables: users - holds user details courses - holds course information registrations - holds id values which specify which course did a user register to eg. user #1 registered for course #4 I tried but to no avail to create a query where all users are selected, all their

RE: Multiple mysql servers with the same datadir

Hi, I think you're getting mixed up between DBD (data base driver) and BDB (BerkeleyDB) but I reckon you mean BDB... I'm not sure if the locking of the page (i.e. the whole table file) is done at the filesystem level or is managed internally by each mysqld instance. If it is managed by each

SQL select help required please

I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below code is giving me some

Re: SQL select help required please

Matthew Stuart wrote: I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below

Why does MySQL generate internal foreign key id when constrain name is given?

I am using MySQL 4.1.1-1. When I add a named foreign key constraint alter table sb_query_nm_sub_tp add constraint f1sbquerynmsubtp foreign key (query_nm) references sb_query_class (query_nm); And then do a show create table: | sb_query_nm_sub_tp | CREATE TABLE `sb_query_nm_sub_tp` (

Re: images from MySQL backend used with MS-Access 2000 frontend

Read this article for it's design on database storage.. I have several big implementations on this design which are fast, reliable and scalable (one of them in the medical field aswell) http://php.dreamwerx.net/forums/viewtopic.php?t=6 On Sun, 1 Feb 2004, Yuri Oleynikov wrote: Hi everyone,

Replication with HEAP tables slave insert error

Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with a snapshot of the data? Since a HEAP table

FreeBSD 4.9 + MySQL 4.0 + LinuxThreads

I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with LinuxThreads using Jeremy Zawodny's config/compile options (http://jeremy.zawodny.com/blog/archives/000458.html) and have had no problems. However, I've got 4.9 install with updated ports, etc. and I can't seem to get

Can't create/write to file './pricelists/iiptest.frm'

What is wrong with this? im just trying to copy the table to another table? ## MySQL said: #1 - Can't create/write to file './pricelists/iiptest.frm' (Errcode: 28) ## -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql