Suche

Volltextergebnisse:

MySQL Backup under Linux

18 Treffer, Zuletzt geändert: vor 18 Monaten

ers, we get the following instructions for use: <code bash> $ mysqldump Usage: mysqldump [OPTIONS] data... OPTIONS] For more options, use mysqldump --help </code> With <code bash>$ mysqldump --help</code> all available options are displayed. However, not all of these are rele

Check and optimise mysql databases

8 Treffer, Zuletzt geändert: vor 21 Monaten

s ====== ===== Commands ===== ==== Check ==== <code bash>$ mysqlcheck -c -p[pass] -A</code> ^ Parameter ^ Alias ^ Meaning ^ | --check | -c | Check tables ... bases | -A | All databases | ==== Analyse ==== <code bash>$ mysqlcheck -a -p[pass] -A</code> ^ Parameter ^ Alias ^ Meaning ^ | --analyze | -a | Analyse tab

Change MySQL passwords

4 Treffer, Zuletzt geändert: vor 21 Monaten

an-sys-maint is stored in /etc/mysql/debian.cnf <code bash> /etc/init.d/mysql stop # Stoppen des MySQ... # Als root am MySQL-Server anmelden </code> <code mysql> update user set Password=PASSWORD('hier-neues-passwort-hin') where user='root'; # neues... setzen flush privileges; # neuladen der Benutzertabellen exit; </code>

MySQL Operating system error number 13

2 Treffer, Zuletzt geändert: vor 20 Monaten

log// the following error message is displayed: <code text> Feb 23 19:30:50 v21080422 mysqld_safe[22878... 23 19:30:50 v21080422 mysqld_safe[22888]: ended </code> ===== Solution ===== The problem is that the f