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 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 so that the application root folder contains everything (including the database). Now we're trying to do the same for MySQL as well, but I'm not sure how I can specify that a database should be created in a particular directory (and it's almost always not in C:\Program Files\MySQL Server). Can anyone advise? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=schackenb...@termindoc.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 possible? If you don't use InnoDB, then a database IS a folder. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=schackenb...@termindoc.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 were using windows, if you are using *nix give me a shout back, the procedure is different.) 1. Stop the server 2. Move the database directory from the data directory to its new location 3. In the data directory create a file that has a name that is the same as the database name with an extension of .sym This file should contain the full pathname to the database directory location. 4. Restart the server ensuring the --skip-symbolic-links option is not used. Hope this is what you are after. Let me know how much success yoou have with this on Windows. We use symlinking on Linux to distribute load but I have never tried it on Windows. Regards John Daisley MySQL 5 Certified Database Administrator (CMDBA) MySQL 5 Certified Developer (CMDEV) MySQL Certified Associate (CMA) Telephone +44 (0)1283 537111 Mobile +44 (0)7812 451238 Email john.dais...@butterflysystems.co.uk 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 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 so that the application root folder contains everything (including the database). Now we're trying to do the same for MySQL as well, but I'm not sure how I can specify that a database should be created in a particular directory (and it's almost always not in C:\Program Files\MySQL Server). Can anyone advise? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck, Consultant @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 scary (I did some reading and there's some concerns about deleting stuff via Windows Explorer), but I'd give it a shot and update you on the success. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 Maschinenbordbücher sind sicher, selbst wenn die Vorrichtung, die das Verzeichnis enthält, verloren ist. arbeitet dieses nicht für Nichtdämon? (raten Sie bitte) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. From: schackenb...@termindoc.de To: jhfoo...@extracktor.com CC: mysql@lists.mysql.com Subject: AW: AW: creating databases in different folders Date: Tue, 2 Jun 2009 12:15:31 +0200 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 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=schackenb...@termindoc.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Windows Live™ SkyDrive™: Get 25 GB of free online storage. http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009
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 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...@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 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 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 were using windows, if you are using *nix give me a shout back, the procedure is different.) [JS] So far as I know, Windows supports mount points but not symbolic links. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 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 were using windows, if you are using *nix give me a shout back, the procedure is different.) [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 for the database files. The procedure is covered in the documentation here http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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: 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 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 were using windows, if you are using *nix give me a shout back, the procedure is different.) [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 for the database files. The procedure is covered in the documentation here http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=schackenb...@termindoc.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 for the database files. [JS] That's great to know, I've never needed that ability so I never looked into it. I suppose I'll promptly forget it, but you never know what will stick. The procedure is covered in the documentation here http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
creating databases in different folders
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 so that the application root folder contains everything (including the database). Now we're trying to do the same for MySQL as well, but I'm not sure how I can specify that a database should be created in a particular directory (and it's almost always not in C:\Program Files\MySQL Server). Can anyone advise? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org