phpMyAdmin Import

  • Resolved johnathan1707

    (@johnathan1707)


    16 years, 10 months ago

    Hi, last night I reinstalled wordpress for a friend, before I did I made a backup up his wordpress database through phpMyAdmin. When I installed wordpress I went to import, chose the SQL file and went but it was rtaking a few hours and showed no signs of stopping so I stopped it and decided to put it in in chunks rather than in one big go.
    So about 8 hours ago I put in 600 lines or so of SQL, the part containing the blog posts and it’s still running.
    I was wondering if there’s a faster way to do this, the SQL file itself is around 2.5MB.

    Thanks
    J.Barrett

Viewing 2 replies - 1 through 2 (of 2 total)
  • whooami

    (@whooami)

    16 years, 10 months ago

    sure, the faster way is to open the .sql file with a plain text editor, and copy and paste into the sql window.

    if you look at the file, the breaks are pretty evident.

    So about 8 hours ago I put in 600 lines or so of SQL, the part containing the blog posts and it’s still running.

    i doubt that. you just arent aware that its either done, or timed out.

    finally, you went to import where?

    you cannot import .sql files into wordpress through the wp-admin interface, if thats what you are trying to do.

    .sql dumps (backups) need to be imported through phpmyadmin or another tool that directly accesses the db.

    Thread Starter johnathan1707

    (@johnathan1707)

    16 years, 10 months ago

    I use phpMyAdmin import. Left it for around an hour, stopped it and some of the tables had been created and populated.
    I done the text-editor way, left it for 8 hours, might have times out be still appeared to be doing stuff. I got this sorted by going through the SQL and doing it in really small chunks, each table on it’s own and that worked.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘phpMyAdmin Import’ is closed to new replies.