My bookmark
1106 shaares
7 results
tagged
mysql
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0_BAK
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1_BAK
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1_BAK
Parce que suite à une erreur de nommage de fichier (un ? dans le nom), j'ai fait buggé mon interface Nextcloud.
Dans mysql, sur db owncloud, faire un:
delete from oc_filecache where path like '%nom_partiel_du_fichier_en_question%';
Problem solved!
Dans mysql, sur db owncloud, faire un:
delete from oc_filecache where path like '%nom_partiel_du_fichier_en_question%';
Problem solved!
il faut que je retrouve l'autre cheatsheet mieux que j'avais trouvé...
CREATE USER IF NOT EXISTS user IDENTIFIED BY 'password';
SHOW DATABASES;
grant all privileges on databasename.* to 'username'@'%' identified by ''password';
flush privileges;
CREATE USER IF NOT EXISTS user IDENTIFIED BY 'password';
SHOW DATABASES;
grant all privileges on databasename.* to 'username'@'%' identified by ''password';
flush privileges;
Backup
LOCK TABLES, SELECT, FILE, RELOAD, SUPER, SHOW VIEW
Restore
CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, SUPER, REPLICATION CLIENT, CREATE, VIEW
Mysql Query
CREATE USER 'dbbackup'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT ,
RELOAD ,
FILE ,
SUPER ,
LOCK TABLES ,
SHOW VIEW ON * . * TO 'dbbackup'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
LOCK TABLES, SELECT, FILE, RELOAD, SUPER, SHOW VIEW
Restore
CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, SUPER, REPLICATION CLIENT, CREATE, VIEW
Mysql Query
CREATE USER 'dbbackup'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT ,
RELOAD ,
FILE ,
SUPER ,
LOCK TABLES ,
SHOW VIEW ON * . * TO 'dbbackup'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Simply put something like this into /etc/logrotate.conf:
/var/backups/mysql/dump.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf --opt --flush-logs --all-databases > /var/backups/mysql/dump.sql
endscript
}
avec backup-credentials.cnf en chmod 600 contenant:
[mysqldump]
user=mysqluser
password=mypsswd
/var/backups/mysql/dump.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf --opt --flush-logs --all-databases > /var/backups/mysql/dump.sql
endscript
}
avec backup-credentials.cnf en chmod 600 contenant:
[mysqldump]
user=mysqluser
password=mypsswd
Les mot de passe mysql en clair dans un fichier de config piwigo.
NOTA, penser à changer de user.
NOTA, penser à changer de user.
Encore un truc inutile sur le coup, mais que je vais être heureux de retrouver plus tard.