Exporting a database in phpmyadmin fails (localhost)

Question

When I try to export a database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete, due to a low execution time limit on PHP level" .

I don't know what to do..

Answer 1

I experienced the exact problem already. According to comments (windows, wamp, mysql), here is a solution to get an export of your database/table(s):

Open CMD and paste this:

cd C:\wamp\bin\mysql\mysql15.5.8\bin

If your windows is installed into C drive, Then apply your own information in this line and paste it too:

mysqldump -u username -p databasename > filename.sql

Note: username is root by default.

---

Also you can determine a particular table like following:

mysqldump -u username -p databasename tablename1 tablename2 > filename.sql

---

Here is an example:

1. Open CMD
2. write cd C:\wamp\bin\mysql\mysql15.5.8\bin
3. Then write mysqldump -u root -p univercity students > H://TheNameOfStudents.sql

Answer 2

PhpMyAdmin is a php application. (I should change my username to Obviousman.)

It's running out of time exporting your table.

You need to change a line in the file called php.ini.

If you're running WAMP on your own Windows box, you might find it at a path like C:\wamp\bin\apache\apache2.4.9\bin. But you have to look for it.

If you're using a hosting service, use their knowledge base or call their support and ask how to change php.ini.

look for the line called max_execution_time, and make its value bigger.