Tag: database server

Quick Nitty Gritty How To Repair MySQL Databases

Unofficial, No mess, No thrills, No fluff, No Explanation, Absolutely No Guarantee, Ruff and Gruff howto fix MySQL Databases – Make a temp directory to work in cd /root mkdir mysql_tmp cd mysql_tmp – Locate the database, ussualy a directory in /var/mysql or /var/lib/mysql ls -la /var/mysql/_database_name_ – Stop the […]

Mysql failed after upgrade: Table ‘mysql.plugin’ doesn’t exist

After performing a mysql upgrade, you may run into a problem where Mysql won’t start successfully and will result in a “Table ‘mysql.plugin’ doesn’t exist” error message. The mysql error logs will state something like follows: /usr/libexec/mysqld: Table ‘mysql.plugin’ doesn’t exist 110620 01:01:01 [ERROR] Can’t open the mysql.plugin table. Please […]

ERROR 2006 (HY000) at line 526: MySQL server has gone away

Today I imported the MySQL database and I got the following error: # mysql -u root -p db_test < test.db Enter password: ERROR 2006 (HY000) at line XX: MySQL server has gone away viagra for men< It is healthymaleviagra-formen.com< because the data (SQL query) is too large to imported. To […]

Linux HugeTLBfs: Improve MySQL Database Application Performance

Applications that perform a lot of memory accesses (several GBs) may obtain performance improvements by using large pages due to reduced Translation Lookaside Buffer (TLB) misses. HugeTLBfs is memory management feature offered in Linux kernel, which is valuable for applications that use a large virtual address space. It is especially […]

MySQL Error: Unknown table engine ‘InnoDB’

Error: Unknown table engine ‘InnoDB’ What happened ? I edited the file /etc/mysql/my.cnf by adding these lines: innodb_file_per_table innodb_buffer_pool_size=12G innodb_additional_mem_pool_size=20M innodb_flush_method=O_DIRECT Then I restarted mysql and after that I noted the website was not working correctly due an error in the mysql related to the innodb engine not found. So […]

Copy MySQL Database From One Server To Another Remote Server

Usually you run mysqldump to create a database copy and backups as follows: $ mysqldump -u user -p db-name > db-name.out Copy db-name.out file using sftp/ssh to remote MySQL server: $ scp db-name.out user@remote.box.com:/backup Restore database at remote server (login over ssh): $ mysql -u user -p db-name < db-name.out […]

HowTo: Migrate / Move MySQL Database And Users To New Server

I already wrote about how to move or migrate user accounts from old Linux / UNIX server to a new server including mails and home directories. However, in reality you also need to move MySQL database which may host your blog, forum or just your data stored in MySQL database. […]