-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrestore-dump-process
59 lines (52 loc) · 1.41 KB
/
restore-dump-process
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
sudo yum install git
48 git
49 git clone https://github.com/aidanjustino21/new-to-do-list-project.git
50 ls
51 cd new-to-do-list-project
52 ls
53 mysql -u root -p 'bkp' < 'scms'.sql
54 sudo mysql -u root -p
55 history
show databases;
+--------------------+
| Database |
+--------------------+
| bkp |
| bkpscms |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql> use bkp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------+
| Tables_in_bkp |
+---------------+
| address_table |
| person_table |
+---------------+
2 rows in set (0.00 sec)
mysql> select * from address_table;
+------------+----------+
| address_id | address |
+------------+----------+
| 1 | illford |
| 2 | east ham |
| 3 | feltham |
+------------+----------+
3 rows in set (0.00 sec)
mysql> select * from person_table;
+-----------+-------------+------------+
| person_id | person_name | address_id |
+-----------+-------------+------------+
| 1 | aidan | 3 |
| 2 | mary | 2 |
| 3 | gowtham | 2 |
+-----------+-------------+------------+
3 rows in set (0.00 sec)
mysql>