Dear all,
Benetl, a free ETL tool for files now using MySQL is out in version 3.0.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load
Thanks for your interest.
Regards,
--
Benoît Carpentier
www.benetl.
Thanks for the tips, all. Looks like we've got it restored
via --skip-grant-tables and restoring some missing user rows
(which caused me not to be able to see DBs in 'show databases').
I was also confused about being able to load an empty string ''
into the non-null mysql.user.password field.
Hi Johnny,
Thanks you so much!
Your command fixed the problem beautifully. Now, MySQL can start
successfully. I can create and drop databases without problem. Thanks again.
Best,
Jia
Johnny Withers wrote:
I'm at work now, this is the cmd I used:
chcon -R -u system_u -r object_r -t mysql_d
I'm at work now, this is the cmd I used:
chcon -R -u system_u -r object_r -t mysql_db_t /data
(my data lives in /data/mysqlXX -- were XX is the server version)
On Wed, Aug 26, 2009 at 8:02 AM, Johnny Withers wrote:
> Yes, error 13, permission denied. Check selinux setup. I had this same
> proble
According to this page in the MySQL 5.0 Manual:
http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html
-
mysql_upgrade executes the following commands to check and repair tables and to
upgrade the system tables:
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql < [fix_priv_tables]
>-Original Message-
>From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
>Sent: Wednesday, August 26, 2009 5:08 AM
>To: mysql@lists.mysql.com
>Cc: bharani kumar
>Subject: Re: Hi Query Optimization steps
>
>Hi!
>
>
>bharani kumar wrote:
>> Then which DB engine is better.
>>
>
>Whi
Yes, error 13, permission denied. Check selinux setup. I had this same
problem last week on a CentOS machine. I had to change the object type
of the new data dir to mysqld-something. I'm on a mobile phone and
can't remember the exact cmd.
On Tuesday, August 25, 2009, Jia Chen wrote:
> I run sudo
Hello All,
I'm in the process of upgrading my database from 4.1 to 5.0 on CentOS.
I've been testing the "mysqlcheck --check-upgrade --auto-repair" command,
and on one of my MYISAM tables, it's taking forever to upgrade the table.
It has about 114 million rows, and I'm guessing it needs to be
Step # 1 : Stop mysql service
# /etc/init.d/mysql stop
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Step # 3: Connect to mysql server using mysql client:
# mysql -u root
Step # 4: Setup new MySQL root user password
mysql> use mysql;
mysql> update user set pas
Hi!
bharani kumar wrote:
> Then which DB engine is better.
>
Which fruit is better, an apple or a banana?
And if X is better, why do farmers still grow Y, and why do people buy it?
More serious:
Different engines offer different features, as described in the manual.
The most obvious diff
I actually get the feeling you are not connecting as root.
Try mysql -uroot -p test instead of just mysql test
Have a nice day,
- Martijn
On Wed, Aug 26, 2009 at 03:02, Joe wrote:
> OK, thanks, that got me in. But upon inspection, the user.host
> values do not look fouled up as I thought they w
Log in as root and run:
set password = '';
OR
update mysql.user set Password='' where User='root';
this is TOTALLY INSECURE but if that's what you want, then it should do the
trick.
Regards,
Darren Cassar
www.mysqlpreacher.com
www.securich.com
On Wed, Aug 26, 2009 at 2:33 AM, Joe wrote:
> I'
12 matches
Mail list logo
