Suche

Volltextergebnisse:

MySQL Backup under Linux

9 Treffer, Zuletzt geändert: vor 18 Monaten

we get the following instructions for use: <code bash> $ mysqldump Usage: mysqldump [OPTIONS] database ... ptions, use mysqldump --help </code> With <code bash>$ mysqldump --help</code> all available options ... abase, we simply use the following syntax: <code bash>$ mysqldump -u USER -p database USERDATABASE > us... ich is similar to the one described above: <code bash>$ mysqldump -u USER -p --all-databases > full_db.

Check and optimise mysql databases

4 Treffer, Zuletzt geändert: vor 21 Monaten

=== ===== Commands ===== ==== Check ==== <code bash>$ mysqlcheck -c -p[pass] -A</code> ^ Parameter ^... | -A | All databases | ==== Analyse ==== <code bash>$ mysqlcheck -a -p[pass] -A</code> ^ Parameter ^... | -A | All databases | ==== Optimise ==== <code bash>$ mysqlcheck -o -p[pass] -A</code> ^ Parameter ^... s | -A | All databases | ==== Repair ==== <code bash>$ mysqlcheck -r -p[pass] -A</code> ^ Parameter ^

MySQL Operating system error number 13

1 Treffer, Zuletzt geändert: vor 20 Monaten

== Commands for user/group assignment ==== <file bash setuser-mysql.txt> chown -R mysql /var/run/mysqld

Change MySQL passwords

1 Treffer, Zuletzt geändert: vor 21 Monaten

s-maint is stored in /etc/mysql/debian.cnf <code bash> /etc/init.d/mysql stop # Stoppen des MySQL-Ser