I know nothing of DEB packages. However, when we need to change / make a
database etc on automatic scripts. We would write the script and save it
to a .sql file on console. We would then create a shell script that had
something like:
mysql -u username -p etc yourinsertsql.sql
Essentially the
Hey Guys!
I have been googling a lot on this error and read various suggestions. But
havnt found an appropriate solution yet.
I get this error while taking mysqldump of an InnoDB table (say mytable)
mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping
table `mytable` at row:
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 suggestions.
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
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
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