At the moment, WP-Filebase does not offer any automatic backup function. Here’s how to create a backup of all file meta data and settings:
- Open phpMyAdmin (if you don’t know where to find it, ask your hosting provider) and navigate to the Database where WordPress is installed.
- Click on the “SQL” Tab and execute the followong SQL query:
SELECT * FROM `wp_options` WHERE `option_name` IN (
'wpfb_css',
'wpfilebase',
'wpfilebase_ftags',
'wpfilebase_list_tpls',
'wpfilebase_ptpls_cat',
'wpfilebase_ptpls_file',
'wpfilebase_rsyncs',
'wpfilebase_tpls_cat',
'wpfilebase_tpls_file'
)
Adjust the table prefix if it’s different than the default wp_! - Select all rows appearing in the results. Then choose “Export” below the table.
- Choose SQL as format and click OK. Depending on your phpMyAdmin settings, a download starts or the SQL is displayed in the browser. In this case, copy all text and save it in a text file.
- Go back to the Database, click on the “Export” tab, choose “Custom” for “Export Method”.
- Select the following tables (note that the table prefix might differ from yours):
wp_wpfb_cats
wp_wpfb_files
wp_wpfb_files_id3
wp_wpfb_rsync_meta - Under “Output” choose “Save output to a file”, click “Go” and save the text file.
The backup file from step 4 includes the settings and templates, the other file all file meta data, categories, ID3 file info and RemoteSync data.
These backup files only includes the meta data, not the actual files! You have to backup your upload path using your FTP client!
Restore
- Use phpMyAdmin’s Import function to restore the meta data and settings from both text files.
- Make sure that the upload path in WP-Filebase settings is set correctly and copy all files from the backup (or old site when migrating) to that folder, keeping the directory structure.
- Run a Sync
- Run “Fix File Pages” Tool, to re-build file pages.
Worked great except that it found even the thumbnail versions and listed them as separate file. Here is the old site as it should look: http://screencast.com/t/5PYXbxKGKU and here is the new site: http://screencast.com/t/qxdFuwvM. Notice that the new site has listed the individual thumbs. I guess I’ll have to manually delete the thumb files?
The path on the old server is ‘wp-content/blogs.dir/5/files/filebase’ and the new one is ‘wp-content/uploads/sites/9/filebase’. Please advise. Thanks!
If thumbnails appear as normal files, the migration of table “wp_wpfb_files” from Step 6/7 did not work correctly.
Before restoring, clear all MySQL tables from Step 6. The import the tables and before running the sync, make sure the files appear correctly.
You can change the upload path in WP-Filebase settings after Restore Step 1. After restoring the data from the text files, set the new path in WP-Filebase / Settings / Common.
Maybe this screen capture would better explain the discrepancy between the two WPMU sites: http://screencast.com/t/6qDmp7V740y – hrnerr.thewordpressdesigner.com (on right) is the right number of file at 252.
How does it look like before running the sync after migration?
Do the sync results list any missing files?
Hi Fabian,
Having a difficult time porting my Filebase fields and tables across. I have followed your instructions to the T. Basically once completed all above instructions, the fields, categories and files in the DB are present. But once I run the sync, Filebase deletes each of my FTP’d files one by one.
I could really use some help on this.
Many thanks,
Jared