Maximum number of rows from a mysql import

0

Well, I'm importing all my database, since I changed the computer, I exported it from the old one, and I want to import it into the new one, but when I import, I get an error: "tempo limite alcançado, envie novamente o arquivo para continuar" . Something like that, I've already increased the upload limit, the maximum execution time, I've done the tutorial for this site: link
But I did not get results, somebody can help me, the amount of lines in my file .sql is 635.374 , there are all states, cities, and neighborhoods. I think it should be because of the large number of lines, does anyone have a suggestion? Thank you.

    
asked by anonymous 01.07.2017 / 23:03

1 answer

1

It was a bit confusing, but if I understood correctly, you are trying to import your old database into your new server through phpmyadmin and you are getting a timeout. You can increase the timeout of your PHP on your new server if you have access to php.ini this will work 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 server new.

Here is a page with an explanation of how to use mysqldump: link I hope this is helpful.

    
03.07.2017 / 00:01