A database sql file when exported in phpmyadmin, fails

[Riley]

When I'm trying to export a database SQL file in PHPMyAdmin it fails. I show the following error message:

Your output is incomplete, due to a low execution time limit on PHP level

I don't know what else to do..

[Hadley]

Have you tried configuring php.ini?

[Elliott]

Hi, Riley
Either you can use mysql commandline or you need to increase memory_limit in your php.ini.

[Nimbus]

I had facing the same problem. You can the following solution to export of your SQL database/table(s):

Open command prompt and paste this:

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

If your windows OS is installed on C drive, Then apply your own info in this line and paste it too:

mysqldump -u username -p databasename > filename.sql

Note: username is root by default.

Also you can define a particular table like following:

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

Here is an example:

• Open CMD
• Write cd C:\wamp\bin\mysql\mysql15.5.8\bin
• Then write mysqldump -u root -p uk clients > H://NameOfClients.sql

[Aiden]

Which OS are you using?
Which web server are you using? Xampp or Wamp?

[Riley]

Which OS are you using?
Which web server are you using? Xampp or Wamp?

Sorry, I forgot to mention it. I'm using Windows 10.
And I'm trying to export a Magento database by using Wamp.

@Nimbus
Thanks for your help. It worked!

[Ravi Kumar]

Increase execution Time

Hi,
increase the execution time., then try again. or if possible post screen shot when error page comes.

[davidstephan]

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

Click here, to know more about this:-

http://stackoverflow.com/questions/3...ails-localhost