Solve sql database issue
Budget: $30 – $250 USD
Hi,
We need someone to solve this issue:
we can not complete the transfer as the wpr4_braapf_term_taxonomy_hierarchical table is too large to be imported on our shared servers. We already have consulted on the case with our system administrators and with our Supervisors for the problem and the only solution is for you or your developer to optimise the database and decrease the table significantly. The SQL query, which imports the table, has 44 350 586 characters:
and the import operation times out due to the significant length of the query. We can not increase the limitations on the shared server for the import to be completed as such actions might affect the other clients' websites on the server, which we can not allow. Also, any operation on the database afterwards might timeout as well and would prompt the limitations on the server to be increased permanently, which for the above reasons is not possible.
We need to solve this and also looking for a expert that we could work with long term. Someone that could work fast and simpel. You will have 2 days to solve this.
We need someone to solve this issue:
we can not complete the transfer as the wpr4_braapf_term_taxonomy_hierarchical table is too large to be imported on our shared servers. We already have consulted on the case with our system administrators and with our Supervisors for the problem and the only solution is for you or your developer to optimise the database and decrease the table significantly. The SQL query, which imports the table, has 44 350 586 characters:
and the import operation times out due to the significant length of the query. We can not increase the limitations on the shared server for the import to be completed as such actions might affect the other clients' websites on the server, which we can not allow. Also, any operation on the database afterwards might timeout as well and would prompt the limitations on the server to be increased permanently, which for the above reasons is not possible.
We need to solve this and also looking for a expert that we could work with long term. Someone that could work fast and simpel. You will have 2 days to solve this.