| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | does MYSQL have a quota built into it! I need it limit the size of each
database
AndiC
Andrew Crook
|
08-22-2004 01:37 PM
Andrew Crook | 0 | 72 |
|  | Hello,
I am using MySQL 4.0.
Say that I have a table named "mytable" having a column "ID" and a
column "test columnname".
When dumping:
mysqldump...
Bart Van der Donck
|
08-22-2004 03:20 AM
Bart Van der Donck | 2 | 87 |
|  | If I've got:
Table: users
ID USERNAME EMAIL
1 syeargin stephen (AT) yeargin (DOT) com
2 bwalkerton benwalkerton (AT) aol (DOT) com
3 rrandall rr...
Stephen Yeargin
|
08-21-2004 10:51 PM
Stephen Yeargin | 0 | 85 |
|  | Never mind.. I found the solution. hope this will help...
Other Info:
- Using dynamic IP
- Using no-ip.com services
- prt 80 closed = using...
Daniel Mercier
|
08-21-2004 02:30 PM
Daniel Mercier | 1 | 521 |
|  | Please recommend books or web sites to learn more about how to do complex
queries using MySQL. A potential client needs lots of summarizations...
NotGiven
|
08-21-2004 02:26 PM
steve | 1 | 86 |
|  | AdventNet announces the release of Micro Agent for MySQL which provides
out-of-the-box ability to monitor and manage the MySQL components, such
as...
Rekha
|
08-21-2004 03:14 AM
Rekha | 0 | 70 |
|  | teqnow wrote:
Read the description of DEFAULT rules in this web page:
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
You can't use a function...
Bill Karwin
|
08-20-2004 09:24 PM
Bill Karwin | 0 | 96 |
|  | I have a fairly large database on my (2 million records)
WIN32 mySQL 4.0.20
The question is:
I am adding large amounts of data to it (300,000 to...
Craig Stadler
|
08-18-2004 03:50 AM
Craig Stadler | 0 | 80 |
|  | Hi,
how can i backup a table / entire DB and get the index's as well as the data
/ create table's etc
cheers
Greg
Greg Brant
|
08-17-2004 11:22 PM
steve | 1 | 103 |
|  | Hi
I have a little problem with my database and php. In one of my tables i've
creted field of type Text. When i try to put some larger than 255...
Adrian Majchrzak
|
08-17-2004 10:50 PM
steve | 1 | 88 |
|  | Hi, I have researched but have not found a good solution to this
problem.
I am importing large amounts of data (over 50 Meg) into a new mysql...
steve
|
08-17-2004 10:17 PM
steve | 2 | 79 |
|  | Hi,
I'm new to mysql and just installed phpmyadmin.
Here is the versions info:
System Linux linlyne.spider.sense 2.4.22-1.2199.nptl #1
PHP...
Daniel Mercier
|
08-17-2004 09:55 PM
Daniel Mercier | 0 | 81 |
|  | Hi all, for a long time I have been using Postgresql as my application
target database, and while I'm really pleased with it I miss many
proffesional...
Enrique Ariz?n Benito
|
08-17-2004 06:02 PM
Enrique Ariz?n Benito | 0 | 152 |
|  | Im designing a program, and it has to keep track of articles in a
wharehouse.
The client uses a barcodes in the articles. Im wondering how to...
Daniel Kawer
|
08-17-2004 05:10 PM
Larry Anderson | 1 | 84 |
|  | I have a table with this structure
CREATE TABLE `occurrence` (
`occurrence_id` int(10) unsigned NOT NULL auto_increment,
`word_id` int(10) unsigned...
Jay Donnell
|
08-17-2004 01:59 PM
Bill Karwin | 1 | 81 |
|  | I have a table with this structure
CREATE TABLE `occurrence` (
`occurrence_id` int(10) unsigned NOT NULL auto_increment,
`word_id` int(10) unsigned...
Jay Donnell
|
08-17-2004 11:35 AM
Jay Donnell | 0 | 90 |
|  | I'm trying to run this query:
SELECT * FROM features WHERE food_group_ID = 'Company™'
I've tried Company%99, Company Company™ and...
K McNeil
|
08-17-2004 11:20 AM
K McNeil | 0 | 70 |
|  | I'm trying to run this query:
SELECT * FROM features WHERE food_group_ID = 'Company™'
I've tried Company%99, Company Company™ and...
K McNeil
|
08-17-2004 11:15 AM
K McNeil | 0 | 79 |
|  | I'm trying to run this query:
SELECT * FROM features WHERE food_group_ID = 'Company™'
I've tried Company%99, Company Company™ and...
K McNeil
|
08-17-2004 11:14 AM
K McNeil | 0 | 73 |
|  | We have been asigned a project required by our parent company to have
our sales people fill out a form before billing any order to...
Elliott B.
|
08-17-2004 11:01 AM
Elliott B. | 0 | 90 |
|  | Yes, i know items have been posted before, mostly for unix platforms.
On win32, what is the best way to run a secure mysqldump so that my
password...
sho_nuff
|
08-17-2004 08:28 AM
sho_nuff | 0 | 71 |
|  | I am finding delete queries on large InnoDB tables very slow - are
there ways to speed this up?
I have a table with about 100 million rows:
I am...
Jeremy Howard
|
08-17-2004 12:23 AM
Jeremy Howard | 2 | 81 |
|  | I just installed MySQL and I need to make a backup of my InnoDB tables
but I don't want to purchase the tool to do it. Does anyone have a
detailed...
CJ
|
08-16-2004 03:46 PM
Chris Hope | 2 | 133 |
|  | I have a binary distribution of MySQL 4.0.20 installed in
/usr/local/mysql.
Therefore, the only libmysqlclient file I have is...
John Ntow
|
08-16-2004 03:20 PM
John Ntow | 0 | 92 |
|  | Hello guys,
I need your help with this. I have a table that ,say, has 10 rows in it. One
of the columns is called ID and has an integer number. I...
Firewalker
|
08-15-2004 10:20 PM
Chris Hope | 1 | 78 |
|  | I'm trying fulltext searching for the first time , but I can't figure out why the example
in the mySQL manual is *not* working.
mysql> SELECT * FROM...
Mike Reef
|
08-15-2004 08:54 PM
leegold2 | 1 | 75 |
|  | I seem to be having a problem displaying time stored in mysql. The
format stored in the database is 13:15:05. The database data type is
time. I'm...
Dave Posh
|
08-15-2004 08:51 PM
steve | 1 | 88 |
|  | say I'm selecting distinct (non-duplicate) rows for insertion,
insert into original_table select distinct * from new_table
these tables have 3 ...
leegold2
|
08-15-2004 08:43 PM
leegold2 | 0 | 98 |
|  | Hi,
I have a log table which contains the fields log_time (DATETIME) and
session_id (VARCHAR). Using these 2 columns I want to be able to SELECT...
Mark Jerzykowski
|
08-15-2004 03:14 PM
Bill Karwin | 2 | 64 |
|  | I read numerous accounts about how to set ft_min_word_len only which
cannot be done using the SET statement.
The client wants to be able to use a...
Phil Powell
|
08-15-2004 02:41 PM
steve | 1 | 97 |
|  | Sorry if this has been gone over before, but I checked google groups and I
couldn't find anything.
Does anyone here have any idea when 4.1.x will be...
Arc
|
08-15-2004 01:34 PM
Bill Karwin | 1 | 73 |
|  | I'm running FreeBSD 4.10 stable with mysql 5.0.0-alpha.
If I type "ps auxwww | grep mysqld"
mysql 180 0.0 2.6 44220 13688 ?? S 11:53AM ...
Roger Lord
|
08-15-2004 12:53 PM
Bill Karwin | 1 | 92 |
|  | Hello everyone,
I would like to thank everyone with their sincere efforts in keeping a
well orgranized mailing list. I have a question and require...
ghasem
|
08-14-2004 11:19 PM
ghasem | 0 | 86 |
|  | Greetings to all from the corner or Asia - guess where Iran!
Going directly to the point, I need to know how can we match a
pattern only...
ghasem
|
08-14-2004 11:12 PM
ghasem | 4 | 75 |
|  | I have a slackware 10 box with mysql 4.0.20. I have just started learning to
use mysql.
I have used the medium file for my my.cnf file and have...
Tommy Martin
|
08-14-2004 10:48 PM
Tommy Martin | 0 | 78 |
|  | (MONEY TRANSACTION)
Hello,
My name is Dr.Bala Mohammed, and I work in the
international operation
department in a Local Bank here in South...
bala mohammed
|
08-14-2004 01:28 PM
bala mohammed | 0 | 117 |
|  | Hi,
I am continualy receiving the following type of error in my browser
from programs using php/mysql
Warning: mysql_connect(): Can't create a new...
Justin
|
08-14-2004 03:53 AM
Justin | 0 | 137 |
|  | This query is running REAL slow ... like 1.2 secs ... any ideas on how
I could optimize it? Perhaps my indexes are incorrect?
$this->query =...
ensnare
|
08-13-2004 11:59 PM
steve | 2 | 89 |
|  | "JStrummer" wrote:
But phpmyadmin can import tab delimited files, so I don’t see the need
for what you asking for.
--
http://www.dbForumz.com/ ...
steve
|
08-13-2004 11:48 PM
steve | 0 | 83 |
|  | JStrummer wrote:
One solution would be to update rather than insert, when a duplicate
exists. There seem to be two ways to do this with MySQL...
Bill Karwin
|
08-13-2004 02:44 PM
Bill Karwin | 0 | 82 |
|  | Hi,
I am using the 'binary flag' principle for defining (multiple) modes for an
element..
Elements table:
id name flags
1 ...
Quarco
|
08-13-2004 07:49 AM
Quarco | 0 | 74 |
|  | hi i just tried the sqlite database on my windoz machine with the odbc
driver and it seems fast. i was reading about size limitations for...
joe
|
08-13-2004 12:05 AM
joe | 0 | 89 |
|  | Try out HSQL... fantastic! Fast! and Portible!
http://hsqldb.sourceforge.net/
In Fact I stop using MySQL over HSQlDB.
--
Thanks in...
Lizard
|
08-12-2004 10:01 PM
Al Kolff | 8 | 85 |
|  | John Doherty wrote:
I agree, and in general replication is used for redundancy.
One of the things that redundancy can buy for you is high...
JoeAley2003
|
08-12-2004 05:04 PM
Bill Karwin | 1 | 91 |
|  | I am attempting to build a Bugzilla server on OS X.
All of this is new to me, working with the Perl, MySQL, and Bugzilla,
so I have been
banging my...
packrat
|
08-12-2004 12:50 PM
packrat | 0 | 118 |
|  | I used this php package to install on my system...
PHP 5.0.0 installer - 26 July 2004
(CGI only, packaged as Windows installer to install and...
phpnube
|
08-12-2004 10:22 AM
phpnube | 0 | 99 |
|  | Hello,
I am considering using embedded mysql as a part of my application. I
would like to distribute mysql to my customers which means I need to
buy...
Yair
|
08-12-2004 07:18 AM
Yair | 0 | 108 |
|  | We have many kinds of advertisers in our web service:
1.private
2. companies, of which some are members of local enterpreneur community
3....
Perttu Pulkkinen
|
08-12-2004 12:46 AM
Perttu Pulkkinen | 0 | 77 |
|  | I am porting C code originally written to talk to a SQL Server engine
via ODBC. While many of the differences are mainly annoyances, and I
found work...
Ken Bass
|
08-11-2004 08:16 PM
Ken Bass | 0 | 81 |
|  | Hello there!
I am a bit of a newbee into the mySQL world and I have a question regarding
switching from one DB to another. I have for a couple of...
Massimo Fiorentino
|
08-11-2004 07:36 PM
Massimo Fiorentino | 0 | 79 |