How do I install Oracle (Sun) MySQL database server v5.x under Ubuntu Linux operating systems? How do I add a new user and database for Apache web server and php access under Ubuntu Linux?
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.sql To 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?