Sysop:MySQL: Unterschied zwischen den Versionen

Aus immerda
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: == adding new user accounts == * http://dev.mysql.com/doc/refman/5.0/en/adding-users.html <pre> mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDE...)
 
K (Muri verschob Seite MySQL nach Sysop:MySQL, ohne dabei eine Weiterleitung anzulegen: articles referring to sysop stuff should be in the sysop namespace)
 
(8 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
* http://www.gentoo.org/doc/en/mysql-howto.xml
== cluster ==
* http://www.lod.com/whitepapers/mysql-cluster-howto.html
== dump ==
structure:
  mysqldump --opt --no-data -u user --password="pwd" database | bzip2 -c > database_db_dump_structure.sql.bz2
data:
  mysqldump --opt --no-create-info -u user --password="pwd" database | bzip2 -c > database_db_dump_data.sql.bz2
== adding new user accounts ==
== adding new user accounts ==
* http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
* http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Zeile 9: Zeile 22:
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
</pre>
</pre>
== fixing tables ==
myisamchk --silent --fast datenbank/*.MYI
* and if very critical
myisamchk --force --update-state --key_buffer_size=64M --sort_buffer_size=64M --read_buffer_size=1M --write_buffer_size=1M datenbank/*.MYI
[[Category:ImmerdaDocumentationProject]]
[[Category:DB]]
[[Category:MySQL]]

Aktuelle Version vom 23. Januar 2014, 23:27 Uhr

cluster

dump

structure:

 mysqldump --opt --no-data -u user --password="pwd" database | bzip2 -c > database_db_dump_structure.sql.bz2

data:

 mysqldump --opt --no-create-info -u user --password="pwd" database | bzip2 -c > database_db_dump_data.sql.bz2

adding new user accounts

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';

fixing tables

myisamchk --silent --fast datenbank/*.MYI
  • and if very critical
myisamchk --force --update-state --key_buffer_size=64M --sort_buffer_size=64M --read_buffer_size=1M --write_buffer_size=1M datenbank/*.MYI