ndb_restore is not restoring users and grants

2012-10-29 Thread Bheemsen Aitha
Hi, I was able to backup my cluster using ndb_mgm and also restore using ndb_restore. However, when everything looks fine after restore, I see that users and grants are not restored. So, does ndb_restore restore all databases including information_schema and mysql databases, plus users and grants?

Re:Dumping drupal databases

2012-10-29 Thread 小刀
You can the the /etc/my.cnf and file the parameter about the data_dir At 2012-10-30 08:24:14,"Tim Johnson" wrote: >I've recently unstalled drupal 7.15 on Mac OS X 10.7. > >I want to back up the mysql data for drupal. >However, I can't locate those databases and tables using MySQL >server or PHPMyA

Dumping drupal databases

2012-10-29 Thread Tim Johnson
I've recently unstalled drupal 7.15 on Mac OS X 10.7. I want to back up the mysql data for drupal. However, I can't locate those databases and tables using MySQL server or PHPMyAdmin, even if I start mysql on port 3307. The drupal mysql datafiles are located at /Applications/drupal-7.15-0/mysql/d

Re: optimize and tmpfiles

2012-10-29 Thread Mogens Melander
On Mon, October 29, 2012 18:11, walter harms wrote: > > > Am 29.10.2012 14:55, schrieb Reindl Harald: >> >> >> Am 29.10.2012 14:54, schrieb walter harms: >>> >>> >>> Am 29.10.2012 13:17, schrieb Reindl Harald: Am 29.10.2012 12:48, schrieb walter harms: > hi list, > does some

Re: name of a database in mysql....

2012-10-29 Thread Pintér Tibor
2012.10.29. 20:59 keltezéssel, FHDATA írta: mysql server 5.1.41 hello Is there a way mysql server can be told to disallow any attempt of creating a database whose name contains certain characters? thanks, make an empty dir in /var/lib/mysql with that name + chmod 000, owner !mysql :) t

name of a database in mysql....

2012-10-29 Thread FHDATA
mysql server 5.1.41 hello Is there a way mysql server can be told to disallow any attempt of creating a database whose name contains certain characters? thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: optimize and tmpfiles

2012-10-29 Thread Reindl Harald
Am 29.10.2012 18:11, schrieb walter harms: >>> Is there a way to restrict the maximum size of those tmpfiles? >> >> you do you imagine restrict them? > > actually i espected a no, but sometimes i have to think positv. think negative and get positive suprprised :-) >> they are as big as the tab

Re: optimize and tmpfiles

2012-10-29 Thread walter harms
Am 29.10.2012 14:55, schrieb Reindl Harald: > > > Am 29.10.2012 14:54, schrieb walter harms: >> >> >> Am 29.10.2012 13:17, schrieb Reindl Harald: >>> >>> >>> Am 29.10.2012 12:48, schrieb walter harms: hi list, does someone know under what circumstances ''optimize tables'' will cr

Re: Unknown database error

2012-10-29 Thread Michael Dykman
The contents of datadir is typically owned by the mysql user and group. Certain attributes on the datadir itself (ls -ld $datadir) can affect the permissions of newly-created files and directories. You need to talk to you sysadmin, with a eye towards doing something like chown -R mysql:mysql

Re: optimize and tmpfiles

2012-10-29 Thread Reindl Harald
Am 29.10.2012 14:54, schrieb walter harms: > > > Am 29.10.2012 13:17, schrieb Reindl Harald: >> >> >> Am 29.10.2012 12:48, schrieb walter harms: >>> hi list, >>> does someone know under what circumstances ''optimize tables'' will >>> create a tmpfile? >> >> under all if it is MyISAM and for "se

Re: optimize and tmpfiles

2012-10-29 Thread walter harms
Am 29.10.2012 13:17, schrieb Reindl Harald: > > > Am 29.10.2012 12:48, schrieb walter harms: >> hi list, >> does someone know under what circumstances ''optimize tables'' will >> create a tmpfile? > > under all if it is MyISAM and for "select id from table order by rand();" too > interesstin

Re: optimize and tmpfiles

2012-10-29 Thread Reindl Harald
Am 29.10.2012 12:48, schrieb walter harms: > hi list, > does someone know under what circumstances ''optimize tables'' will > create a tmpfile? under all if it is MyISAM and for "select id from table order by rand();" too signature.asc Description: OpenPGP digital signature

optimize and tmpfiles

2012-10-29 Thread walter harms
hi list, does someone know under what circumstances ''optimize tables'' will create a tmpfile ? we had a strange case of "out of space" that seems related to an "optimize table" but i was unable to replicate that case exactly as that no tmpfile appeared. (The table has a lot of partitions if that

Unknown database error

2012-10-29 Thread javad bakhshi
Hi, I get an Unknown database error when I am trying to connect to mysql using C API. I have created the database in mysql prompt as root: CREATE DATABASE Lr0; I am pretty sure that the problem is a ownership issue, because when I do ls -l in my datadir I get: [javad64@udbl64 data]$ ls -l tot

Re: Recover dropped database

2012-10-29 Thread spameden
Hi, could your collegue please share steps he taken to recover data? I'd be interested most definetely! Thanks 2012/10/29 Lorenzo Milesi > > That's rough. The only thing I could suggest is try out Percona's > > data recovery tool > > My collegue did some recovery using Percona tools and (suspa

Re: Recover dropped database

2012-10-29 Thread Sharl Jimh Tsin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 于 2012年10月29日 17:18, Lorenzo Milesi 写道: >> That's rough. The only thing I could suggest is try out >> Percona's data recovery tool > > My collegue did some recovery using Percona tools and (suspance...) > recovered 95% of the data! > > Lovely! > > C

Re: Recover dropped database

2012-10-29 Thread Lorenzo Milesi
> That's rough. The only thing I could suggest is try out Percona's > data recovery tool My collegue did some recovery using Percona tools and (suspance...) recovered 95% of the data! Lovely! Ciao. maxxer -- Lorenzo Milesi - lorenzo.mil...@yetopen.it GPG/PGP Key-Id: 0xE704E230 - http://keyse