Utilisation de phpMyAdmin
Backing Up Your Database
- First, navigate to your phpMyAdmin page via cPanel or whatever alternative administration system your host provides i.e. Plesk etc. and log in.
- From the dropdown box on the left (or the text link) click on your OpenCart database to show all the fields.
- In the main page, click on the 'Export' tab.
- Make sure the main 'Structure' 'select all' and 'Data' boxes are ticked.
- In the right box, make sure 'Add drop table', 'Add AUTO_INCREMENT value' and 'Enclose table and field names with backquotes' are ticked.
- select the SQL format in the 'export' column'.
- Tick 'Save as file'.
- If you want the backup file compressed, tick either 'zipped' or 'gzipped'.
- Click 'Go' to save your file - the preferred location would be your own PC - saving a backup on a host server could be problematic should the server hard drive fail. It's always better to have your own backup locally!
Restoring a backup
On the phpMyAdmin main page - Click on the 'SQL' tab at the top and browse to the location of your backup file. Then select 'Go' from the tab at the bottom right corner of the screen - you may need to empty your existing database before you can restore the backup however normally you don't as the backup will simply overwrite the existing database.
Emptying your database
On the PhpMyAdmin main page - Click on the 'Structure' tab at the top and browse to the botom of the page. Then select 'Check All' and from the drop-down choose 'Empty'. Select 'Yes' to empty the database.