-- CREATE
CREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024';
GRANT ALL PRIVILEGES ON tgndbrestored.* TO 'tgnrestoreuser'@'localhost';
-- RESTORE as below
-- DELETE user and database
DROP USER tgnrestoreuser@localhost;
DROP DATABASE tgndbrestored;
Restore a gzipped database
zcat 7-tgndb-Sun-db.sql.gz | mysql -uroot -p tgndbrestored
0 Comments