Differences

This shows you the differences between two versions of the page.

--- tutorials:server:db_backup [2008/10/26 03:39]
jonyo created
+++ tutorials:server:db_backup [2014/09/25 16:55] (current)
@@ Line 1: / Line 1: @@
 ====== Backing Up your Database ======
-Hosting companies will typically perform database backups for all of the databases on your server on a daily basis. Please check with your hosting company's policies for details regarding their database backup procedures. We recommend performing your own database backup using a program such as phpMyAdmin. If phpMyAdmin is already installed on your server (usually accessed through your domain's control panel) you can perform the steps below to run your own database backup. If phpMyAdmin is not currently installed on your server, you can install it yourself by downloading the latest stable copy from http://www.phpmyadmin.net and following their installation instructions.
+Hosting companies will typically perform database backups for all of the databases on your server on a daily basis.  If your host has this service you are most likely charged for it.  Then if you actually need to restore a backup to your site there could be a service fee involved and if not they may simply provide a backup that is only usable in the same backup program as the one they used to get that backup.  Read the fine print with your host or ask them questions.  Please check with your hosting company's policies for details regarding their database backup procedures.  Because these costs and procedures we suggest you perform your own backup regularly using a program such as phpMyAdmin. If phpMyAdmin is already installed on your server (usually accessed through your domain's control panel) you can perform the steps below to run your own database backup. If phpMyAdmin is not currently installed on your server, you can install it yourself by downloading the latest stable copy from http://www.phpmyadmin.net and following their installation instructions.  If you have to install phpmyadmin yourself the information you need to insert into phpmyadmin to connect to your database is within the config.php file in the root directory of your Geo installation.
-After logging into phpMyAdmin on your server, please follow the steps below to perform a backup of your database. Each step is marked with a numbered "green arrow" to help guide you through this very simple process.
+After logging into phpMyAdmin on your server, please follow the steps below to perform a backup of your database. Each step is marked with a numbered "green arrow" to help guide you through this process.
+<tip c h>The page layout and required steps may vary slightly depending upon the version of phpMyAdmin that is installed on your site.</tip>
-note NOTE: The page layout and required steps may vary slightly depending upon the version of phpMyAdmin that is installed on your domain.
+  - Select the database name you want to backup from the dropdown list in the left side of your screen.{{:tutorials:server:myadmin_1.gif|}}
+  - When the screen refreshes you will see a list of tables that are currently present within the database you just selected. The same set of table names will display on both sides of the screen. You will also see several tabs at the top of the screen. Click on the "Export" tab.{{:tutorials:server:myadmin_2.gif|}}
+  - When the screen refreshes (see image below for reference) click on the "Select All" link. All of the tables in the Export box will then be highlighted in blue.
+    * If you have the //ZipSearch Addon// installed, de-select((hold down CTRL and left click to de-select)) the table named **geodesic_zip_codes** (it should be at the very end of the list).  ((Since this table is so huge and the data itself never changes, you do not need to back up this table.  If you ever need that table restored, just re-install the ZipSearch Addon.))
+  - Next, make sure that the "SQL" radio button is selected.
+  - Some versions of phpMyAdmin will allow you to choose SQL export compatibility. If yours does, choose **MYSQL323** from the dropdown. Otherwise, skip this step.
+  - Next, check the "Add DROP TABLE" box so that your exported tables will contain drop tables (This is extremely important step).
+  - Check the "Save as file" box. This will allow you to save the file to a location on your pc, rather than simply displaying the export on your screen.
+  - Finally((Well, almost finally)), click the "Go" button.
+  - You will then see a popup box asking you what to do with the data you are wanting to save. Select "Save to Disk" and then "OK" ((These exact terms may vary depending upon the browser you are working with.)) Now choose the location on your PC that you want to save the file to.
+When the process has finished, you will have a complete backup file of your database's tables in an SQL format. Essentially, what you have created is a "snapshot" of your database at that given time to be rerun at a later time if needed. That's all there is to it. Congratulations...you have just backed up your database.
-Step 1:
-Select the database name you want to backup from the dropdown list in the left side of your screen.
-myadmin_1
-Step 2:
-When the screen refreshes you will see a list of tables that are currently present within the database you just selected. The same set of table names will display on both sides of the screen. You will also see several tabs at the top of the screen. Click on the "Export" tab.
-myadmin_2
-Step 3:
-When the screen refreshes (see image below for reference) click on the "Select All" link. All of the tables in the Export box will then be highlighted in blue.
-note NOTE: The main purpose of backing up your database is to back up the tables that are constantly changing as users register and as you make changes in the admin panel. Because of this, we recommend that you do not "export" the table associated with the ZipSearch Module (if installed) since it does not change. The ZipSearch Module table is quite large which will make your exported file more difficult to manage later if you need to "recover" your database for some reason. So, once you have highlighted the all of tables in this step, you can then scroll down in the list and "deselect" the ZipSearch table (CTRL - Left Click). It is usually the last table in the list:
-geodesic_zip_codes
-Step 4:
-Next, make sure that the "SQL" radio button is selected.
-Step 5:
-Some versions of phpMyAdmin will allow you to choose SQL export compatibility. If yours does, choose "MYSQL323" from the dropdown. Otherwise, skip this step.
-Step 6:
-Next, "check" the "Add DROP TABLE" box so that your exported tables will contain drop tables (This is extremely important step).
-Step 7:
-Check the "Save as file" box. This will allow you to save the file to a location on your pc, rather than simply displaying the export on your screen.
-Step 8:
-Finally, click the "Go" button.
-You will then see a popup box asking you what to do with the data you are wanting to save. Select "Save to Disk" and then "OK" (These exact terms may vary depending upon the browser you are working with.) Now choose the location on your pc that you want to save the file to. When the process has finished, you will have a complete backup file of your database's tables in an SQL format. Essentially, what you have created is a "snapshot" of your database at that given time to be rerun at a later time if needed. That's all there is to it. Congratulations...you have just backed up your database.
-myadmin_3
+{{:tutorials:server:myadmin_3.gif|}}

Geodesic Solutions Community Wiki

User Tools

Site Tools

Differences

Page Tools