title: How to open and work with a very large .SQL file that was generated in a dump?
body: <p>I have a very large .SQL file, of 90 GB</p>
  
  <p>It was generated with a dump on a server:</p>
  
  <pre><code>mysqldump -u root -p siafi &gt; /home/user_1/siafi.sql
  </code></pre>
  
  <p>I downloaded this .SQL file on a computer with Ubuntu 16.04 and MySQL Community Server (8.0.16). It has 8GB of RAM</p>
  
  <p>So I did these steps in Terminal:</p>
  
  <pre><code># Access
  /usr/bin/mysql -u root -p
  
  # I create a database with the same name to receive the .SQL information
  CREATE DATABASE siafi;
  
  # I establish the privileges. User reinaldo
  GRANT ALL PRIVILEGES ON siafi.* to reinaldo@localhost;
  
  # Enable the changes
  FLUSH PRIVILEGES;
  
  # Then I open another terminal and type command for the created database to receive the data from the .SQL file
  mysql --user=reinaldo --password="type_here" --database=siafi &lt; /home/reinaldo/Documentos/Code/test/siafi.sql
  </code></pre>
  
  <p>I typed these same commands with other .SQL files, only minor ones, with a maximum of 2GB. And it worked normally</p>
  
  <p>But this 90GB file is processing for over twelve hours without stopping. I do not know if it's working</p>
  
  <p>Please, is there any more efficient way to do this? Maybe splitting the .SQL file?</p>