It is simple the user just needs to be given the "LOCK TABLES" privilege. As root run this command: GRANT LOCK TABLES ON yourdatabase.* TO yourmysqluser@localhost;........

mysqldump or mysql query of a larger file/table ERROR 2006 (HY000) at line 567: MySQL server has gone away Add this to /etc/my.cnf max_allowed_packet=64M service mysqld restart........

mysqldump: Couldn't execute 'show create table `general_log`': SHOW command denied to user 'user'@'localhost' for table 'general_log' (1142) One of my clients almost found out the hard way, here is an unlikely situation that happened. 1.) Years ago the client had another VPS to which they backed up a BLOG nightly to an .sql file, what they forgot is that the file also contained all databases (they used the --all-databases option but forgot). So imagi........

mysqldump does not include CREATE DATABASE statement you need the --databases option "--databases" is misleading, it implies in the documentation that this is a list of databases to be dumped, it should be clear that uses this command in conjuction with dumping a single database also adds CREATE DATABASE and is the only way to get the database to automatically create itself.........

mysqldump --all-databases > allDB.sql The above dumps ALL the mysql databases to "allDB.sql". If you want to compress with gzip you could do this instead: mysqldump --all-databases > gzip > ALLDB.sql.gz........

PHP cannot access /usr/bin/opensslI have verified the username that runs the process is able to access /usr/bin/openssl and it does exist but the PHP script is saying it doesn't exist: [code:1:1fd0f3abbe] if (!file_exists($OPENSSL)) { //echo "ERROR: OPENSSL $OPENSSL not foundn"; }[/code:1:1fd0f3abbe] I don't get itI can clearly see the contents of /usr/bin by using the PHP system fu........

Backup Shell Script[quote:aaa4b0b165]#!/bin/sh date=`date -I` mysqldump --all-databases | gzip > /var/backup/backup-$date.sql.gz [/quote:aaa4b0b165] Something like that could be useful as a cronjob to locally or remotely backup your databases........

Backing MySQL Databases Backing Up/Dumping All Mysql Databases To A Single File mysqldump --all-databases -u admin -p > allmysqldatabases.sql The "-all-databases" clause is pretty obvious isn't it? It means that it will backup all databases. The "-u admin" means login using the user "admin", if you h........