AW: creating databases in different folders

You can configure it in the my.cnf file: there you can set the data directory. -Ursprüngliche Nachricht- Von: Foo JH [mailto:jhfoo...@extracktor.com] Gesendet: Dienstag, 2. Juni 2009 05:00 An: mysql@lists.mysql.com Betreff: creating databases in different folders Hi all, I'm using

Re: AW: creating databases in different folders

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?

Re: AW: creating databases in different folders

Hi, 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

AW: AW: creating databases in different folders

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...@extracktor.com] Gesendet: Dienstag, 2. Juni 2009 11:49 An: schackenb...@termindoc.de Cc: mysql@lists.mysql.com Betreff:

Re: AW: creating databases in different folders

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. Moving a database directory is very simple. Just follow these steps. (I think you said you

Re: creating databases in different folders

You might try and hack something together using NTFS juction points. Unadvisable though, and probably unsupported. Walter On Mon, Jun 1, 2009 at 9:00 PM, Foo JH jhfoo...@extracktor.com wrote: Hi all, I'm using MySQL 5.0 on Windows 2003. Problem background: We use the same server for

Re: AW: creating databases in different folders

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

RE: AW: AW: creating databases in different folders

Guten Tag http://dev.mysql.com/doc/refman/5.0/en/recovery-from-backups.html Das heißt, können wir den Bediener mit a anstellen --Maschinenbordbuchsortierfach Wahl, die eine Position auf einer anderen körperlichen Vorrichtung von der spezifiziert, auf der das Datenverzeichnis liegt. So, die

Re: AW: AW: creating databases in different folders

From the sound of things, apart from using symbolic links, all MySQL databases MUST reside within the same data root folder. Some further questions: 1. On the *NIX, *BSD platform, do you guys locate the databases in diff folders and link it back to the data root on production systems? 2. If I

RE: AW: creating databases in different folders

-Original Message- From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] Sent: Tuesday, June 02, 2009 6:30 AM To: Foo JH Cc: schackenb...@termindoc.de; mysql@lists.mysql.com Subject: Re: AW: creating databases in different folders MySQL represents each database by means of a

RE: AW: creating databases in different folders

-Original Message- From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] Sent: Tuesday, June 02, 2009 6:30 AM To: Foo JH Cc: schackenb...@termindoc.de; mysql@lists.mysql.com Subject: Re: AW: creating databases in different folders MySQL represents each database by means of a

AW: AW: creating databases in different folders

Thx john !! i can use this :) -Ursprüngliche Nachricht- Von: John Daisley [mailto:john.dais...@mypostoffice.co.uk] Gesendet: Dienstag, 2. Juni 2009 17:10 An: Jerry Schwartz Cc: john.dais...@butterflysystems.co.uk; 'Foo JH'; schackenb...@termindoc.de; mysql@lists.mysql.com Betreff: RE:

Question about query - can this be done?

Hello, I've tried the manual and google, but I am not even sure what to call what I want to do. simplified data example: I have a table of start and end times for an event, and an id for that event in a table. each event may occur multiple times, but never more than 5 times and rarely more

MySQL University session on June 4: Boosting Performance With MySQL 5.1 Partitioning

Boosting Performance With MySQL 5.1 Partitioning http://forge.mysql.com/wiki/Boosting_Performance_With_MySQL_5.1_Partitioning This Thursday (June 4th, 14:00 UTC), Giuseppe Maxia will give a MySQL University session on Boosting Performance With MySQL 5.1 Partitioning. Giuseppe is leading the

Re: Question about query - can this be done?

On Tue, Jun 2, 2009 at 11:52 AM, Ray r...@stilltech.net wrote: Hello, I've tried the manual and google, but I am not even sure what to call what I want to do. simplified data example: I have a table of start and end times for an event, and an id for that event in a table. each event may

Re: Question about query - can this be done?

Ray, I want a query that will provide one record per event with all times included. feel free to answer RTFM or STFW as long as you provide the manual section or key words. ;) Can be done with a pivot table. Examples under Pivot tables at

RE: AW: creating databases in different folders

[JS] So far as I know, Windows supports mount points but not symbolic links. You are correct Jerry, Windows does not support symbolic links but for MySQL purposes you can create an .sym file containing the full path to the new location and MySQL will read the file and look in the specified path

Mysql 4.1 vs 5.0

Benching Somebody knows why 4.1 is faster than 5.0 mysql versions Ing. Jaime Fuentes R. 997500459 2421905-2423252 Enviado desde mi BlackBerry de Claro. -Original Message- From: Brent Baisley brentt...@gmail.com Date: Tue, 2 Jun 2009 12:32:39 To: Rayr...@stilltech.net Cc:

Replication problems: slave fails to update

I'm trying to resolve a frustrating replication problem with my databases. The master contains a number of schema, only using Innodb tables. Updates happen regularly, usually using bulk inserts of the form INSERT ... ON DUPLICATE UPDATE. Data is mostly numbers. The missing queries contain no

Re: Question about query - can this be done?

On June 2, 2009 10:44:48 am Peter Brawley wrote: Ray, I want a query that will provide one record per event with all times included. feel free to answer RTFM or STFW as long as you provide the manual section or key words. ;) Can be done with a pivot table. Examples under Pivot tables at

Re: Question about query - can this be done?

On June 2, 2009 03:14:36 pm Ray wrote: On June 2, 2009 10:44:48 am Peter Brawley wrote: Ray, I want a query that will provide one record per event with all times included. feel free to answer RTFM or STFW as long as you provide the manual section or key words. ;) Can be done

RE: Question about query - can this be done?

Ray, You can use the results of a query in a join with something like: select tmp.id, t1.id from (some_query_selecting_id) as tmp join t1 on t1.id=tmp.id Hope that helps. Regards, Nathan Sullivan -Original Message- From: Ray [mailto:r...@stilltech.net] Sent: Tuesday, June 02, 2009

[solved]Re: Question about query - can this be done?

On June 2, 2009 04:13:31 pm Nathan Sullivan wrote: Ray, You can use the results of a query in a join with something like: select tmp.id, t1.id from (some_query_selecting_id) as tmp join t1 on t1.id=tmp.id Hope that helps. Regards, Nathan Sullivan Thanks Nathan, I think that

Why doesn't mySQL stop a query when the browser tab is closedL

I just noticed a horrible thing. I have a query (report) that can take 15 minutes or more to generate with mySQL. We have 500 Million rows. This used to be done in real time when we had less rows, but recently we got a big dump of data that shot it up. So, noticing via myTop the query taking

Finding the creation date of an existing database in MySQL 5?

Hi all ! Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0 or newer versions? Thanks, Uma

Re: Finding the creation date of an existing database in MySQL 5?

Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0 or newer versions? information_schema.tables.create_time for tables. PB Uma Bhat wrote: Hi all ! Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0 or

binlog questions

We outputted the bin log using the following command: mysqlbinlog -v --base64-output=DECODE-ROWS oo-mysql1-bin.87 We then looked in this file and found some odd things. For example there is the below insert statement: ### INSERT INTO panel.history ### SET ### @1=-182667600 (4112299696)

Re: Finding the creation date of an existing database in MySQL 5?

Thanks for the response, Peter. Yeah, I am aware of this to find it for the tables. However I require to find the creation time of a database.. Thanks, Uma On 6/3/09, Peter Brawley peter.braw...@earthlink.net wrote: Is there any method to find the CREATION DATE of an EXISTING

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread,