import 1.2GB Mysql database

Asked

Viewed 501 times

4

I’m having a hard time importing him into the process along the way.

How long it takes on average to import a 1.2GB Mysql base into a linux-based Core 2 Duo?

mysql
  • 2

    You can add the question to the way you’re importing?

  • Why the votes to close?

  • Which command you are using to import?

  • Your database contains large tables, or it is composed of a lot of small tables?

  • i use the command of mysqldump by the linux terminal, it contains medium tables.

2 answers

0


I already managed to solve the problem. In fact I had given a stick at the time of processing by the terminal and was in an infinite execution...

I exported it to Mysql Workbench and it all worked out.

0

To import large tables the best way is through the command line with .sql. files In case you are trying to load into a phpmyadmin of life it will be complicated, do not recommend.

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

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

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.