Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@debian:~# pwd
- /root
- root@debian:~# ls
- bak_db_tc_2018.07.15_17-57-33.sql
- root@debian:~# mysql -u ticket -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 57
- Server version: 5.5.60-0+deb8u1 (Debian)
- Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | performance_schema |
- | ticket |
- +--------------------+
- 4 rows in set (0.00 sec)
- mysql> use ticket;
- Database changed
- mysql> show tables;
- Empty set (0.00 sec)
- mysql> \q;
- Bye
- root@debian:~# mysql -u ticket -p ticket < bak_db_tc_2018.07.15_17-57-33.sql
- Enter password:
- ERROR 1064 (42000) at line 107: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,
- `ok` tinyint(1) NOT NULL,
- `ticket_id` int(11) NOT NULL,
- `use' at line 3
- root@debian:~#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement