MySQL screwup

  • jlchrls

    (@jlchrls)


    15 years, 4 months ago

    Last month I changed my web host. I had downloaded my backup from the previous hosted site. Re-installed my blog. Initially when I tried to upload the backup SQL through PHPMyAdmin, I would get an error. The blog wasn’t too old so I wasn’t overly distraught at losing some 100 posts. But because I have been getting searches for some of those older posts, I thought I might try again.

    This morning I was able to upload the previous “mysql” folder from the backup, but it seems to have totally replaced all data since the re-install. I have been looking as to how I might reverse that process, in hopes that the data wasn’t deleted when I uploaded the older backup.

    Am I royally screwed? or can someone suggest what I can do.

    I currently use a plugin “WordPress Database Backup” and have it set to backup once a week and email me the folder. But I don’t find it in my email.

    Someone please help the ignorant!

Viewing 1 replies (of 1 total)
  • Moderator cubecolour

    (@numeeja)

    15 years, 4 months ago

    If you view the backup file in a text editor you’ll see lines which say:

    DROP TABLE IF EXISTS tablename;

    This means that rather than inserting data into the tables, the tables are dropped (deleted) then created and populated with the data.

    If you do not have a back up of the database before restoring over it, you cannot get it back unless your hosting company has made a recent backup – it might be worth asking their support team.

Viewing 1 replies (of 1 total)

The topic ‘MySQL screwup’ is closed to new replies.