[php and mysql] how to LOCK TABLES ?

[graziano68]

Hello

using a php script , I would execute a

LOCK TABLES (only read)
FLUSH TABLES

for database "mydatabase" , on ALL the tables .

Any idea how to do that please ?

I need this to make the database read only (for backup of mysql files purpouse)

Thank you

[CoderMaya]

I would just create a new MySQL user with specific permissions.

[longneck]

any particular reason you're reinventing the wheel? mysqldump already takes the proper locks.