![\"Backup](\"\/graphics\/wordpress\/backupandrestore\/backup_1.jpg\")
<\/p>\nThis desciption is applicable to all the applications PHP-eSeller, PHP-SecureArea and PHP-KeyCodes.<\/p>\n
You should backup your database at regular intervals. You will then be able to restore the database if something goes wrong.<\/p>\n
phpMyAdmin is the name of the program that you can use to manipulate databases.\u00a0 It is usually provided as part of you control panel from your hosting company.<\/p>\n
1.\u00a0 Log into your web server control panel to access phpMyAdmin<\/p>\n
2. Select ‘Databases’<\/p>\n
<\/p>\n
3. Now click the name of your database.<\/p>\n
![\"Backup](\"\/graphics\/wordpress\/backupandrestore\/backup_2.jpg\")
<\/p>\n
4. The next screen will show you all the tables inside your database.\u00a0 Click the ‘Export’ tab on the top set of tabs.<\/p>\n
![\"Backup](\"\/graphics\/wordpress\/backupandrestore\/backup_3.jpg\")
<\/p>\n
5. Look at the left box at the top of the Export section. All the tables in the database you selected are in that box.<\/p>\n
![\"Backup](\"\/graphics\/wordpress\/backupandrestore\/backup_4.jpg\")
<\/p>\n
* If you have other programs that use the database, then choose only those tables that correspond to your install. In the case of PHP-eSeller, they will be the ones with that start with “ipn_”, with PHP-SecureArea they are the ones that start with “sec_” and with PHP-KeyCodes, they are the ones that start with “key_”
\n* If the database is being used only by the one program, then, leave it as is (or click ‘Select All’ if you changed the selection)
\n* Ensure that SQL is checked.<\/p>\n
6. In the SQL section, tick the following boxes:<\/p>\n
* ‘Structure’
\n* ‘Add DROP TABLE’
\n* ‘Add AUTO_INCREMENT’ and
\n* ‘Enclose table and field names with backquotes’<\/p>\n
7. In the DATA section, leave the boxes inside this section unticked, but make sure to keep the checkbox next to the “DATA” heading checked.<\/p>\n
![\"Backup](\"\/graphics\/wordpress\/backupandrestore\/backup_5.png\")
<\/p>\n
8.\u00a0 Tick the ‘Save as file’ option, and leave the template name as is.<\/p>\n
![\"Backup](\"\/graphics\/wordpress\/backupandrestore\/backup_6.jpg\")
<\/p>\n
9. Now click ‘Go’ and you should be prompted for a file to download. Save the file to your computer.\u00a0 Depending on the database size, this may take a few moments.<\/p>\n
10. You have now backed up your database.\u00a0\u00a0 If you wanted, you could download a backup in each of the compression formats. Your choice. For example: None<\/strong> and “zipped<\/strong>”<\/p>\n Remember : You have not backed up your files or images.\u00a0 Only the database itself.<\/p>\n","protected":false},"excerpt":{"rendered":" This desciption is applicable to all the applications PHP-eSeller, PHP-SecureArea and PHP-KeyCodes. You should backup your database at regular intervals. You will then be able to restore the database if something goes wrong. phpMyAdmin is the name of the program…<\/span><\/p>\n