Dear All,

I've installed MySQL-server-community-5.1.35-0.rhel5.x86_64.rpm, client and devel on my 64 bit server having CentOS 5.4 (Final) as operating system. Now when I setup my.cnf file and add an entry "init-file=/usr/src/script.sql" and restart Mysql service then Mysql fails to start but when I comment init-file portion in my.cnf file then mysql runs fine. Please find below log file entry in mysql log

100304 3:03:38 [ERROR] /usr/sbin/mysqld: File '/usr/src/scripts/startup.sql' not found (Errcode: 13)
100304 3:03:38 [ERROR] Aborting

I have verified that file exist on the location mentioned in my.cnf file. Can anybody please suggest fix of this problem.

Regards,
Zaeem

Can you post the output of:
Evo2.

The permissions on that file are probably wrong.

Dear Evo2,

# ls -l startup.sql
-rwxr-xr-x 1 root root 149 Mar 3 07:29 startup.sql

# file startup.sql
startup.sql: ASCII text, with CRLF line terminators

Now after giving chmod 755 to this file mysql restarting fine but this script (startup.sh) is not populating few tables as it should be.

Any suggestion ?

Regards,

Anybody??

and
How about saying what, exactly is wrong? "not populating few tables", doesn't tell us anything. What are you expecting it to do? What are the contents of that sql file?

You made this file on MS didn't you
*nix files only have LF terminators. Try dos2unix to cvt it.
Then show the content if it doesn't work, along with EXACT err msgs.

1 members found this post helpful.

Nice catch!

Evo2.

Indeed...well done!

Dear TBOne,

The contents of that file are as below;

set global max_heap_table_size=16777216*64;

call MyDB.PROC_UpdateRecords(0,'');

The UpdateRecord procedure basically picks the records from table and populate Memory tables. The purpose of this is that we always have record in memory after mysql restarts.

I hope it clarifies the issue. So please let me know if I am doing anything wrong?

Thanking you in Advance

Did you run the script as suggested?