How do I Restore a mysql database ?
 

Hello
How do I restore a mysql database I need the syntax please.
Thanks Glenn

The backup was done via crontab line.
> /usr/bin/mysqldump -uuserid -ppassword cacti > /backups/cacti-data-backup.sql

> first few lines of dumpfile
head cacti-metadata-backup.sql
-- MySQL dump 10.13 Distrib 5.1.46, for suse-linux-gnu (x86_64)
--
-- Host: localhost Database: cacti
-- ------------------------------------------------------
-- Server version 5.1.46-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

use below command to restore mysql backup