RE: Deployment of Database in a DEB package.

2008-10-02 Thread Ellison, David
That's true, you would need to consider that risk. Can a DEB package ask for information before deployment? If so you could ask for the username/password and run the mysql command using the provided info. Therefore not risking the problem of having a username/password within the files. Although

Views and replication

2008-10-02 Thread Olaf Stein
Hi all, In my master/salve setup the only database I do not replicate is mysql. The slave has only the users absolutely necessary to select and administer, that is why a lot of the users I have on the master are not there. When I create a view on the master the definer is set to the user I am log

Re: Deployment of Database in a DEB package.

2008-10-02 Thread Andre Matos
Just be aware about the security. I use shell or perl scripts to make automatic dumps (backups) or updates/changes in the database. Unfortunately, because they are automatic scripts, I need to add the username and password inside the scripts and if someone else have access to these scripts

RE: Deployment of Database in a DEB package.

2008-10-02 Thread Heston James - Cold Beans
Dave, This looks like a perfect solution. We can indeed use a shell script for the task in hand and knowing that we an action the .sql script so simply from the command line like that makes life very simple indeed :-) I can't see this will cause too many challenges. Thanks Dave, I appreciate it

Re: mysqldump: Error 5: Out of memory

2008-10-02 Thread Krishna Chandra Prajapati
Hi, Just try the below command on console. It will give that the error is exactly related to what. $perror 5 What is total ram in your box. On Thu, Oct 2, 2008 at 12:26 PM, Uma Bhat <[EMAIL PROTECTED]> wrote: > Hey Guys! > > I have been googling a lot on this error and read various suggestion