mysqldump: Error 5: Out of memory

2008-10-01 Thread Uma Bhat
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:

RE: Deployment of Database in a DEB package.

2008-10-01 Thread Ellison, David
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 -p etc < yourinsertsql.sql Essentially the username w

Re: LOAD - failure for a non-admin user

2008-10-01 Thread Werner D.
Reyna.Sabina schrieb: > Hi, > > I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64). > > I created a new database called HYDRO (user: admin). I created a new user > called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password. > User 'hydro' has given all provileges except the ' Gr

Re: LOAD - failure for a non-admin user

2008-10-01 Thread Olaf Stein
The user needs to file privilege" to "load data infile" which is a global privilege, not database bound I assume you created hydro like this: Grant all on hydro.* to [EMAIL PROTECTED] ... If you do a: >use mysql; >select * from db; You will see that the file priv is not a part of that permissi

LOAD - failure for a non-admin user

2008-10-01 Thread Reyna.Sabina
Hi, I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64). I created a new database called HYDRO (user: admin). I created a new user called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password. User 'hydro' has given all provileges except the ' Grant_priv'. As user 'hydro', I can d

MySQL University session on October 2: Checking Performance with KCacheGrind

2008-10-01 Thread Stefan Hinz
Hi, This Thursday, Stewart Smith will give a MySQL University session: http://forge.mysql.com/wiki/Checking_Performance_with_Kchachegrind (topic: Checking Performance with KCacheGrind) *** Note that this particular session starts 9:00 BST / 10:00 CET / 18:00 Brisbane/Melbourne *** Please regist

Deployment of Database in a DEB package.

2008-10-01 Thread Heston James - Cold Beans
Afternoon All, I'm hoping you'll have some recommendations for me on this little challenge. I have an application which we're preparing to deploy in a DEB package using APT on Debian based systems, although I would imagine this very same rule/process applies to other packaging methods. On t