Newbie needs help....

I have a problem which I'm not sure the best way to go about. We will be shipping products based on weight and I have two types of product with differing weights. Basically we want to charge one price for shipping less than 10 KG and one for anything over that. I wonder how to go about it. I have

query

Hi, I got a problem on how to create a query on my data, where I want to get the item which is having a 'busy' and not having a 'complete' value. Sample data Number reason 1 busy 2 complete 1 complete 2 complete 3 busy 4 complete 5 complete 3

Help with RH7.3+ and 3.23.49

Prior to Redhat updates, database was working fine. Did updates, rebooted, and now remote queries can't connect. This 7.3 system never had mysql logging on, and I can't figure out how to turn it on to help with troubleshooting. I started getting some messages about the innodb...so I added skip-

Howto check whether really innoDB is used

Hi folks, I just upgraded to mysql-max-3.23.52-1 because I realized that the standard mysql does not support transactions. I still have a transaction problem with many clients reading the same data (every read causes an update on one column so that the read value should be unique in the whole clu

RE: Please Help Can't Build

Hi there! After include /usr/local/bin on the library path as was suggested by ED appears to work because isn't complaining about any more but It broke again on something different. Please any Idea? Thanks Jose Albert Here the output \... I'm still trying to build mysql-3.23.51 /local/mysq

Fwd: Custom Indexing

Where can I find info about HOW-TO write my own indexing subsystem for MySQL?? Or perhaps an example, or even the full thing. I need a "sphere" indexer, which finds spheres overlapping a "search sphere". Niclas = QUERY - SQL = --

Error on MySQL RPM upgrade

Upon upgrading from MySQL-3.23.52 to MySQL-3.23.53 (using rpm -Uvh), I get the following error: Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! The user does exist, and the /var/lib/mysql directory is readable and writable by this user (the same one that

UDF and strlen

Hi, Im experiencing some problems with strlen in a MySql UDF function. My function takes 2 string parameters, when any of them is from a table field, strlen does not return the real length of the string, example: long test(UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error) {

What is the best suited file system for MySQL w/ InnoDB?

Among ext3, reiserfs, ext2, and xfs, which one is the best for MySQL w/ InnoDB? Since partition size is as small(!) as 60GB, I think that ext2 could be plausible choice. But any other journaling filesystem can outperform ext2 in using MySQL? -- Chung Ha-nyung Sayclub

RE: Copying Tables across machines

At 15:16 -0400 10/14/02, Dennis wrote: >At 02:51 PM 10/14/2002, you wrote: >> > Is there a way to copy a table from one mySQL machine to another without >>> implementing replication? The goal is be able to grab a copy of a table >>> from some other machine (without regard to master/slave relati

InnoDB Memory Settings for a LOT of RAM

I've got a Linux server (RH 7.3, 2.4.18, 1.5GB RAM) which runs good but could always be faster. Memory is relatively cheap all things considered, so we just added 4GB to it. I can increase innodb_buffer_pool_size from the 800M I had it at previously only to about 1500M without problems. I was hopi

Re: Still having local-infile problems

nellnA hciR <[EMAIL PROTECTED] said: > if you add local-infile=1 to your main my.cnf (/etc/my.cnf) under the mysqld > & mysql groups, you will be able to use load data local from the mysql > client > > contents of /etc/my.cnf > > [mysqld] > local-infile=1 >

subselect emulation

I'm having a little trouble working out an alternative way to do a particular subselect (as would be) in MySQL. The basic problem is a situation where I have a table with 3 columns: id, group, value I want to get the sum of the minimum x values for each of the groups. Something along the lines

Re: Normalization sql

>Studios (StudioName, StudioID) >Genres (GenreName, GenreID) >Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) >Actors (F_Name, L_Name, ActorID) >Stars (TitleID, ActorID) TitleGenres (TitleID, GenreID) So, if I just use theses tables I will be OK if the video has multiple tit

mysql select from array?

Hi, It's my first post here so excuse me if I'm a little vague. For this example I have two tables; 'songs' that contains an ID of the track and name (and other info we don't need to know) and 'setlists' which is a link table for other tables, which for this purpose don't matter. 'Setlists' has

Still having local-infile problems

Since I have had no luck whatsoever figuring out how to use the "local-infile" options, I modified my Gentoo ebuild to pass "--enable-local-infile" to the compile configure. Do I still need to use local-infile options at all? I am using mysql-3.23.52.

RE: Help Please - Cannot query server remotely

thanks to all the people that answered. Downgrading glibc worked for me. It was suggested that I upgrade the mysql package, but I think I will wait for Red Hat's fix. thanks again, Dan -Original Message- From: John Hinton [mailto:[EMAIL PROTECTED]] Sent: October 14, 2002 5:04 PM To: Da

Re: How to see whether a field is contained in a string (reverse of LIKE)

Or you could just reverse the arguments to LIKE, so your field is on the right and your string is on the left. You may have to surround your field with concat('%', field_name, '%') (or just use regexp), but LIKE is a binary string comparison operator and doesn't care which, if either, arguments a

Help Please - Cannot query server remotely

Hi, I'm having a sudden problem overnight. During the night I had a hard drive failure. After a reboot and a check disk on the drive things were going good, at least so I thought. System: Red Hat 7.2 Version: RPM mysql-server-3.23-41-1 I am now having problems connecting to the mysql server

Best MySQL version for replication

I am about to setup the following server layout using all Windows 2000 Server and XP Pro machines. Master Server-| |--Branch Office Server -| ||- Machine 1 ||...

Re: How to see whether a field is contained in a string (reverse of LIKE)

On 14 Oct 2002, at 20:29, Tim Kerch wrote: > For example, I have a string > "Administration,Advertising,Direction,Media,Research" and I want to see > whether a SECTOR field in a row is contained in the above string. You could construct a query something like this: SELECT * FROM table_name W

How to set a field to mirror another field in another table?

I'm a beginner with MySQL so please forgive my clumsy questions. For example, I have a table ALPHA and a table BRAVO. ALPHA has a field called STRING1 I want BRAVO to have a field whose contents would be those of ALPHA.STRING1 How do I define this kind of field, so that the content of BRAVO.BL

Re: How to see whether a field is contained in a string (reverse of LIKE)

On Monday, Oct 14, 2002, at 13:29 America/Phoenix, Tim Kerch wrote: > For example, I have a string > "Administration,Advertising,Direction,Media,Research" and I want to see > whether a SECTOR field in a row is contained in the above string. > > so that I can select rows which contain only "Adver

RE: How to see whether a field is contained in a string (reverse of LIKE)

>If you are looking for 'Advertising' in the column, >why not just put this in your query > >where SECTOR = 'Advertising' Yes, but instead of 'Advertising' I could have 'Advertising,Media,Whatever' So I need to have a way of finding out whether SECTOR is contained in 'Advertising,Media,Whatever

How to see whether a field is contained in a string (reverse of LIKE)

For example, I have a string "Administration,Advertising,Direction,Media,Research" and I want to see whether a SECTOR field in a row is contained in the above string. so that I can select rows which contain only "Advertising" in their SECTOR field.. sort of like a reverse LIKE, whether a field i

List of Linked Libraries for 3.23.52

Hello, I'm a psuedo-newbie with mysql. I've had so much administrative success with it in the past, I haven't had to seek counsel elsewhere. I didn't see a list tailored to MySQL admins, so I suppose this place is the best to post this question. I have been running MySQL in 32-bit mode on Sola

RE: Copying Tables across machines

At 02:51 PM 10/14/2002, you wrote: > > Is there a way to copy a table from one mySQL machine to another without > > implementing replication? The goal is be able to grab a copy of a table > > from some other machine (without regard to master/slave relationships) in > > some programmatic way withou

The MySQL 4.0x

Exists plans to release 4.0x series a "stable" ? When ? And 4.1 series... exists plans to release a "alpha" ? when ? tnsk ;) sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento --

RE: RE: Please Help Can't Build

Ed thanks for your replay But the libraries are there on the path PATH="/usr/local/lib:/usr/lib:/usr/local/:/usr/local/bin:/usr/bin:/u sr/ccs/bin/:/usr/ucb:/etc:." bash-2.05$ ls /usr/local/lib/libstdc++.so.5 /usr/local/lib/libstdc++.so.5 - Jose >> g++ -O3 -DDBUG_OFF -fno-implicit-templates -

Re: Copying Tables across machines

On Mon, 14 Oct 2002, Dennis wrote: > Is there a way to copy a table from one mySQL machine to another without > implementing replication? The goal is be able to grab a copy of a table > from some other machine (without regard to master/slave relationships) in > some programmatic way without havin

(perl) script for replication log rotation

Anyone know of/have recommendations on a perl script to do replication (binary) log rotation? I have a master with multiple slaves. I need to be able to rotate the binary log of the master and get rid of any old files that the slaves aren't reading. I'm looking for a script that will talk to the

Copying Tables across machines

Is there a way to copy a table from one mySQL machine to another without implementing replication? The goal is be able to grab a copy of a table from some other machine (without regard to master/slave relationships) in some programmatic way without having to do a dump, copy file and rebuild. S

Re: Default data dir

On Mon, 14 Oct 2002, Niranjan Patel wrote: > I get that point but is there any other way we can > change the path . Hi, You can reposition your entire data directory by using the --datadir=/path/to/new/data/dir command line parameter to mysqld. This repositions all databases, and you have to co

Re: Default data dir

i have this as part of /etc/my.cnf, all data file are in the directory /my. be sure to set your permissions on /my to the mysql user [mysqld] datadir=/my - hcir On Monday, Oct 14, 2002, at 10:19 America/Anchorage, Niranjan Patel wrote: > I get that point but is there any other way we can > c

Gemini Table

I would like to know what the exactly diference the ACID nomenclature. I read the mysql documentation, but it´s a little difficult to understand between C and D. Does anybody can explain. Tks. Greetings Alexander sql, query __

Please Help Can't Build

Please Help Can't compile on Sparc Solaris 9 Following the manual suggestions I build gcc-3.2 on the same box as well as gnu-binutils-2.13, but I'm not being successful on mysql-3.23.52. Could be the gcc? it was configure --with-as=/usr/ccs/bin/as --with- ld=/usr/ccs/bin/ld and not using gnu-b

Re: Default data dir

Not on a per database basis, that I know of. Anybody else? --jeff - Original Message - From: "Niranjan Patel" <[EMAIL PROTECTED]> To: "Jeff Kilbride" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 11:19 AM Subject: Re: Default data dir > I get that point but

Re: MySQL 3.23.53 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, (I've just noticed, that I've used my private email-address for this announcement - sorry about that!) On Monday 14 October 2002 19:09, John Hinton wrote: > > - We've hopefully fixed the problem with spurious load spikes on Linux > >system

Re: Default data dir

I get that point but is there any other way we can change the path . Thanks Niranjan --- Jeff Kilbride <[EMAIL PROTECTED]> wrote: > You can relocate an entire database with a symbolic > link: > > ln -s /path/to/database/files > /var/lib/mysql/database_name > > --jeff > > - Original Message

Re: about use Dev-cpp and C++

Greetings.. Is iut necessary that you usee STL. Other wise MySQL C API are much more easy to maintain and program. Even SQLyog which I am a beta tester is written using MySQL C API and its very fast. Rgds Insane - Original Message - From: "wang tianyi" <[EMAIL PROTECTED]> To: <[EMAIL PR

Re: Use host

Greetings... Host tables are used to give privileges of a very esoteric type to user who are connecting from differnt host with differnt permissions. I think the MySQL documents, privilege section has a detailed working of host table. It is the best I have seen till now. Rgds Insane - Orig

Re: Efficiency Query

Greetings... MySQL can handle datas hundreds times greater then that very efficiently so dont you worry about handling 500 MB. My database has 8GB of data and it performs best. So dont worry. Rgds Insane - Original Message - From: "Alberto Ruiz Cristina" <[EMAIL PROTECTED]> To: "mysql

Re: database names containing '?' bypass permissions

On 14 Oct 2002, at 11:00, Brian Scott wrote: > Example: if test_db exists, any user with permission to access test_db > seems to be permitted to create "test?db" regardless of permissions. It's not the question mark that's causing the problem -- it's the underscore. And it's not a bug: # P

Re: Default data dir

You can relocate an entire database with a symbolic link: ln -s /path/to/database/files /var/lib/mysql/database_name --jeff - Original Message - From: "Niranjan Patel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 10:50 AM Subject: Default data dir > Hello

database names containing '?' bypass permissions

>Description: A user who would not otherwise have permission to create a database can create a database which contains a "?" character, when the wildcard matches an existing database that the user has permission to access. Example: if test_db exists, any user with permission to access test_db

Default data dir

Hello In my case Default data files directory is /var/lib/mysql. I want to store all files of one database in another directory. Is there a way we can specify data directory per database. Or else can we change the entire data directoy of mysql. I tried to change it using my.cnf but I guess i mis

Re: Dual processors and mysql

MySQL is multithreaded, so your OS will send separate threads to different processors. So, yes, MySQL will automatically take advantage of multiple processors, no need to tell it explicitly. j- k- On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote: > Hello all... > > I´m comp

Re: MySQL 3.23.53 is released

Lenz Grimmer wrote: > - We've hopefully fixed the problem with spurious load spikes on Linux >systems when accessing the Database via TCP/IP. This was caused by the >static glibc files we used to link against and should now be resolved. Apparently this glibc/mysql situation is being w

Re: HELP - Having serious trouble here...

https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 is a link to this bug. In fact the glibc update is conflicting with client connections to mysql. The bug was first reported around 10-4-02 and has been given a priority code of 'High'. Redhat Response. The problem is actually that M

MySQL/InnoDB-3.23.53 is released

Hi! InnoDB is a table type which adds transactions, row level locking, a non-free hot backup tool, and foreign key constraints to MySQL. InnoDB is included in -Max downloads of the stable MySQL-3.23 branch and in all downloads of the beta MySQL-4.0. 3.23.53 is a bugfix release. Windows 95/98/ME

4.0.4 replication slave "hangs" after master breakdown+reboot

Hi friends, has anybody had similiar experiences? Environment: Systems are x86 SuSE 8.0/7.3 Linux, MySQL-max version 4.0.4 is used on all machines (installed from the mysql.org-RPMs). The setup is a circular replication with 3 machines. Linux distro- or kernel- version don't seem to play a

Dual processors and mysql

Hello all... I´m compiling the mysql 3.23.53 in DUAL PROCESSOR MACHINE... in mysql exists an option to "optimize" on DUAL PROCESSOR MACHINE ? my system is mysql 3.23.53 in linux 2.4.18 ( with 1G RAM ) sql,query - ++

Re: Diferences between check and analyze

On Mon, 14 Oct 2002, Alexander Burbello wrote: > I make always confuse, what is the diference between the command CHECK and > ANALYZE. Hi, ANALYZE TABLE checks through and updates the key distribution information of a table (affects join order). CHECK TABLE check the table for errors. It also

MySQL 3.23.53 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.53, the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is a bugfi

Re: Export of text fields from Access2000

Intelligent Converters has a product that's pretty inexpensive, about $35 I believe. It pretty much works as advertised, it was much cheaper than spending any time trying to roll my own script. We recently got an Excel spreadsheet that we needed to import, and after a few minutes of playing arou

MySQL 3.23.52 high load bug/leak report

I recently upgraded from MySQL 3.23.51 to 3.23.52 on RedHat Linux 7.1 (kernel 2.4.18-ac3). With the same traffic that produced about a 1.0 load on my servers consistantly, the load jumped into the hundreds with the new version of MySQL. After downgrading, the load returned to normal. I am doing

Diferences between check and analyze

I make always confuse, what is the diference between the command CHECK and ANALYZE. Regards sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th

Use host

Hi, I would like to know when I use the table "Host". Why does she exists? query, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: HELP - Having serious trouble here...

It sounds like the glibc auto-rpm that Redhat produced (to plug a security hole, I believe) is the root cause. Getting mysql 3.23.52 from mysql will be the solution. I don't know who could get Redhat to coordinate their updates. John Hinton wrote: >I'm having the same problems. I'm on a Red

HELP : Performance with FULLTEXT Index

Hi everybody, I'm trying to use the Full Text index functionality with MySQL 3.23 and I have a problem I can't understand. I have a table built this way : CREATE TABLE MyTable ( Id bigint unsigned NOT NULL, Num varchar(20) NOT NULL, Title varchar(150) default NULL, Aut1 varchar(100) d

about use Dev-cpp and C++

hi i use windows2000/xp and Dev-cpp(a C++ compiler) , and want to connect with mysql, but now , i not know STL much. how can i do , who can show me a source code? thanks. i already download STLport ,but i not know how to use it ! :( -

re: High load with "cleaning up" status

At 02:56 PM 10/14/2002 +0300, you wrote: >Hello Mike, > >Saturday, October 12, 2002, 5:41:11 AM, you wrote: > >MZ> Recently our DB, which is running MySQL 3.23.52, started experiencing >MZ> intermittant load spikes, of the magnitude of 200+ load averages. >Normally, >MZ> our high spike is about 0

Re: HELP - Having serious trouble here...

On Mon, 2002-10-14 at 17:29, Anders Nielsen wrote: > On Mon, 2002-10-14 at 16:51, John Hinton wrote: > > I'm having the same problems. I'm on a RedHat machine... 7.2 running > > MySQL ver. 3.23.41. I've been told to upgrade my package. > > > > Me too. After reading your posting I realized that

RE: Export of text fields from Access2000

If you create the tables beforehand in MySQL and then export the data into the already created table, that should allow you finer control of your data types. To save time you could export the table from Access, then truncate it to clear out the data, and then change the data types as necessary

Re: HELP - Having serious trouble here...

On Mon, 2002-10-14 at 16:51, John Hinton wrote: > I'm having the same problems. I'm on a RedHat machine... 7.2 running > MySQL ver. 3.23.41. I've been told to upgrade my package. > Me too. After reading your posting I realized that glibc probably was the root of the problems (my problems starte

Re: Normalization sql

I forgot to add Video (This has all the Primary key id from the tables below) Now does it work? My question is how do I get the Primary keys into the video table? Do I just put them in and the database will know it should look in the other tables? How do I connect it? I read some books bu

Re: HELP - Having serious trouble here...

I'm having the same problems. I'm on a RedHat machine... 7.2 running MySQL ver. 3.23.41. I've been told to upgrade my package. I think RedHat has put out an update to some other library, module or such, that is in conflict with remote/client management applications??? Everything is working fine

Re: Magazine article database

Agreed. My first "project" to learn PHP and MySQL was to create a message board. That wheel has been invented who knows how many times. But after I finished it, I looked at other solutions to see what directions they took and how I could improve my solution. And especially where I went wrong.

Re: Normalization sql

Hi John, your design is normalized, but incomplete and unconnected. Where do you put the information which actor was playing in what title, which title was done in what studio etc. ? Normalization is a representation technique to avoid storing *redundant* information. But first this informati

Re: HELP - Having serious trouble here...

What is in the error logs? Vernon Webb wrote: >I have been using MySQL for nearly a year now with no problems, until now. I >rebooted my box this morning and since rebooting I have had nothing but >trouble. > >First off I have noticed (I never looked before because I had no need to, >but the

Looking for tool to pretty print table structures

Hi there, Does any of you know of a utility to pretty print mysql table structures? I have a pretty big and messy DB I need to work on, and I would like to be able to print the table structures with nice tables. Any pointers? --

Re: Problem Importing Data from Text File, HOW IGNORE SOME TEXT COLUMNS???

Reformat your import file. or Add two columns , import, and drop the two columns. or Import to a six column temporary file and do an insert into select from. tl wrote: >Hello, > >#If I have a file "t.txt" > > >111 222 333 ddd 444 ddd >111 222 333 ddd 444 ddd >111 222 333 ddd 444 ddd ><< >

Re: Normalization sql

You're starting off ok, just missing the links between the tables. I would suggest for simplicity though that you change the names of your PKs to reflect their table, i.e. Title (VideoTitle, Details, TitleID). Otherwise once you do multi-table queries joins you will have to specify the table names

Re: Efficiency Query

At Montag, 14. Oktober 2002 14:57 Alberto Ruiz Cristina wrote: > Hi all > > I am new to MySql and I am thinking about using it for managing a > database, which would have a approximated length of 500 Mb. It is formed > of vectors. Greetingz, from my experiences with several Databases since the 1

Re: Problem with query - join two tables - order by goes crazy

Since it can't use an index, and has to sort the output, what exactly is unexpected? Norris, Joseph wrote: >Group, > >I have the following query: > >select phones.*, ops.plid, ops.box, ops.mac >from phones, ops where >(ops.box = 'Mcds') or (ops.box = 'Mn3300') and >(phones.suffix1 = ops.phone

Re: Type

The MyISAM table type should be fine for what you are doing, and is faster than the InnoDB type. Basically, you only need transactions in situations where a) money is involved or b) you will be updating multiple tables and all updates must be guaranteed successful, or none. hth, Arthur - Ori

Re: Connections always max out

It sounds like a mis-configured Apache is never closing connections. Troy Hakala wrote: > Ok, I've been having this problem every so often and it's happening > more and more these days and I still can't figure out a solution. I > know this sounds vague, but maybe you can help me make it less

Multiple MySQL servers on the same machine

Hi! I want to run 2 versions of MySQL on the same Linux machine. I already have 3.23.41 installed and I want to install 4.0.3 to test it. I tried to install MySQL 4.0.4 but cannot install because of failed dependencies. Thanks for any help, Macarie Neculai.

RE: sudden increase in size when doing CREATE TABLE ... SELECT ...

Hi there ! A sample create table SQL query is as follows : "create table eml.adjacency select * from emlbase.adjacency where eml.adjacency.importdate = '2002-10-10';" The database names (e.g. "eml") ,tablenames (e.g. "adjacency") and date are changed by a perl script for the different tables

Re: MySQL-3.23.53 and Redhat-7.3

Do you have a user defined as? Login Name: mysql Full Name: MySQL Server group: mysql Home directory: /var/lib/mysql Your 'Fatal Error' line indicates that user mysql does not exist? [EMAIL PROTECTED] wrote: > > >Description: > > Upgrade from MySQL-3.23.52 to MySQL-3.23.53 > > 021014 15:49:5

Re: Why must I quote fields now?

It's always a bad idea to name your columns using keywords. - Original Message - From: "olinux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 5:42 AM Subject: Why must I quote fields now? > Hi all, > > I have just added a field (order) to a table with > abou

Re: Efficiency Query

On Mon, 14 Oct 2002, Alberto Ruiz Cristina wrote: > Hi all > > I am new to MySql and I am thinking about using it for managing a > database, which would have a approximated length of 500 Mb. It is formed > of vectors. > > Trouble is that I am worried about the ability of MySql to handle that > am

Re: Number of tables

Hey, On the same computer than before? Fred - Original Message - From: "Insanely Great" <[EMAIL PROTECTED]> To: "Peter Stöcker" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 2:08 AM Subject: Re: Number of tables > Greetings... > > I belive MySQL

Efficiency Query

Hi all I am new to MySql and I am thinking about using it for managing a database, which would have a approximated length of 500 Mb. It is formed of vectors. Trouble is that I am worried about the ability of MySql to handle that amount of data. Do you know about any article or study about MySql

MySQL-3.23.53 and Redhat-7.3

>Description: Upgrade from MySQL-3.23.52 to MySQL-3.23.53 021014 15:49:54 mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 021014 15:49:54 Aborting 021014 15:49:54 /usr/sbin/mysqld: Lõpp 021014 15:49:54 mysqld ended >How-To-Repeat:

Normalization sql

I've read a bunch about normalization in MySQL and still can't do it very well. What I want to normalize is videos (Title, Studios, Actors, Genre, &bitrate). These are the tables and fields I think it needs. Is this normalized? Thank you. Table (Fields) Title (VideoTitle, details, id) Studio

WARNING: FAKE NAMES

Hello. WARNING!!! Somebody is sending viruses to subscribers of this mailing list using my name. So, please remind: not me, nor Vita - we are not going to send any code examples, any archives, any executables or even ANY attaches. Also we do not send private mails to list subscribers. So plea

Re: Number of tables

Greetings... I belive MySQL is powerful enuf for the mentioned type of data. I have a database in win2k with 100 tables and the size of the database is 8 GB. It performs fantastic, faster the MS SQL Server which I had before. I have MyISAM tables. Rgds Insane SQLyog - The Definative Win32 GUI F

re: sudden increase in size when doing CREATE TABLE ... SELECT ...

Hartmut, Monday, October 14, 2002, 2:07:11 PM, you wrote: HB> Recently we have begun developing a web-based configuration sheet generator. The basis for these configuration sheets is data stored HB> on several Sun servers. The Sun servers are responsible for collecting HB> all config data from al

privileges

Hi, I would like to know when I give privileges to the user, in the table level, and after I give privileges in the database level. Do I replace the privileges? There are two tables ('db' and 'tables_priv') in mysql database. I gave privileges, for example, to the table 'tables_priv', I give o

Re: stored procedure support

And I hope triggers as a collegue and I have to submit a evaluation report on why our department should consider Mysql to be used in conjuction with Postgrsql which is our default RDBMS in our organisation. So I have a few link's regarding performaces etc as well as the Mysql V PostGresql Any

Re: query question - solved

Thank you Egor. These queries meet my needs. Egor Egorov wrote: >Veysel, >Monday, October 14, 2002, 12:48:58 PM, you wrote: > >VHS> I am using mysql 3.23.52. I have to query one of my tables which has two >VHS> columns with the type of "date" and "time". For example i have to get >VHS> the re

re: High load with "cleaning up" status

Hello Mike, Saturday, October 12, 2002, 5:41:11 AM, you wrote: MZ> Recently our DB, which is running MySQL 3.23.52, started experiencing MZ> intermittant load spikes, of the magnitude of 200+ load averages. Normally, MZ> our high spike is about 0.90 load. When this starts happening, we notice a

Type

1) Is there a de facto type that is used? All I will be doing is creating a database for use on the web for dynamic webpages. Basically doing searches to the back-end MySQL database. I figure I don't need to use transactional type since I will not be adding any information via a front-end.

re: query question

Veysel, Monday, October 14, 2002, 12:48:58 PM, you wrote: VHS> I am using mysql 3.23.52. I have to query one of my tables which has two VHS> columns with the type of "date" and "time". For example i have to get VHS> the records whose date are 2002-10-12 and time is bigger than 11:30:00 VHS> a

sudden increase in size when doing CREATE TABLE ... SELECT ...

Hi All ! Recently we have begun developing a web-based configuration sheet generator. The basis for these configuration sheets is data stored on several Sun servers. The Sun servers are responsible for collecting all config data from all equipment connected to the network. We have developed scr

re: adding a string to enum

Russ, Sunday, October 13, 2002, 8:33:55 PM, you wrote: RCS> When I try to add a string to the end of an enum list I get the following RCS> error message: RCS> You have an error in your SQL syntax near '\','Historical RCS> Knowledge','Chronological Thinking, Comprehension, Analysis and I' at line

re: OK... stuck on can't connect from client

Hello John, Monday, October 14, 2002, 3:36:20 AM, you wrote: JH> I'm on Linux Redhat 7.2 and MySQL v. 3.23.41 JH> Number of processes running now: 1 JH> mysqld process hanging, pid 8617 - killed JH> 021013 20:08:43 mysqld restarted JH> /usr/libexec/mysqld: ready for connections [] Download t

re: Lost connection to MySQL server during query

Hello Me-Selfe, Saturday, October 12, 2002, 2:25:23 AM, you wrote: MS> After a reboot, the database server running Redhat 7.2 and mySQL MS> 3.23.41-1 started acting funny. When I try to telnet to port 3306 of the MS> server, nothing happens and when i check in the log file for mysql, i MS> get s

re: Number of tables

Peter, Monday, October 14, 2002, 10:38:06 AM, you wrote: PS> Does anybody know whether it is possible for MySQL to handle round about 500-600 tables in one database or not (Win2k)? Where is the maximum? PS> I want to work with dynamically created tables. Number of tables in the database is lim

  1   2   >