mathz.nu Asterisk Blacklist Hobby webbhotell

2015/01/11

Split IBDATA1

Filed under: Hemsidor,MySQL,Server — Mathz @ 23:44
  1. Dump all databases by calling:
    mysqldump --extended-insert --all-databases --add-drop-database --disable-keys --flush-privileges --quick --routines --triggers > all-databases.sql
  2. Stop the MySQL server;
  3. Rename or remove (in case you’ve already backed it up) the MySQL data directory and create an empty one with the same name and permissions;
  4. Make the appropriate changes in my.cnf;
    innodb_file_per_table
  5. Re-initialize the database with the following command (replace the ‘mysqld‘ with the login of the user your MySQL server runs as):
    sudo -u mysqld mysql_install_db
  6. Start the MySQL server;
  7. Get into the ‘mysql‘ console and type:
    SET FOREIGN_KEY_CHECKS=0;
    SOURCE all-databases.sql;
    SET FOREIGN_KEY_CHECKS=1;
  8. Restart the MySQL server.

2014/03/27

Visa procedure i MySQL

Filed under: MySQL,Server — Mathz @ 09:06
SHOW PROCEDURE STATUS;
SHOW FUNCTION STATUS;

Powered by WordPress