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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
-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
> 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
17 matches
Mail list logo