Re: defaults in MySQL

2003-03-19 Thread Barry Marler 
/etc/my.cnf: Global options
DATADIR/my.cnf: Server-specific options
defaults-extra-file: The file specified with --defaults-extra-file=#
~/.my.cnf: User-specific options
By default, data is in /var/lib/mysql.

Jon Miller wrote:
Can someone tell me how do I find the default settings in MySQL.  Mainly
I'm interested in knowing where are the data files stored.  I'm building
a application server (RH7.3) and need to know which partition should be
sized to handle the database.
--
Barry Marler
Plant Genome Mapping Laboratory
University of Georgia
Room 229, CAGT
111 Riverbend Road
Athens, GA 30602
706.583.0164
706.583.8120[fax]
http://www.plantgenome.uga.edu
-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: AW: EMS MySQL Manager for Linux 1.15 released!

2003-03-17 Thread Barry Marler 
I second that.

Rusch (ext) Reiner wrote:
Hi,

is anyone interested in commercial use/spam of this list?
If not, I would prefer to throw them out of the list.
Regards,
Reiner

-Ursprungliche Nachricht-
Von: EMS HiTech Team [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 17. Marz 2003 17:05
An: [EMAIL PROTECTED]
Betreff: EMS MySQL Manager for Linux 1.15 released!
EMS HiTech company is very glad to announce MySQL Manager for 
Linux 1.15 --
the next version of our powerful MySQL administration and 
development tool!

You can download the latest version and user's guide from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.15?

1. Export Data Dialog: export to PDF added. Now you can 
export data to one
of the most popular document formats as well as to the other supported
formats.

2. Export Data Dialog - export to HTML: a possibility of customizing
navigation links for multi-file export and a possibility to define a
background picture for the result table added.
3. Import Data Wizard: import modes are implemented - now you 
can define an
action to be executed with the concurrent records in the 
source file and the
target table. You can either update these records, delete 
them, insert only
new records, and more. For these purpose you should define 
key columns as
primary key.

4. Import Data Wizard: added a possibility of defining a way 
to add data to
the destination table - insert or append.

5. Several small improvements and minor bugfixes.

What is MySQL Manager?

EMS MySQL Manager provides powerful tools for MySQL Server 
administration
and object management. Its Graphical User Interface (GUI) 
allows you to
create/edit all MySQL database objects in a simple and direct 
way, run SQL
scripts, manage users and administer user privileges, 
extract, print, and
search metadata, create database structure reports in HTML format,
export/import data, and supplies many more services that will 
make your work
with the MySQL server as easy as it can be...

Don't forget to check out other our products:

http://www.ems-hitech.com/sqlmanagers
Powerful database administration tools for 
InterBase/FireBird, MySQL and
PostgreSQL servers

http://www.ems-hitech.com/sqlutils/
Cross-platform data management utilities
http://www.ems-hitech.com/components/
Powerful components for Delphi/C++ Builder developers
We hope you'll like our products.
Thank you for your attention.
Best Regards,
EMS HiTech Team
http://www.ems-hitech.com


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


--
Barry Marler
Plant Genome Mapping Laboratory
University of Georgia
Room 229, Center for Applied Genetics Technology
111 Riverbend Road
Athens, GA 30602
706.583.0164[office]
706.583.0160[fax]
http://www.plantgenome.uga.edu
-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin

2003-03-08 Thread Barry Marler 
Open http://your.server.name/phpMyAdmin-2.*.*/Documentation.html#setup.  If
you read the docs (#3 in the initial Quick Install section tells you that
the file you'll be editing is config.inc.php, in the phpMyAdmin root dir),
you'll just be stepped through a simple series of table creations and
editing of config.inc.php (which is trivial). 

-- 
Barry Marler
Plant Genome Mapping Laboratory
University of Georgia
Room 229, C A G T
111 Riverbend Road
Athens, GA 30602
(706)583-0164(office)
(706)583-0160(fax)
http://www.plantgenome.uga.edu 


-Original Message-
From: Stephen Tiano [mailto:[EMAIL PROTECTED] 
Sent: Saturday, March 08, 2003 3:29 PM
To: [EMAIL PROTECTED]
Subject: phpMyAdmin



Anyone familiar with the GUI interface for MySQL/PHP called 'phpMyAdmin'?

I'm at a point in my intensive self-study via books, tutorials, and 
exercises where one of the books I'm working with--trying to tie 
together with my graphical HTML editor--Dreamweaver: PHP 
Development--suggests phpMyAdmin is worth knowing as a tool for more 
efficient work in a production environment.

When I get phpMyAdmin to show up in my browser, it looks pretty much the 
way the book shows it. Except that, after a few lines that are 
word-for-word with the book, in place of

   [bullet] Run SQL query/queries on ...

and a flexible field in which to type in said queries, I have an error 
message:

   [bullet] Error
The additional Features for working with linked Tables have 
been deactivated.
To find out why, click here.

Clicking 'here' brings me to a link to 'Documentation' and a line 
underneath saying 'General relation features Disabled'. Clicking on 
'Documentation' brings me to what looks vaguely like directions for 
altering various '$cfg' strings.

Needless to say, I'm leery. I'm not certain where to find these strings 
to alter. But more importantly, I'm not clear on what I'm being told to 
do. It's not as if the directions are step-by-step for a novice. And it 
doesn't spell out whether this will address the 'General features' being 
'Disabled'. That is, will it make these 'General features' functional?

May I ask your help in doping this out?

Thank you.

Steve Tiano


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php