TAG: mysql

Howto dump & restore tables and databases 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 mysql 5 into mysql 4 you should pass the following parameters to mysqldump:
myisamchk 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 fix * run the following command: for i in *.MYI ; do myisamchk --recover $i ; done
MySQL MySQL Product Support EOL Announcements: <http://www.mysql.com/support/eol-notice.html> Stuff regarding Mysql: mysql index Some short snippets regarding the mysql command line client: show databases; show tables; /* show the table schema: */ describe tablename; show keys from tablename; mysql
MySQL binary log The binary log contains all statements that update data or potentially could have updated it. Corresponding lines in my.cnf: [...] # Replication Master Server (default) # binary logging is required for replication log-bin=mysql-bin # WARNING: Using expire_logs_days without bin_log crashes the server! expire_logs_days = 10 max_binlog_size = 256M [...]
Mysql configuration 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 socket = /var/run/mysqld/mysqld.sock /etc/my.cnf Part of a Mysql 5.0 config file (character-set and collation related).
MySQL CSV Data Import How to import a CSV file with UTF-8 data The given data contains UTF-8 encoded stuff with german umlauts (ä,ö,ü,...) When I tried to import the CSV with phpmyadmin I always ended up with such funny output like Mühlhausen/Thüringen
Mysql variables Normally you would set (global) variables in your my.cnf config file. To change such a variable on the fly you can do so in the mysql console: Set tmp_table_size to 256M: mysql> set @@global.tmp_table_size=268435456; Query OK, 0 rows affected (0.00 sec)
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0 ipv6 ready