I am running MySQL 5.1.30 on AIX 5.3. When a table reaches 1GB the table
gets marked as corrupt. Is there a setting that limits table size to 1GB?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.or
: Loaded 0 events
090127 19:16:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306
MySQL Community Server (GPL) by Remi
Cool. Now Amarok2 cannot continue to bitch at me, but I will try Songbird.
Cheers,
J
pgrade
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 3:21 AM, JD wrote:
OK, I located a weblog on how to change the password
and it worked.
I then stopped and started the serever, and this is what it b
port * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 1:47 AM, JD wrote:
I did the chmod. Then
# ls -latrR /var/lib/mysql
/var/lib/mysql:
total 20548K
drwxrwxr-x 2 mysql mysql 4096 2007-12-15 15:36 test/
-rw-rw-r-- 1 mysql mysql 5242880 2007-12-15 15:36 i
306
MySQL Community Server (GPL) by Remi
Claudio Nanni wrote:
Hi JD,
just try a simple thing,
rm /var/lib/mysql/ib_logfile1
rm /var/lib/mysql/ib_logfile2
to remove the innodb log files, sometimes you can have this problems,
did you copy the database between servers?
where are the .pid and .er
ur iblogfile0 and iblogfile1 files..
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Wed, Jan 28, 2009 at 12:48 AM, JD wrote:
ls -altr /var/lib/mysql
wrote:
JD,
please post the ouput from:
ls -altr /var/lib/mysql
thanks
Claudio
JD wrote:
Deamon runs as root.
ls -ld /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/
So what other perms does root need?
Andy Shellam wrote:
Hi JD,
I believe the error about
Deamon runs as root.
ls -ld /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/
So what other perms does root need?
Andy Shellam wrote:
Hi JD,
I believe the error about mysql.plugin is a red herring - it needs
fixing, but it's not the reason MySQL isn'
09:33:41 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090121 9:33:41 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
So, how are ibdata1 and mysql.plugin a
7
postgresql-server-8.2.9-1.fc7
mono-data-sqlite-1.2.3-5.fc7
mysql-devel-5.1.30-1.fc7.remi
mysqlclient15-devel-5.0.67-1.fc7.remi
mod_auth_pgsql-2.0.3-3
mysql-connector-odbc-3.51.12-2.2
libdbi-dbd-mysql-0.8.1a-2.fc7
mysqlclient15-devel-5.0.67-1.fc7.remi
php-mysql-5.2.8-1.fc7.remi
Cheers,
JD
--
MySQ
Basically the problem is only the ownership and it has to be owned by
mysql. The problem is indeed there, how to chown or chmod those data so
it can be owned by mysql.
JD
Alex Shi wrote:
Hi,
I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory
is /var/lib/mysql/. For
or Linux, my data can always be
intact...:)
BTW..., if one tries this way too, please inform the success/failure.
JD
> JD,
>
> my answer may seem ridiculous, too, but with the following setup you
> should be able to use MySQL databases and tables both under Linux and
owner to mysql;
- change the /etc/my.cnf
Well, does somebody out there do something like this already?
Thank you.
JD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
;75000
It seems as soon as it hits the first OR condition, it ignores the AND
condition. I was hoping the brackets would help, but it doesn't seem to
matter. It works fine as long as I stick to AND. The numbers are the id for
area types in another table that link to the listings table. How el
14 matches
Mail list logo
