Announcement

Collapse
No announcement yet.

A database sql file when exported in phpmyadmin, fails

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • davidstephan
    replied
    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

    Leave a comment:


  • Ravi Kumar
    replied
    Increase execution Time

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

    Leave a comment:


  • Riley
    replied
    Originally posted by Aiden View Post
    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!

    Leave a comment:


  • Aiden
    replied
    Which OS are you using?
    Which web server are you using? Xampp or Wamp?

    Leave a comment:


  • Nimbus
    replied
    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

    Leave a comment:


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

    Leave a comment:


  • Hadley
    replied
    Have you tried configuring php.ini?

    Leave a comment:


  • A database sql file when exported in phpmyadmin, fails

    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..
Working...
X