Last updated December 7, 2009. Created by cel4145 on May 3, 2006.
Edited by LeeHunter, arianek, bekasu, winston. Log in to edit this page.
Backup your Drupal files
Using your FTP client, download all your existing Drupal files to your hard drive and put the files in a folder called 'backup'.
Backup your database with phpMyAdmin
- Log in to PHPMyAdmin.
- Select your database from the dropdown box on the left.
If you are upgrading a test site, choose your test site database. - Click the "Export" tab
- Click "select all"
- Make sure to check the "structure" and "data" checkboxes
- Check "Save as File" desktop
- Click the "Go" button and save the .sql file to your desktop. Let's put it in the same 'backup' folder where you backed up your Drupal files.
This page is much a much more verbose/detailed how-to:
And it links to this visual phpMyAdmin how-to:
Comments
If using BigDump to upload on a restore
If one is limited by their ISP via a runtime limit in the size of files being uploaded a good work around is using a script like BigDump (http://www.ozerov.de/bigdump.php) which is a staggered MySql dump importer.
If so, there are a couple of additional things to check and uncheck on the original save, or the restore may not work properly.
In Structure make sure all four boxes are checked. By default some versions do not check Add DROP TABLE/VIEW/PROCEDURE/FUNCTION.
In Data make sure Extended inserts is unchecked. Again I've come across it being checked by default.