Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to save big data to database I extend the max_allow_packet and post_size but nothing happened.

the code and database released to production server and to stage server on production server is ok but on stage server not ok.

I think the problem not in code or database because they are the same on prod. and stage

so the problem will be in php conf, mysql conf or apache.


migration rejected from Oct 1 '13 at 17:03

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, Mat, Paul White, RolandoMySQLDBA, Mark Storey-Smith Oct 1 '13 at 17:03

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

What do you mean by "Not OK"? Can you see an error message? Can you see anything in the PHP, or Apache, or MySQL logs? – YaK Nov 5 '12 at 15:27
The issue is no errors no warnings just the page is submitted without any actions and no success msg. :( – Ayman Hussein Nov 5 '12 at 15:29
Ayman, you must provide with some diagnostics from the MySQL server; just saying your PHP page is submitted gives no insight into what happens on the DB. Can you see, for example, the query being run on MySQL (SHOW PROCESSLIST)? Is it in the slow log? – Shlomi Noach Nov 6 '12 at 9:27
Turn on your sql general log. Run the insert by hand. Etc. – Alain Collins Nov 6 '12 at 21:09