1

MYSQL backup, mysql -e "FLUSH TABLES WITH READ LOCK" doesnt work

view story
linux-howto

https://bbs.archlinux.org – I want to backup mysql locking tables first using flush tables with readlock, then do rsync and then unlock tables.I want to do it automatically using script.When I log in to mysql using: mysql -u root -pthe command:FLUSH TABLES WITH READ LOCK; works and locks the tables...but when I create my.cnf with login information to mysql:[client]user=rootpassword=xxxthe command: mysql -e "SHOW DATABASES"works and shows the databases....but when I run this command:mysql -e "FLUSH TABLES WITH READ LOCK"it doesnt lock the tables...why?thanks rado3105 https://bbs.archlinux.org/ (HowTos)