Benedikt Schackenberg wrote:
You can configure it in the my.cnf file: there you can set the data
directory.
Thanks for the quick reply.
My concern is that setting the data directory puts ALL databases in that
folder. What I plan to do is to put databases in separate folders.
Is that possible?
John Daisley wrote:
MySQL represents each database by means of a database directory located
within the data directory. You can move a database directory to a location
outside the datadirectory and replace it with a symlink.
Thanks for the tip John, esp. the detailed steps to take. It sounds
were to use Innodb, there is NO way to separate the files used
by different databases?
Benedikt Schackenberg wrote:
I think, that will not work with one database daemon. Then you have to
install for every database one daemon ;)
-Ursprüngliche Nachricht-
Von: Foo JH [mailto:jhfoo
Hi all,
I'm using MySQL 5.0 on Windows 2003.
Problem background: We use the same server for different applications.
All the applications share the same server as the database server. Each
application uses their own database. In MSSQL we put each database in
the corresponding application folder
Hi all,
My Windows-based database server crashed (no fault of MySQL. probably OS
or hardware), and I managed to copy out the data files. I am using
version 5.0 of the Essentials package.
I tried to install a similar setup on another server, then copy the
data\ folder over. The MySQL service
be worth trying the following
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
Hi all,
My Windows-based database server crashed (no fault of MySQL.
probably OS or hardware
I've always been a believer in avoiding sql procedures, for the main
reason that I want to be as database-independent as possible. I know it
is less efficient, but being able to switch between MySQL, Postgre, and
the new freebies from IBM, Oracle, and Microsoft is a strong advantage
from the
Hi all,
This is a fundamental concept in RDBMS: the use of foreign keys in
database design.
I'd just like to poll the community here, on whether it is a best
practice, or practically essential to 'link' related tables by use of
foreign keys.
For myself, I usually do all the validity
tony vong wrote:
What is the sql command to export the whole database ?
I use:
mysqldump -u [username] -p[password] [database name] [filename]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
tony vong wrote:
What is the sql command to export the whole database ?
I use:
mysqldump -u [username] -p[password] [database name] [filename]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
the quiz_question and quiz_answer tables, using the foreign
keys in the result table.
I find it helps me to think of foreign keys as unique
pointers to rows in other related tables.
HTH
Keith
In theory, theory and practice are the same;
in practice they are not.
On Mon, 20 Mar 2006, Foo
tables: the original table will hold only enough fields for sorting, and
the huge fields in the other.
What do you guys think?
Ady Wicaksono wrote:
Hi Foo,
MyISAM impress me on insert speed, however on many case MyISAM is not
better than Innodb. If you can't use combination of them,
better your
Hi all,
Just want to share and confirm my findings on a performance issue I've
been experiencing.
My database is strictly non-transactional, but it's got about 200,000
records in this particular table. The table has a primary index, and 2
integers - one for the date and the other for the
hi guys, it's a simple thing (I think), but I can't find the docu on
this from the mysql site.
Thanks in advance for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
15 * * * * /usr/local/mysql/bin/mysql -u root -pxx -e 'FLUSH TABLES'
This would run a FLUSH TABLES once every hour at 15 minutes past. If you
are using Windows, sorry I'm not sure how to do it there.
Easier to just set flush_time=900 in my.cnf :)
Thanks guys. Will give it a
Hi all,
I'd like to clarify on this odd issue. It seems to me that MySQL will
automatically drop database handles, assumably if the handle has not
been used for some time. Is this true? If so, how can I disable timeout?
This is an unexpected behavior, because I have tried MSSQL and Postgre,
Hi all,
I have a MySQL server servng low-load applications. Problem is, the
environment is sometimes unstable, leading the entire OS to crash. I
notice that even in low-load situations the MySQL tables can be
corrupted during crashes.
My question is: is there a way for MySQL to flush when
Heikki Tuuri wrote:
Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would
survive an OS crash without a problem.
Thanks for the reply Heikki. Let me rephrase my problem: the data
remains intact, but I suspect the indexes are corrupted. Basically I
have to run
Hi Everyone,
I've been Googling unsuccessfully for specific issues
relating to queries run on MySQL version 4.0.16
against tmp tables. I have witnessed several
occurrences where queries running on various platforms
hang in a Copying to tmp table state for hours or
days at a time. When the same
, and
the number of rows in the table. A dump of 'show
variables;' would be
helpful too.
On Wed, 2004-11-10 at 21:44, foo bar wrote:
Hi Everyone,
I've been Googling unsuccessfully for specific
issues
relating to queries run on MySQL version 4.0.16
against tmp tables. I have
the tmp table in memory and
get stuck they way
you've described - although I must admit I'm not
sure what mysql does in
a situation where tmp_table_size is too large.
How much RAM does the machine have? Can you check
swap activity?
On Thu, 2004-11-11 at 00:27, foo bar wrote:
Here's
My application cannot connect to the database and
perform SQL qurey after usuualy after a day.
I heard that mysql automatically close connection
after 8 hrs of inactivity.
Hope u can email me how to prevent the auto closing or
any alternative method. Thanks in advance!
i tried to catch the exception and recoonect to MySQL
server and it
dose not work, i also tried open and closing the
connection only when i need it and that does not work
too so i had to resort to not this alternative. anyway
thanks fr your solution.. and how to make disable auto
closing
But my program works fine and all those java code i
used to connect to mysql is what i have been taught by
my lecturer it works fine..only things is that i never
leave my application up for more than a day and that
when i discover this problem.
Usually i restart tomcat and it works again but the
Hi,
I have a mysql table with columns pts_t2, pts_ext and pts_other which hold
each player's point total for that category. I have it displaying player's
ranks by ordering by each of those points. However, I would like to have an
overall ranking (all categories combined), and I don't want to add
Try running safe_mysqld, this should generate the sock file.
I came across the same issue when I installed mysql. Check and see if mysql
(as a user) has access to the mysql directory. You might want to do a
chown -R mysql:mysql {mysql dir}
to change the permissions for the mysql dir
this to the mailing list.
Regards,
Shem Foo
-
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
I have mysql-server-3.23.22.6 and mysql-3.23.22.6, packages
installed on my PC during Linux RedHat 7.0 installation.
The problem occurs when starting mysqld program :
The command :
mysql install db
is OK
but the command :
safe mysqld
starts the server mysqld witch stops immediately after.
When
28 matches
Mail list logo