dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: phpMyAdmin Export deletes rows from db?

  1. #1
    Join Date
    Apr 2006
    Posts
    26

    phpMyAdmin Export deletes rows from db?

    Hi,

    Hope this is the correct forum to ask this question.

    I was exporting a wordpress database from phpmyadmin and it timed out so I thought I'd export half the tables then the other half and import them on the new server one after the other.

    This worked fine or so I thought. Then I was informed that lots of posts were missing. I thought there must have been a problem when I did the export so I went back into the original phpmyadmin and they weren't there (only posts older than Dec 2010). I am wondering if anyone has ever experienced this?

    Can an phpmyadmin export actually cause loss of data? I see that not only the posts but the comments related to those posts are gone too. very strange and I can't figure out why. I can't fix this other than copy n paste from google cache but I'm interested to know if its even possible for this to happen from an sql export.

  2. #2
    Join Date
    Jul 2010
    Location
    /ramdisk/
    Posts
    865
    I suppose it can happen. I never had trouble with PMA, although it DOES give you the option to delete them. bummer, keep backups ... this happens. I deleted my javascript folder today and was like *ooohh shh*, but I backup all the time and had a working copy. Then made another backup anyways just because

    If you want to export them with a solid tool- try mysqldump. I have noticed that PMA does odd things when it times out (max_execution_time is the php_value that determines this I think).

    Try contacting the system/server admin/support. Ask or beg them for backups, if it doesn't work, tell them that they pushed PMA on you even though you were hesitant. Ask for a mysqldump or a copy of all the .frm files for your database (make sure you know what your database name was).
    Last edited by eval(BadCode); 07-11-2011 at 05:31 PM.

  3. #3
    Join Date
    Oct 2010
    Location
    Ohio
    Posts
    233
    Obviously I don't know your server, but both of my servers (one is inmotion one is godaddy) both allow me to run database back ups (in the form of mysqldump files) that save to the server itself. This is particularly nice when the database is very very large as it prevents the HTTP timeout response.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles