Help : Maximum execution time of 300 seconds exceeded

Hi,

WE have a table in database called "table_user_details which has records of 215 odd new users .
We want to import some old users (7000) into this to make approximate 7125 users.
However using import command but getting error (Fatal error: Maximum execution time of 300 seconds exceeded

Also the problem is the sql backup is of the entire old database not this table only. How do I get just this table from the file to import.

Dont have much knowledge of ssh etc.

Regards
Rajiv

 

Please search before posting: http://forums.digitalpoint.com/showthread.php?t=342917

About your second question, well, why don't you export only the table you need from your old DB?

 

use bigdump and try once

if u have ssh just login to mysql console and import that sql file

 

open the big sql file in text editor like notepad. Copy only the insert statements of the table you want and paste it into a new notepad. save it with a different name and import the new file

Thanks

Lavee