Solucionado (ver solução)
Solucionado
(ver solução)
1
resposta

Erro ao importar arquivo dump.sql - MYSQL

Não estou conseguindo importar das tabelas do arquivo dump.sql

Erro: Obs: o arquivo dump está na minha pasta raiz.

mysql> mysql -uroot < dump.sql;
ERROR 1064 (42000): 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 'mysql -uroot < dump.sql' at line 1
mysql>

carlos@carlos-S400CA:~$ sudo mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.7.12-0ubuntu1.1 (Ubuntu)

Copyright (c) 2000, 2016, 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 |
| estoque_laravel    |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0,01 sec)

mysql> use estoque_laravel;
Database changed
mysql> show tables;
Empty set (0,00 sec)

mysql> mysql -uroot < dump.sql;
ERROR 1064 (42000): 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 'mysql -uroot < dump.sql' at line 1
mysql>
1 resposta
solução!

Resolvido.