PhpMyAdmin

<historylink type="back">🠈 Back</historylink> 🠉 FAQS TIPS & TRICKS

---

• Different database software is run on different host servers but they will all operate in essentially the same way - one the most common is phpMyAdmin.
• SQL (Structured Query Language) code or statements are used to communicate with the database.
• There is usually no requirement to access or edit the database but it may be necessary to restore a previously backed up database or run some SQL to set up new database entries and update some existing database entries as part of a Phoenix update or additional module installation.
• Ensure that you have made a database backup prior to running any SQL.
• Log in to the database through your host server account - they will provide instructions on how to do this.
• To restore a complete database or install a SQL file:
  • Click the Import tab.
  • Click Choose File<.span>
  • Navigate to the SQL file
  • Click Open to upload the file.
  • Click Go to run the SQL file.

• SQL can also be run as a single statement not contained in a file.
  • It might look something like this:

UPDATE configuration SET sort_order = '310' WHERE configuration_key = 'VALUE';

• Click the SQL tab.
• Paste (Ctrl+V on keyboard) the previously copied SQL statement into the input box.
• Click Go to run the SQL statement.

---

This page is in progress
Please visit again soon for additions and changes

Phoenix Cart User Guide, like CE Phoenix Cart, is free to use but is maintained by unpaid volunteers.

Code references are licensed under a Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales License.
All other content is the reserved Intellectual Property and Copyright of phoenixcart.org