≡ Menu

mysql databases

HowTo: Update Centos Linux 5.4 to 5.5

CentOS Linux v5.5 has been released. How do I upgrade CentOS Linux from version 5.4 to latest version 5.5 over the Internet?
[click to continue…]

phpMyAdmin: Cannot load mysql extension. Please check your PHP configuration

I got new server and installed phpMyAdmin. But whenever I visit the phpmyadmin url it says:

Cannot load mysql extension. Please check your PHP configuration

How do I fix this problem under CentOS / RHEL / Fedora Linux Apache web server?
[click to continue…]

How To: Upgrade CentOS Linux 5.3 to v5.4

How do I upgrade CentOS Linux from version 5.3 to latest version 5.4 over the Internet?
[click to continue…]

CentOS / RHEL: Install MySQL PHP Extension

How do I install a module or extension for PHP applications that use MySQL databases under CentOS / Redhat / RHEL / Fedora Linux?
[click to continue…]

Howto: Backup CentOS / Fedora Linux / Red Hat Enterprise Linux server system

Q. How do I backup files and database for the Red Hat Enterprise Linux / CentOS Linux? Currently I’ve MySQL server running on CentOS 5 and Web server and file server using RHEL 5. How do I backup all these servers?

A. Regular backup is an essential for Linux system. You can take backup on
=> Tape
=> NAS Server
=> DVD
=> Network server etc

Implementing a backup policy that includes rotating backup media and keeping copies of backup media offsite is the most reliable way of minimizing damage. See following resources on our site for more information including commands and shell scripts:

  1. Perform backups for the Linux operating system
  2. How to backup MySQL databases, web server files to a FTP server automatically
  3. Howto Backup PostgreSQL Databases
  4. All backup shell scripts

MySQL command to show list of databases on server

Q. I am new to MySQL database server. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same?
[click to continue…]

How can I restore a backup of a MySQL database?

Q. I made MySQL backup using mysqldump -u user -h localhost -ppassword forumdb | -gzip -9 > forumdb.sql.gz command. How do I restore MySQL database backup using a shell prompt under Linux / UNIX operating system?
[click to continue…]