The database is not exporting completely from phpmyadmin in my local server xampp.

Please tell me the way to export the entire database.

  • Please add some more information. Are some tables missing or the file cuts in some point. If so is it always in the same place or does it differ and sometimes you receive a little more.
    – Zefiryn
    Jun 9 '17 at 10:37
  • Which operation system are you used? Jun 9 '17 at 10:59

I have added the following lines at the bottom of php.ini file on my project

max_input_vars = 5000
suhosin.request.max_vars = 5000
suhosin.post.max_vars = 5000

After added this, You must restart your Apache server.


Run this command through terminal.

mysqldump -h localhost -u root -p mydemo123 > mydatabase.sql

  • -h = Host Name
  • -u = User Name
  • mydemo123 = Database Name
  • mydatabase.sql = Set file name with .sql extension
  • sorry can you please tell me how to run this command
    – user51829
    Jun 9 '17 at 10:08
  • Run this command through terminal. Jun 9 '17 at 10:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy