Changes between Version 3 and Version 4 of faq/member-backup
- Timestamp:
- May 7, 2011, 5:02:29 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
faq/member-backup
v3 v4 11 11 }}} 12 12 13 1. Next you'll want to find out what your database password is. You'll do this by logging onto your site, navigating to the 'web/sites/default' folder, and downloading or reading the 'settings.php' file. That file will have a line with your database username and password in it in the following format:13 2. Next you'll want to find out what your database password is. You'll do this by logging onto your site, navigating to the 'web/sites/default' folder, and downloading or reading the 'settings.php' file. That file will have a line with your database username and password in it in the following format: 14 14 15 15 {{{ … … 18 18 }}} 19 19 20 1. Using the username and password in the settings.php file, navigate to the url of your primary host but add a '/phpmyadmin' to the end of that url and login:20 3. Using the username and password in the settings.php file, navigate to the url of your primary host but add a '/phpmyadmin' to the end of that url and login: 21 21 22 22 {{{ … … 24 24 }}} 25 25 26 1. Once you are in there will be the name of your database in the upper left-hand column. Click on your database name (not the one that says 'information_schema').26 4. Once you are in there will be the name of your database in the upper left-hand column. Click on your database name (not the one that says 'information_schema'). 27 27 28 1. In the main part of the page, you will see a series of tabs at the top of the page, click the tab that says 'Export'.28 5. In the main part of the page, you will see a series of tabs at the top of the page, click the tab that says 'Export'. 29 29 30 1. In the page you are taken to, all of your database tables will be selected by default (the box on the upper lefthand corner of that page). If you have a LARGE database and you want to minimise the risk of taking up too much memory, deselect the database tables that have 'cache' (IE: cache_views, cache_blocks, etc) and the 'sessions' table.30 6. In the page you are taken to, all of your database tables will be selected by default (the box on the upper lefthand corner of that page). If you have a LARGE database and you want to minimise the risk of taking up too much memory, deselect the database tables that have 'cache' (IE: cache_views, cache_blocks, etc) and the 'sessions' table. 31 31 32 1. The default settings in phpmyadmin will work for a basic backup. Navigate to the bottom of the page, CHECK the 'Save as file' button and choose 'gzipped' as your compression. Name the file something like 'mysite_020111.backup' (the numbers being a 6 digit date without punctuation). The program will add a '.sql' to the end of your file, and save it you your computer in the default download folder when you click save.32 7. The default settings in phpmyadmin will work for a basic backup. Navigate to the bottom of the page, CHECK the 'Save as file' button and choose 'gzipped' as your compression. Name the file something like 'mysite_020111.backup' (the numbers being a 6 digit date without punctuation). The program will add a '.sql' to the end of your file, and save it you your computer in the default download folder when you click save. 33 33 34 34 If your browser times out during this operation or you experience other issues, please submit a support ticket to Mayfirst People link and us know.