PhpMyAdmin - Revision history

PeterRobert at 05:19, 25 March 2021

2021-03-25T05:19:39Z

2021-02-07T09:47:39Z

2021-02-07T09:44:07Z

2021-02-07T09:43:00Z

2019-12-22T15:43:00Z

2019-11-27T09:00:00Z

2019-10-27T18:08:51Z

2019-10-27T18:06:25Z

2019-10-27T18:06:21Z

2019-10-27T18:04:03Z

@@ Line 1: / Line 1: @@
-<span class="btn-grey"><historylink type="back">&#129032; Back</historylink></span>
+<div class="btn btn-grey btn-back">{{#fas:arrow-left}} Back</div> <div class="btn btn-grey btn-faq">{{#fas:question-circle}} FAQ Tips & Tricks</div>
 <hr>
 *Different database software is run on different host servers but they will all operate in essentially the same way - one of the most common is '''phpMyAdmin'''.

← Older revision		Revision as of 09:47, 7 February 2021
Line 35:		Line 35:
	**Click the '''Export''' tab.		**Click the '''Export''' tab.
	**Click <span class="btn-input">Go</span> to download.		**Click <span class="btn-input">Go</span> to download.
		+	**Alternatively click the '''Custom''' button for more options before clicking <span class="btn-input">Go</span> to download.

@@ Line 9: / Line 9: @@
 ----
 *Log in to the database through your host server account - they will provide instructions on how to do this.
 *You will see this:
@@ Line 33: / Line 35: @@
 **Click the '''Export''' tab.
 **Click <span class="btn-input">Go</span> to download.
 ----
 *SQL can also be run as a single statement not contained in a file.
 **It might look something like this:

← Older revision		Revision as of 09:43, 7 February 2021
Line 28:		Line 28:
	**Click <span class="btn-input">Go</span> in phpMyAdmin (shown bottom right in the screenshot) to run the SQL file.		**Click <span class="btn-input">Go</span> in phpMyAdmin (shown bottom right in the screenshot) to run the SQL file.

		+
		+	*To back up a complete database:
		+	**Click on the database name shown in the top left menu.
		+	**Click the '''Export''' tab.
		+	**Click <span class="btn-input">Go</span> to download.

	----		----

@@ Line 34: / Line 34: @@
   UPDATE configuration SET sort_order = '310' WHERE configuration_key = 'VALUE';
 *Log in to the database
-*Click on the database name shown in the top left menu.
+*Click on the database name shown at the top of the tables list in the left panel.
 *Click the '''SQL''' tab in phpMyAdmin to see this:
 <div class="mainpage_box">

@@ Line 24: / Line 24: @@
 </div>
 **Click <span class="btn-input">Choose File</span>
-**Navigate to the SQL file
+**Navigate to the SQL file on your local computer.
 **Click Open to upload the file.
-**Click <span class="btn-input">Go</span> in phpMyAdmin to run the SQL file.
+**Click <span class="btn-input">Go</span> in phpMyAdmin (shown bottom right in the screenshot) to run the SQL file.

@@ Line 19: / Line 19: @@
 [[File:phpmyadmin2.png|link=|1500px]]
 </div>
-**Click the '''Import''' tab in phpMyAdmin.
+**Click the '''Import''' tab in phpMyAdmin to see this:
 **Click <span class="btn-input">Choose File</span>
 **Navigate to the SQL file
@@ Line 30: / Line 33: @@
 **It might look something like this:
   UPDATE configuration SET sort_order = '310' WHERE configuration_key = 'VALUE';
+*Log in to the database
-*Click the '''SQL''' tab in phpMyAdmin.
+*Click on the database name shown in the top left menu.
 *Paste ('''Ctrl+V''' on keyboard) the previously copied SQL statement into the input box.
 *Click <span class="btn-input">Go</span> in phpMyAdmin to run the SQL statement.

@@ Line 15: / Line 15: @@
 </div>
 *To restore a complete database or install a SQL file:
-**Click on the database name shown in the top left menu.
+**Click on the database name shown in the top left menu to see this:
 **Click the '''Import''' tab in phpMyAdmin.
 **Click <span class="btn-input">Choose File</span>