| Page | Description | Tags |
|
Dump
To dump specific table(s):
mysqldump --add-drop-table -u user -pPASSWORD dbfoo table1 table2 > dump_foo
If you want to import a dump made with mysq… |
MySQL |
|
The binary log contains all statements that update data or potentially could have updated it.
Corresponding lines in my.cnf:
[...]
# Replication Master Serv… |
mysql |
|
What to put into Mysql config files ...
~/.my.cnf
Layout of the ~/.my.cnf configuration file:
[client]
host=host.domain.tld
password = secret
user = root
… |
MySQL |
|
Steps to be performed to do an upgrade of mysql (e.g. from 5.0.19 to 5.0.27) and some scripts which make life easier :-)
Assumpsions:
mysql will be installed … |
MySQL |
|
What to to if your MYISAM tables have been corrupted somehow?
* stop mysql
* move to your data directory
* move into the database directory you want to … |
MySQL |
