hello, you can not simultaneously fix two deamons to a data directory. a
mysql daemon always has exclusive access to the data directory.
Am 10.06.2010 07:09, schrieb camelia botez:
and use
the same data bas
--
SP data GmbH
T 06131 218111
F 06131 218112
E schackenb...@termindoc.de
W
Yups. If you want to have two active servers, you'll need to set up
master-master replication and give each server it's own datastore. Note that
there's a load of caveats if you want to write to both servers, though -
read up on the documentation.
2010/6/10 Benedikt Schackenberg
Am 08.06.10 12:05, schrieb Rob Wultsch:
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
goetz.reini...@filmakademie.de wrote:
Hi,
we do have different LAMP systems and recently I started to put some
mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
On Thu, Jun 10, 2010 at 07:09, camelia botez
camelia.bo...@weizmann.ac.il wrote:
What can be done to run on both servers mysqld simultaneously and use the
same data base?
You are probably asking the wrong question here. Let's take a step
back and ask you another question: What is it you want to
Hi!
camelia botez wrote:
We have 2 mysql servers - one active , second standby.
The data base is on nsf storage file system mounted on the active server.
We want to turn on active the second server and to be able to use both
servers with the same nfs mounted data base.
NFS may be good for
Hi all!
Götz Reinicke - IT-Koordinator wrote:
Am 08.06.10 12:05, schrieb Rob Wultsch:
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
goetz.reini...@filmakademie.de wrote:
Hi,
we do have different LAMP systems and recently I started to put some
mysql databases on one, new
On Thu, Jun 10, 2010 at 10:27 AM, Joerg Bruehe joerg.bru...@sun.com wrote:
| There may be some merit to this in a specialized setup (SAN systems -
| I'm not convinced of them, but don't claim expert knowledge about them),
As a slight aside, I'd like to offer you two major advantages of SAN
I am looking for some guidance on creating a substring query. I have
a column that stores a path to a file. I would like to extract that
file extension and that is it and display it on my results. However,
the paths are different lengths and some extensions are 3 letter and
some are 4, eq
[snip]
I am looking for some guidance on creating a substring query. I have
a column that stores a path to a file. I would like to extract that
file extension and that is it and display it on my results. However,
the paths are different lengths and some extensions are 3 letter and
some are 4,
On 10/06/2010 16:55, Aaron Savage wrote:
I am looking for some guidance on creating a substring query. I have
a column that stores a path to a file. I would like to extract that
file extension and that is it and display it on my results. However,
the paths are different lengths and some
Thanks Guys for you insights.
It may be a little more complicated then I made it out to be.
I have tried this select substring_index(myfiled,'.',-2) from mytable.
This has gotten me to a good starting point.
But I still have two problems. After the extension there is a space
and more wording.
[snip]
It may be a little more complicated then I made it out to be.
I am just trying to pull out the file extension but there were some
conditions I did not list.
[/snip]
Thank you for that update, would have been good to have from the start.
SELECT SUBSTRING_INDEX('my.doc','.',-1)
--
MySQL
Sorry Jay,
Here is what I came up with.
select substring(substring_index(myfile,'.',-2),1,4) AS MyColumn from
mydatabase group by MyColumn;
That appears to yield what I need. I just need to filter out the
results that do not have an extension.
-Aaron
On Thu, Jun 10, 2010 at 9:28 AM, Jay
[snip]
Here is what I came up with.
select substring(substring_index(myfile,'.',-2),1,4) AS MyColumn from
mydatabase group by MyColumn;
That appears to yield what I need. I just need to filter out the
results that do not have an extension.
[/snip]
You can exclude results that do not have a
I'm trying to create a database, using code generated by MySQL Workbench
5.2.21 RC. I'm running into this strange issue:
ERROR 1005 (HY000): Can't create table 'nxdb.#sql-a6_3b' (errno: 150)
Database was created using utf8 as charset, collation utf8_general_ci.
Original code generated by
You can use an Alias in ORDER BY but not in WHERE clauses.
Keith
On Thu, 2010-06-10 at 16:38 -0400, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT CONCAT(`phone_pref`, '-', `phone_suff`) FROM `pnums`
WHERE `id`=`usertable`.`id`) AS pnum FROM `usertable` WHERE pnum LIKE
On 6/10/2010 4:38 PM, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT CONCAT(`phone_pref`, '-', `phone_suff`) FROM `pnums`
WHERE `id`=`usertable`.`id`) AS
On 6/10/2010 6:38 PM, Lola Lee Beno wrote:
I'm trying to create a database, using code generated by MySQL Workbench
5.2.21 RC. I'm running into this strange issue:
ERROR 1005 (HY000): Can't create table 'nxdb.#sql-a6_3b' (errno: 150)
Database was created using utf8 as charset, collation
Hello all,
I am new to MySQL and am exploring the possibility of using it for my work.
I have about ~300,000 e-books, each about 100 pages long. I am first going
to extract each chapter from each e-book and then basically store an e-book
as a collection of chapters. A chapter could of course be
On 6/10/2010 10:16 PM, Andy wrote:
Hello all,
I am new to MySQL and am exploring the possibility of using it for my work.
I have about ~300,000 e-books, each about 100 pages long. I am first going
to extract each chapter from each e-book and then basically store an e-book
as a collection of
Usually, you better use a NAS for such purpose. Database is designed
to store highly transactional, record oriented storage that needs fast
access... You can look for any Enterprise content management systems
that rest its storage on a scalable NAS, with file virtualization in
the long run.
22 matches
Mail list logo