Need to Truncate a table and populate the rest of the tables
-
I have a .sql file. the file size is 401MB. i found that a table say 'pauseddetailes' which stores the values and more than 1,00,000 records which has to be archived periodically but it is not. Due to this i couldn't import the file in MySQL , phpMyadmin. i need to truncate the table 'pauseddetails' and then import the rest of the data in the db. This particular table is independent and doesn't have any foreign key constraint. I tried increasing the value of the upload size , execution time and memory size in php.ini file still didn't work out. Is there any possible way. Looking for the solution. Thanks in advance.
-
I have a .sql file. the file size is 401MB. i found that a table say 'pauseddetailes' which stores the values and more than 1,00,000 records which has to be archived periodically but it is not. Due to this i couldn't import the file in MySQL , phpMyadmin. i need to truncate the table 'pauseddetails' and then import the rest of the data in the db. This particular table is independent and doesn't have any foreign key constraint. I tried increasing the value of the upload size , execution time and memory size in php.ini file still didn't work out. Is there any possible way. Looking for the solution. Thanks in advance.
what you are not able to do, Truncate or addition of new data ? Whats the error ?
Mark the answer as accepted if that worked for you :). And for down-voters please specify the reason to improve the solution :).