Announcement

Collapse
No announcement yet.

upload the dump file from PHPMyAdmin

Collapse

Ads on showthread pages

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

  • upload the dump file from PHPMyAdmin

    WordPress Hosting on SSD Servers
    To upload the dump file from PHPMyAdmin follow the steps below,

    1) Login to phpmyadmin
    2) Select the database
    3) Click on the link "SQL"
    4) Click on "choose" to browse the dump file from your local system (near the field "Or Location of the text file:")
    5) Click "go"

    Now the database should be updated.
    Last edited by admin; 08-17-2015, 10:48 AM.

  • #2
    ASP.Net Hosting starts @ $3.18/Mo.
    Re: upload the dump file from PHPMyAdmin

    I have never tried it with phpMyAdmin, but what I think could be a solution.
    1. Using phpMyAdmin, export the database into a SQL file (Check the 'Save as file' checkbox while exporting the database.)
    2. Create a password protected directory on your server.
    3. Now upload a PHP file to the same directory and disable its execution time out. Load the SQL statements from the SQL file and let the PHP script execute as a query.
    4. Once the database is imported delete the SQL file!

    I have not tested this method, but I think this should work smoothly. Do let me know if you are able to do it this way.
    Last edited by admin; 08-17-2015, 10:48 AM.

    Comment

    Working...
    X
    Sign up for a News Letter Click here to sign up