Repair all database in mysql

Repair all database in mysql



Following command will repair your all databases on server.

myisamchk -r /var/lib/mysql/*/*.MYI

/etc/rc.d/init.d/mysql restart



Following command will show if you need to repair your database or not

myisamchk –check /var/lib/mysql/*/*.MYI

Then try ‘safe-recover’ first:

myisamchk –safe-recover /var/lib/mysql/*/*.MYI

OR

myisamchk –recover /var/lib/mysql/*/*.MYI

Forceful

myisamchk –safe-recover –extend-check –force /var/lib/mysql/*/*.MYI

OR

myisamchk –recover –extend-check –force /var/lib/mysql/*/*.MYI

How to turn off Innodb in mysql?

How to turn off Innodb in mysql?
March 5th, 2011Amit Honrao1 comment

Innodb is by default installed with mysql, You can verify whether Innodb is set to On or Off by using following command.

mysqladmin variables

mysqladmin variables | grep have_innodb

If you want to disable it so you can do it using following steps.

Edit mysql configuration file

vi /etc/my.cnf

add this in my.cnf file

skip-innodb

Save and exit from file using Esc !wq the enter

Could not connect: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) solution :

Could not connect: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
solution :

We get this error if mysql.sock file is not available at /var/lib/mysql
login to server
killall -9 mysqld

service mysql start

service mysql restart

If still mysql.sock is not created under /var/lib/mysql then,
Go to /tmp
We will found there mysql.sock in red color
Delete it from /tmp
Service mysql restart
This should create mysql.sock file at /var/lib/mysql
OR

Use command “ln -s /var/lib/mysql/mysql.sock mysql.sock” to create it
then restart mysql and check

Some Useful cPanel scripts

Some Useful cPanel scripts


/scripts/adddns – Adds a DNS zone.

/scripts/addnetmaskips – Add the netmask 255.255.255.0 to all IPs that have no netmask.

/scripts/addnobodygrp – Adds the group nobody and activates security.

/scripts/addpop – Add a Pop Account.

/scripts/addservlets – Add JSP support to an account (requires tomcat).

/scripts/adduser – Add a user to the system.

/scripts/betaexim – Installs the latest version of exim.

/scripts/biglogcheck – looks for logs nearing 2 gigabytes in size

/scripts/bsdcryptoinstall – Installs crypto on FreeBSD.

/scripts/bsdldconfig – Configures the proper lib directories in FreeBSD.

/scripts/bsdpkgpingtest – Tests the connection speed for downloading FreeBSD packages.

/scripts/buildeximconf – Rebuilds exim.conf.

/scripts/buildpostgrebsd-dev – Installs postgresql on FreeBSD.

/scripts/checkbadconf – Checks /usr/local/apache/conf/httpd.conf for bad users.

/scripts/checkbsdgroups – Checks and repairs proftpd ownership on FreeBSD.

/scripts/checkccompiler – Checks to make sure the C compiler works on your system.

/scripts/checkfpkey – Checks for the FrontPage suid key

/scripts/checkgd – Checks to see if GD is built.

/scripts/checkinterchange – (Internal use).

/scripts/checklibssl – Checks to make sure the proper libssl symlinks exist.

/scripts/checkmaxclients – Checks to see if apache has reached the maximum clients allowed.

/scripts/checkoldperl – Checks to see if the version of Perl on your system is old.

/scripts/checkrsync – Checks to make sure rsync is up to date.

/scripts/checksuexecpatch – Checks to see if mailman has been patched for suexec.

/scripts/checksuspendpages – Checks to see if suspend pages are properly named.

/scripts/checkup2date – Makes sure up2date is set up properly (RedHat)

/scripts/checkyum – Makes sure yum is set up properly.

/scripts/chkpaths – Makes sure /usr/sbin/chown has a symlink to /bin/chown

/scripts/chownpublichtmls – Change ownership of all users web space to them, which is useful for converting to

suexec. Files owned by nobody are deleted.

