Hello guys
Here is the problem. You may find it trivial, but it is a serious
obstacle for me. I make a database, a table in mysql and it goes fine.
Then I try to view my table with PHP. I am pretty sure that I can't
connect to the database.
In particular "$db = mysql_connect("localhost", "root",
Evgeny,
Tuesday, May 28, 2002, 12:23:58 PM, you wrote:
>>> When try to use BACKUP TABLE, i get an error
>>> 'Failed copying .frm file: errno = 2' in the result table.
>>> What's the problem?
RC>> BACKUP TABLE write files with the user MySQLd is running...
RC>> So if your deamon run as mysql, you
RC> On mardi, mai 28, 2002, at 09:35 , Evgeny Chuykov wrote:
>> When try to use BACKUP TABLE, i get an error
>> 'Failed copying .frm file: errno = 2' in the result table.
>> What's the problem?
Sorry, my stupid mistake. As you said there was problems whith rights
and dir 'test' didn't exists in
>> When try to use BACKUP TABLE, i get an error
>> 'Failed copying .frm file: errno = 2' in the result table.
>> What's the problem?
RC> BACKUP TABLE write files with the user MySQLd is running...
RC> So if your deamon run as mysql, you had to autorize user
RC> mysql to write into your backup des
Enabled the binary log seems to have helped fix the data loss somewhat...I definetly
don't loss it all, but I still get those restarts when I shutdown and sometimes, but
now less often, I find the last few rows gone.
/etc/my.cnf
[mysqld]
user=sql
datadir=/usr/local/mysql/data
socket=/tmp/mysql
OS: Solaris 7, Sparc
MySQL Version: 3.23.29a
Problem:
Sometimes when I do a mysqladmin shutdown on the command line mysql restarts
itself instead of shutting down.
>From the CLI:
elvis~ >mysqladmin -uadmin -pdevsqladmin shutdown
Terminated
010313 18:17:40 mysqld
