Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Restore backup

Restoring the Sakila DB from the backup file
From within the MySQL shell, let's create an empty schema by typing the MySQL command create schema sakila; and hit ENTER
type the MySQL command exit; and hit ENTER
type the command mysql -u root -p sakila < ~/Desktop/sakila_backup.sql and hit ENTER
enter your password - wait for the process to complete
Source by platform.codingnomads.co #
 
PREVIOUS NEXT
Tagged: #Restore #backup
ADD COMMENT
Topic
Name
4+1 =