import MySQL 1.2GB database

4

I'm having a hard time importing it into the process halfway.

How long does it take to import a 1.2GB MySQL base into a Core 2 Duo with linux?

    
asked by anonymous 19.06.2015 / 14:29

2 answers

0

I've already solved the problem. In fact, I had given a dick to process through the terminal and it was in an infinite execution ...

I exported through the MySQL Workbench and everything worked fine.

    
02.07.2015 / 18:53
0

To import large tables the best way is through the command line with .sql files. If you are trying to load a phpmyadmin from life it will be tricky, I do not recommend it.

To do this, connect to mysql using the following command:

mysql -u usuario_do_bd -p base_de_dados_a_ser_utilizada(opicional) < path/to/file.sql
    
30.06.2015 / 19:25