MySQL

Tutorials

  • Check Apache, MySql, and PHP versions

    Check Apache, MySql, and PHP versions

    To further check Linux Apache MySQL PHP (LAMP) stack installation, the following can be made to know the exact installed version of each application. Check Apache version. To check the Apache HTTP Server version, type httpd -v on the command line. $ httpd -v Apache’s version is 2.4.55. Check PHP version. To check the PHP…

  • Restore MySQL backup from the terminal

    Restore MySQL backup from the terminal

    Efficiently import MySql backup database records from an .sql file using the mysql command from the terminal. A quick and direct approach to restore MySQL backup files from the terminal. For example. mysql -uNAME -p DATABASE < database_backup.sql Enter the PASSWORD when prompted. Enter password: Where. NAME is the user who has access to the…

  • Backup MySQL Database In Terminal

    Backup MySQL Database In Terminal

    Import MySql database records into an .sql file from the terminal using the MySql command mysqldump, it is a quick and easy way to backup MySql database records. Requirements: MySQL Command line terminal How to manually backup a MySQL database. mysqldump -uNAME -pPASSWORD DATABASE > database.sql Where. NAME = the user name who has access…

  • Access MySQL DB using PDO in PHP

    Access MySQL DB using PDO in PHP

    Most, if not all new PHP server installations now a days include the PHP Data Objects API (PDO_MySQL), this extension is recommended if there’s a chance of connecting to different DBMS (Database Management Systems) in the future. Because same functions will be used to issue queries and to fetch data, only a single API needs…