1 2 3 4 5 6 7 8 9 | -- CREATECREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024';GRANT ALL PRIVILEGES ON tgndbrestored.* TO 'tgnrestoreuser'@'localhost';-- RESTORE as below-- DELETE user and databaseDROP USER tgnrestoreuser@localhost;DROP DATABASE tgndbrestored; |
Restore a gzipped database
1 | zcat 7-tgndb-Sun-db.sql.gz | mysql -uroot -p tgndbrestored |
0 Comments