/scripts/ckillall – Allows you to kill a process (used like killall).

/scripts/cleanbw – Cleans up old bandwidth logs.

/scripts/cleandns8 – Clean up named.conf.

/scripts/cleangd – Cleans up old GD installs and reinstalls GD

/scripts/cleanmd5 – Fix CPAN md5 problems.

/scripts/cleanmsglog – cleans exim’s msglog

/scripts/cleanupmysqlprivs – Cleans up improper mySQL privileges.

/scripts/compilers – Disables the usage of compilers for unprivileged users.

/scripts/convert2maildir – Converts mail from mbox to maildir format and installs courier impap and pop (cpimap is

removed).

/scripts/cpbackup – Runs backups.

/scripts/distupgrade – Upgrades RedHat to the newest version (for testing only)

/scripts/dnscluster – Enables DNS clustering.

/scripts/dnstransfer – Only if the server has a DNS master (sync with DNS master).

/scripts/downgradefp – Downgrades FrontPage Extensions (to 5.0-0)

/scripts/dropmysqldb – Drops a mySQL database.

/scripts/easyapache – Upgrade Apache

/scripts/editquota – Change a users quota.

/scripts/enablechkservdwebmail – Enable service checking of webmaild.

/scripts/enablefileprotect – Protects home directories if file protection is built in apache.

/scripts/ensurepkg – Installs a FreeBSD package.

/scripts/ensurerpm – Installs a rpm.

/scripts/exim3 – Installs exim 3.

/scripts/exim4 – Installs exim 4.

/scripts/eximlocalsend – Enables/Disables exim local sending.

/scripts/eximup – Installs/Updates exim.

/scripts/findhacks – Search for common Trojan Horses.

/scripts/findoddrootprocesses – Lists root processes that may need to be checked out.

/scripts/findphpversion – Check to see if your php version file is up to date.

/scripts/fixallcartswithsuexec – Fixes permissions on carts when using suexec.

/scripts/fixbinpath – Makes sure all bin file paths are correct.

/scripts/fixbuggynamed – Updates bind to solve any problems with bugs.

/scripts/fixcommonproblems – Attempt to fix the most common problems.

/scripts/fixetchosts – Fixes problems with /etc/hosts

/scripts/fixeverything – Fix common problems and quotas.

/scripts/fixinterchange – Reinstall interchange Perl modules.

/scripts/fixinterchangeperm – fix permissions on a user’s interchange cart.

/scripts/fixlocalhostwithphp – Change /etc/hosts to work better with PHP 4.2.0 + MySQL.

/scripts/fixmailman – Updates and restarts mailman.

/scripts/fixmysql – Fixes problems with mySQL.

/scripts/fixmysqlbsd – Fixes problesm with mySQL on FreeBSD.

/scripts/fixnamed – Updates bind to handle many DNS zones (more than 512).

/scripts/fixpop – Fix a POP account and reset password.

/scripts/fixproftpdconf – Fixes problems with /usr/local/etc/proftpd.conf

/scripts/fixproftpddupes – Updates proftpd.

/scripts/fixquotas – Fix quotas.

/scripts/fixrndc – Fixes named.conf to prevent rndc staus failed.

/scripts/fixsubdomainlogs – Run if subdomain logs don’t show up in cPanel.

/scripts/fixsuexeccgiscripts – Fix CGI scripts that are broken after suexec installed.

/scripts/fixvaliases – Fix permisions on valiases.

/scripts/fixwebalizer – Repair a Webalizer that has stopped updating.

/scripts/fpanonuserpatch – Updates FrontPage extensions to include the anonymous user patch.

/scripts/ftpquaotacheck – Runs quota checking for all ftp users.

/scripts/ftpup – Updates your ftp server.

/scripts/fullhordereset – Resets Horde and displays the current Horde password.

/scripts/gcc3 – Installs gcc-3.3.3

/scripts/gencrt – Generate a .crt and .csr file.

/scripts/initfpsuexec – Enable FrontPage suexec support.

/scripts/initquotas – Turn on quota support on new drives.

/scripts/initsslhttpd – Make sure HTTP starts with SSL.

/scripts/initsuexec – Turn on suexec support if suexec is installed.

/scripts/installfpfreebsd – Installs FrontPage 5 Extensions on FreeBSD.

/scripts/installfpgentoo – Installs FrontPage on Gentoo.

/scripts/installgd – Builds GD.

/scripts/installpkg – Installs a FreeBSD package.

/scripts/installpostgres – Installs PostrgeSQL.

/scripts/installzendopt – Install zend optimzer.

/scripts/installzendopt-freebsd – Install zend optimizer on a freebsd machine.

/scripts/isdedicatedip – Checks an ip to see if it is dedicated.

/scripts/killacct – Delete an account.

/scripts/killdns – Delete a DNS zone.

/scripts/killpvhost – Removes a virtual host from proftpd.conf.

/scripts/killspamkeys – Removes a spam key.

/scripts/killsslvhost – Removes a SSL entry for a virtual host.

/scripts/killvhost – Delete a vhost.

/scripts/listcheck – Checks mailing lists for issues.

/scripts/listproblems – Lists common problems.

/scripts/listsubdomains – List subdomains.

/scripts/mailperm – Fix almost any mail permission problem.

/scripts/mailscannerupdate – Updates MailScanner

/scripts/makecpphp – Installs php.

/scripts/manualupcp – Updates cPanel manually.

/scripts/md5crypt – Encrypts a password into MD5.

/scripts/mysqladduserdb – Create a MySQL databse and user.

/scripts/mysqlconnectioncheck – Attempts to connect to MySQL, restarts SQL if necessary.

/scripts/mysqldeluserdb – Delete a MySQL database and user.

/scripts/mysqlpasswd – Change MySQL password.

/scripts/mysqlup – Updates mySQL.

/scripts/newexim – Installs the latest version of exim.

/scripts/nofsck – Make fsck always use -y

/scripts/nomodattach – Removes mod_attach from httpd.conf.

/scripts/nomodauthmysql -Removes mod_auth_mysql from httpd.conf.

/scripts/nomodbwprotect – Removes mod_bwportect from httpd.conf.

/scripts/nomodgzipconfmods – Removes mod_gzip from httpd.conf.

/scripts/nomodperl – Removes mod_perl from httpd.conf.

/scripts/park – Parks a domain.

/scripts/patcheximconf – Fixes exim.conf.

/scripts/perlinstaller – Installs perl.

/scripts/phpini – Create a php.ini file.

/scripts/proftpd128 – Installs proftpd-1.2.8.

/scripts/quickkernel – Updates your kernel.

/scripts/quicksecure – Quickly kill useless services.

/scripts/rebuildcpanelsslcrt – Rebuilds the cPanel SSL Certificate.

/scripts/rebuildcpusers – Rebuilds /var/cpanel/users.

/scripts/rebuildetcpasswd – Rebuilds /etc/passwd.

/scripts/rebuildeximbsd – Rebuilds exim on FreeBSD.

/scripts/rebuildhttpdconffromproftpd – Rebuild httpd.conf from the proftpd.conf file.

/scripts/rebuildnamedconf – Restore named.conf from files in /var/named.

/scripts/rebuildproftpd – Restore proftpd.conf from httpd.conf.

/scripts/reinstallmailman – Reinstalls mailman.

/scripts/reseteximtodefaults – Resets exim’s default settings.

/scripts/resetimappasswds – Resets all imap passwords.

/scripts/restartsrv – Restart a service.

/scripts/restartsrv_apache – Restart apache.

/scripts/restartsrv_bind – Restart bind.

/scripts/restartsrv_clamd – Restart clamd.

/scripts/restartsrv_courier – Restart courier imap.

/scripts/restartsrv_cppop – Restart cppop.

/scripts/restartsrv_entropychat – Restart entropy chat.

/scripts/restartsrv_exim – Restart exim.

/scripts/restartsrv_eximstats – Restart exim statistics.

