Advertisement
Guest User

Untitled

a guest
Jul 19th, 2018
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.26 KB | None | 0 0
  1. root@debian:~# pwd
  2. /root
  3. root@debian:~# ls
  4. bak_db_tc_2018.07.15_17-57-33.sql
  5. root@debian:~# mysql -u ticket -p
  6. Enter password:
  7. Welcome to the MySQL monitor.  Commands end with ; or \g.
  8. Your MySQL connection id is 57
  9. Server version: 5.5.60-0+deb8u1 (Debian)
  10.  
  11. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
  12.  
  13. Oracle is a registered trademark of Oracle Corporation and/or its
  14. affiliates. Other names may be trademarks of their respective
  15. owners.
  16.  
  17. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  18.  
  19. mysql> show databases;
  20. +--------------------+
  21. | Database           |
  22. +--------------------+
  23. | information_schema |
  24. | mysql              |
  25. | performance_schema |
  26. | ticket             |
  27. +--------------------+
  28. 4 rows in set (0.00 sec)
  29.  
  30. mysql> use ticket;
  31. Database changed
  32. mysql> show tables;
  33. Empty set (0.00 sec)
  34.  
  35. mysql> \q;
  36. Bye
  37. root@debian:~# mysql -u ticket -p ticket < bak_db_tc_2018.07.15_17-57-33.sql
  38. Enter password:
  39. 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,
  40.  `ok` tinyint(1) NOT NULL,
  41.  `ticket_id` int(11) NOT NULL,
  42.  `use' at line 3
  43. root@debian:~#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement