How to check MySQL query caching status on your linux server?
Login to your server as root. On mysql prompt fire the following command: mysql> SHOW VARIABLES LIKE ‘%query_cache%’; This will result the …
Tags +
- .htaccess
- Acronis
- Active Directory
- Alerts
- Anonymous FTP
- Antivirus
- Apache
- Aptitude
- ASP
- Audio / Video
- Auto Responder
- AWStats
- BFD
- Bind
- CDONTS
- CDOSYS
- CentOS
- CGI Scripts
- chkrootkit
- Cloud
- Cloud Storage
- CloudLinux
- CMC
- ColdFusion
- cPanel
- CPU
- Cron Job
- CSF
- CSR
- Cute FTP
- DDoS
- Debian
- DeepMetrix
- DirectAdmin
- DNS
- Docker
- Domain Application Vault
- Domlogs
- Dreamweaver
- DrWEB
- Duplicati
- eAccelerator
- EasyApp
- Ensim
- Eudora
- Exim
- Fantastico
- Fedora
- ffmpeg
- FileZilla
- Firewall
- Flash
- FormMail
- Forwarder
- FreeBSD
- FrontPage
- FTP
- GeoTrust
- GRUB
- Helm
- Hivelocity FAQ
- Horde
- Hosting Controller
- Hotlink Protection
- Hsphere
- HTTP
- IIS
- Imagemagick
- IMP
- Incredimail
- inetd
- Intel
- IP Address
- IPMI
- iptables
- JFS
- Kernel
- KernelCare
- Kubernetes
- Linux
- LiteSpeed
- LiveStats
- LogWatch
- MailEnable
- Maldet
- Managed Services
- MBR
- MC
- Metabase
- MetaEdit
- Metered
- Midnight Commander
- Monitoring
- MPC
- MRTG
- MS Access
- MSDE
- MSSQL
- MX Record
- MySQL
- mysql.sock
- mytop
- MyV
- MyVelocity
- Nagios
- NAS
- NAT
- NDR
- Neomail
- Netscape Communicator
- Netstat
- NFS
- NTFS
- NTP
- OpenStack
- osCommerce
- Outlook
- Pegasus
- Percona
- Perl
- PHP
- phpBB
- phpMyAdmin
- PIP
- Plesk
- PostgreSQL
- Process Explorer
- Proxmox
- Python
- Qmail
- RDP
- RedHat
- Redirect
- ReiserFS
- Remote Desktop
- RootCheck
- RPM
- RSYNC
- Runlevel
- RVSiteBuilder
- securephp
- SendMail
- Settings
- Sharepoint
- SIM
- Sitebuilder
- SiteStudio
- Skeleton
- Slackware
- smartcheck
- SmartFTP
- SMTP
- Softaculous
- SpamAssassin
- speedtest
- SPF Record
- SQL
- SquirrelMail
- SSH
- SSL
- Suexec
- Swap Partition
- sysctl
- Tablespaces
- tar
- Task Scheduler
- Telnet
- Terminal Services
- Thunderbird
- tmp
- Tomcat
- Top
- Traceroute
- Troubleshooting
- True Site
- Ubuntu
- UFS partition
- Unix
- Unmetered
- Urchin
- VirtualHost
- Virtuozzo
- vmstat
- VPS
- vsftpd
- Wasabi
- WebAdmin
- Webalizer
- Webmail
- Webmin
- wget
- WHM
- Windows
- WordPress
- WS_FTP
- XFS
- YUM
- Zen Cart
- Zend Optimizer
- Zimbra
...
Latest articles for category: Database
How will you fix phpbb:critical error?
If you get phpBB: Critical Error, then in that case there is a chance the database is broken. You have to run following sql queries …
How will I resolve the below database error?
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser. An E-Mail has …
How to connect to mysql via Dreamweaver?
Refer the following steps:- Create / open a new PHP File 1) new site 2) Yes I want to use server technology 3) which server …
What should I do, if I receive the following error while refreshing mysql on the server ?
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) Refer the below steps to solve this: a.Check the ownership of “/var/lib/mysql” and its files …
How to install Phpmyadmin?
1. Ftp: Download the latest version from https://www.phpmyadmin.net/home_page/downloads.php. The latest version is at the top. You can download the .zip file. Shell:: wget https://mesh.dl.sourceforge.net/sourc…9.0-rc1.tar.gz 2. …
How to backup and restore the database via phpmyadmin?
Following are the steps which could be referred a. Open phpMyAdmin. b. Select your database by clicking the database name in the list on the …
How to manage my mysql database through phpmyadmin in cPanel
a) Login to cpanel of your website b) Search for phpmyadmin icon under databases menu c) Click on it , it should open the phpmyadmin …
Create a database user through the MySQL CLI
Through the mysql command line, this is accomplished by running the following commands. In SSH, type “mysql” to access the mysql command line. Then type: …
Backup a database from the shell prompt
Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script. Create a full backup of your database: shell> …
Use the Load DATA statement?
After creating your table, you need to populate it. The LOAD DATA and INSERT statements are useful for this. Suppose that your pet records can …
Showing 12 - 22 of 88 articles