Maximum number of rows of a Mysql import

Question

Well, I am making the import that contains all my databases, because I switched from computer, I exported from old and I want to import to new, but when importing I get an error: "tempo limite alcançado, envie novamente o arquivo para continuar". Something like, I already increased the upload limit, the maximum running time, I made the tutorial of this site: http://pt.stealthsettings.com/importa-baze-de-date-mari-sql-schimband-marimea-limita-de-upload-2048-kib-din-phpmyadmin.html
But I got no result, someone can help me, the amount of lines in that my file .sql is of 635.374, there are all states, cities, and neighborhoods. I think it must be by the great amount of lines, someone has a suggestion? Thank you.

Answer 1

Your question got a little confused but if I understand correctly, you are trying to import your old database to your new server through phpmyadmin and are receiving a timeout. You can increase the timeout of your PHP on your new server if you have access to php.ini this will get around the problem or if you have access to the shell generate a dump of your database on the old server and import via command line on the new server.

Here is a page with an explanation of how to use mysqldump : http://sistemas.cekurte.com/blog/mysqldump-backup-de-base-de-dados-mysql/ I hope this will be useful.