Skip to:
Content
Pages
Categories
Search
Top
Bottom

Backup, Import & Export? Non-deletable scraps on FTP??

  • Avatar of dwpers
    dwpers
    Participant

    @dwpers

    So, I decided to take the plunge and upgrade from WPMU 2.8.4 and BP 1.01 to the latest WPMU 2.8.6 and BP 1.13.

    Before upgrading, I decided to backup my entire MySQL table using the WP DB Backup tool – http://www.ilfilosofo.com/blog/wp-db-backup – and it create a .sql.gz file.

    However, when I go to Tools -> Import to get all my data (posts, pages, members, blogs, etc) back, it only wants a WXR file. Do I have to import my backup using phpMyAdmin or another such tool?

    The second part of my question would be why do I have some folders leftover from the upgrade that are unable to be removed from my FTP? These folders/files are located in wp-content/blogs.dir/ with numbered folders contained within containing a dated folder 2009, Avatars and an album folder with images within.

    I only noticed this because I thought I had deleted all my files off my server before doing a manual install/upgrade. Yet when I logged in for the first time, my old profile picture from my last install was displaying. I’m using a new DB, so that tipped me off to look at the FTP. When I try to delete these folders I receive the following error:

    550 Delete operation failed.

    : /./public_html/private-beta/wp-content/blogs.dir/1/files/avatars/3/megskins4e98321fc3b9afc78de35aa4d524a43f-avatar2.jpg

    Any idea? Thanks :)

Viewing 10 replies - 1 through 10 (of 10 total)
  • Avatar of Xevo
    Xevo
    Participant

    @xevo

    http://discussion.accuwebhosting.com/database-management/418-how-mysql-database-backup-restore-procedure-phpmyadmin.html

    Try re-logging with your FTP, not sure what FTP program you use, but mine (FileZilla) sometimes shows old files that I already removed with wordpress. Also check the chmod, not really sure if it can block you from removing files, but just to be sure, change it to 777.

    Tools > Import is nothing to do with importing SQL. If you have an SQL file, you can import it using something like phpMyAdmin.

    Blogs.dir is made by the user account/group that your web server runs. You *may* be able to CHMOD/CHOWN it to your account and then delete it. If you can’t or don’t know how, ask your host to do it for you.

    Avatar of Andrea Rennick
    Andrea Rennick
    Participant

    @andrea_r

    If you’re just *upgrading* you do not need to remove anything under wp-content, including blogs.dir. That will remove all the user’s uploads.

    (just in case anyone else reading thinks they have to do this)

    Avatar of dwpers
    dwpers
    Participant

    @dwpers

    @Xevo and @DJPaul – I’ve tired both of these solutions, looks like I’ll have to contact my host, however, since I’m on a dedicated server, it’s harder to get support from GoDaddy for some reason :-/

    @DJPaul – I’ll see if I can import everything through phpMyAdmin and not lose any data!

    @Andrea_r – By upgrading, I meant I decided to start over by deleting the DB and everything off the FTP and starting fresh, since I mistakenly edited the core files of the previous version of MU/BP and didn’t make it into a theme, so all my work was broken anyways for the new version.

    Thanks for the help everyone :)

    Avatar of Andrea Rennick
    Andrea Rennick
    Participant

    @andrea_r

    Then you’re reinstalling, not upgrading. :)

    I know it sounds like a semantic argument, but I’m hoping to head off future thread where someone has deleted all their content trying to upgrade. :)

    Avatar of dwpers
    dwpers
    Participant

    @dwpers

    Hmm, maybe you can help me with this problem…

    I imported my .sql backup and it imported successfully, however, when I load my website, it loads a blank page.

    Any idea? haha :)

    If you dumped and imported the entire database… there are a number of settings that could cause your newly installed site not to work… such as url and domain settings and installed plugins… that kind of thing.

    Also… how is it that you are on a dedicated box and can’t delete things? I assume if you’re on a dedicated box that you would have root access.

    Avatar of dwpers
    dwpers
    Participant

    @dwpers

    Hmm, perhaps I will just try to import user accounts then…

    Regarding the FTP server, I don’t know, I have root access and can do practically everything on the server, however, for some reason I cannot get rid of these old files and directories.

    EDIT: Looks like the uploaded DB deactivated my custom theme, so all I had to do was reactivate it and the site is back up now :). So far so good. Thanks everyone.

    Which files and dirs can you not delete and what are their owners and groups? They might be set to apache:apache… but if you SFTP in using your root user and password… you should be able to delete anything.

    Avatar of dwpers
    dwpers
    Participant

    @dwpers

    I’ll give it a go, thanks again David!

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

You must be logged in to reply to this topic.