Entire database is not exporting from phpmyadmin in Xampp

Question

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

Please tell me the way to export the entire database.

Answer 1

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.

Answer 2

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