Cacti is a network graphing tool similar to MRTG. How do I install and configure common options to collect SNMP data and various other data (such as system load, network link status, hard disk space, logged in users etc) into an RRD?
How do I specify or run MySQL or MariDB SQL queries on the UNIX or Linux command line?
Q. How can I restore a backup of a MySQL database server made with mysqldump program discussed here?
A. You can use standard mysql – the MySQL command-line tool to restore a backup of a MySQL database server.
Read back dump file
You can read the dump file back into the server like this:
mysql db-name < backup-file.sqlTo restore database called sales, first create the database sales:
$ mysql -u root -p
Now create database called sales using SQL statement:
mysql> CREATE DATABASE sales;
Now restore database, enter:
$ mysql -u root -p sales < /path/to/sales-backup-file.sql
would like to change a password for user called tom using UNIX / Linux command line option. How do I change a user password under MySQL server?
ow do I create a MySQL database, tables, and insert (store) data into newly created tables?
am a new Linux user and never used MySQL database server before. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same purpose?
How can I import a MySQL dumpfile into my database? I’m using CentOS Linux 5 server. My old hosting provider gave me a data.sql file and I do have access to my Unix / Linux server via ssh. So How do I restore my data using command line over the ssh session?