SET FOREIGN_KEY_CHECKS=0;
SET UNIQUE_CHECKS=0;
DROP DATABASE IF EXISTS mydentonline;
DROP USER IF EXISTS 'root'@'localhost';
CREATE DATABASE mydentonline;
CREATE USER 'root'@'localhost' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON mydentonline.* TO 'root'@'localhost';
FLUSH PRIVILEGES;
USE mydentonline;
SET SQL_LOG_BIN=0;
SET autocommit=0;
SOURCE /var/www/html/database/backup_database/db_dentonline.sql;
SET autocommit=1;
SET SQL_LOG_BIN=1;
SET FOREIGN_KEY_CHECKS=1;
SET UNIQUE_CHECKS=1;
COMMIT;
EXIT;