MySQL Database Import Command Rumi, July 31, 2012 The syntax is as follows to import the data created by mysqldump command: mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql} mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql} In this example import a file called sales.sql for salesdb1 user and sales db, enter: $ mysql -u sales -p salesdb1 < sales.sql If database salesdb1 does not exists, first create it and than import it as follows: $ mysql -u root -p -e 'create database salesdb1' $ mysql -u sales -p salesdb1 < sales.sql Related Configurations (Linux) MySQL
Syslog server with Rsyslog and LogAnalyzer in Ubuntu 12 August 17, 2018 Installing Rsyslog from repository First make sure you have the latest update of Ubuntu 12.04 LTS sudo apt-get update && sudo apt-get upgrade Adding PPA repository sudo add-apt-repository ppa:adiscon/v8-devel If you get this error: “add-apt-repository: command not found” Try installing this python-software-properties package apt-get install python-software-properties Update your apt cache… Read More
zimbra admin password reset October 4, 2012 To reset the administrative password: su – zimbra zmprov sp <admin email address> <new password> To get a list of all administrators: su – zimbra zmprov gaaa To access the admin console: https://YOURHOST:7071 Remember that the administrative console (sometimes) requires a full email address as the login name, so you… Read More
Apache Virtual Hosts on CentOS August 24, 2019 Step One— Create a New Directory The first step in creating a virtual host is to a create a directory where we will keep the new website’s information. This location will be your Document Root in the Apache virtual configuration file later on. By adding a -p to the line… Read More