Difference between revisions of "PhpMyAdmin"
From Phoenix Cart User Guide
PeterRobert (talk | contribs) |
PeterRobert (talk | contribs) |
||
| Line 8: | Line 8: | ||
*Log in to the database through your host server account - they will provide instructions on how to do this. | *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: | *To restore a complete database or install a SQL file: | ||
| − | **Click the '''Import''' tab. | + | **Click the '''Import''' tab in phpMyAdmin. |
**Click <span class="btn-input">Choose File</span> | **Click <span class="btn-input">Choose File</span> | ||
**Navigate to the SQL file | **Navigate to the SQL file | ||
**Click Open to upload the file. | **Click Open to upload the file. | ||
| − | **Click <span class="btn-input">Go</span> to run the SQL file. | + | **Click <span class="btn-input">Go</span> in phpMyAdmin to run the SQL file. |
*SQL can also be run as a single statement not contained in a file. | *SQL can also be run as a single statement not contained in a file. | ||
| Line 18: | Line 18: | ||
UPDATE configuration SET sort_order = '310' WHERE configuration_key = 'VALUE'; | UPDATE configuration SET sort_order = '310' WHERE configuration_key = 'VALUE'; | ||
| − | *Click the '''SQL''' tab. | + | *Click the '''SQL''' tab in phpMyAdmin. |
*Paste ('''Ctrl+V''' on keyboard) the previously copied SQL statement into the input box. | *Paste ('''Ctrl+V''' on keyboard) the previously copied SQL statement into the input box. | ||
| − | *Click <span class="btn-input">Go</span> to run the SQL statement. | + | *Click <span class="btn-input">Go</span> in phpMyAdmin to run the SQL statement. |
Revision as of 11:41, 21 October 2019
<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 in phpMyAdmin.
- Click Choose File
- Navigate to the SQL file
- Click Open to upload the file.
- Click Go in phpMyAdmin 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 in phpMyAdmin.
- Paste (Ctrl+V on keyboard) the previously copied SQL statement into the input box.
- Click Go in phpMyAdmin to run the SQL statement.
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.
All other content is the reserved Intellectual Property and Copyright of phoenixcart.org