/scripts/restartsrv_ftpserver – Restart your ftp server.

/scripts/restartsrv_httpd – Restart httpd.

/scripts/restartsrv_imap – Restart impad.

/scripts/restartsrv_inetd – Restart inetd.

/scripts/restartsrv_interchange – Restart Interchange Shopping Cart.

/scripts/restartsrv_melange – Restart melange chat.

/scripts/restartsrv_mysql – Restart mysqld.

/scripts/restartsrv_named – Restart named.

/scripts/restartsrv_postgres – Restart postgresql.

/scripts/restartsrv_postgresql – Restart postgresql.

/scripts/restartsrv_proftpd – Restart proftpd.

/scripts/restartsrv_pureftpd – Restart pure-ftpd.

/scripts/restartsrv_spamd – Restart spamd.

/scripts/restartsrv_sshd – Restart sshd.

/scripts/restartsrv_syslogd – Restart syslogd.

/scripts/restartsrv_tomcat – Restart tomcat.

/scripts/restartsrv_xinetd – Restart xinetd.

/scripts/restoremail – Restores a user’s mail.

/scripts/runstatsonce – Runs statistics (should be used from the crontab).

/scripts/runweblogs – Run analog/webalizer/etc. for a user.

/scripts/safeyum – Runs yum safely.

/scripts/setupfp – Install FrontPage 3 on an account.

/scripts/setupfp4 – Install FrontPage 4 (2000) installer on an account.

/scripts/setupfp5 – Install FrontPage 5 (2002) installer on an account.

/scripts/setupfp5.nosueuxec – Install FrontPage 5 (2002) installer on an account when not using suexec.

/scripts/unsetupfp4 – Removes FrontPage 4 or 5 from an account.

/scripts/unsuspendacct – Unsuspends an account.

/scripts/upcp – Updates cPanel.

/scripts/whoowns – Finds out who owns a domain.

/scripts/wwwacct – Creates an account.

4 Ways to Free Up Disk Space on a cPanel Server

 4 Ways to Free Up Disk Space on a cPanel Server


To remove Fantastico backups:
rm -rfv /home/*/fantastico_backups

3) Delete cPanel File Manager temp files
rm -fv /home/*/tmp/Cpanel_*

 Remove cPanel update archives

/usr/local/apache.backup*
/home/cpeasyapache (actual name may vary depending on cpanel version)


6) Clean up Yum files
yum clean all

Re-Installing Auxiliary cPanel Software

Re-Installing Auxiliary cPanel Software

Cpanel has a lot of supporting software that you may be using on your server. In case something goes amiss, here is a list of scripts that reinstall cpanel-provided software on your system. For most all of these, you can pass a –force as an argument to force a reinstall of the application.

cPanel
/scripts/upcp

MySQL
/scripts/mysqlup

PostgreSQL
/scripts/installpostgres

Roundcube
/usr/local/cpanel/bin/update-roundcube

Horde
/usr/local/cpanel/bin/update-horde

Squirrelmail
/usr/local/cpanel/bin/update-squirrelmail

phpMyAdmin
/usr/local/cpanel/bin/updatephpmyadmin

pureFTP
/scripts/ftpup –force (See: Installing and Configuring pure-FTP)

Exim
/scripts/eximup

Courier IMAP
/scripts/courierup –force (See: Installing/Configuring Courier IMAP)

Dovecot
/scripts/dovecotup –force (See: Installing and Configuring Dovecot)

cpAddons
/scripts/cpaddonsup

NSD/BIND
/scripts/setupnameserver (NSD:/scripts/nsdup)

Apache/PHP
/scripts/easyapache (See: EasyApache)

suPHP
/scripts/suphpup

cPanel Internal PHP
/scripts/makecpphp

FrontPage Extensions
/scripts/fpupgrade

Mailman
/scripts/reinstallmailman (will not remove list data)

cpHulkd
/usr/local/cpanel/bin/hulkdsetup

Ruby
/scripts/installruby