Importing SQL Files into PHPMyAdmin

From Citadel Servers Wiki
Jump to navigation Jump to search
This Guide Will Show You How To Import .SQL Files into PHPMYADMIN

First, login to your PHPMYADMIN interface:

Logi1n.png


Once logged in, you should see this screen:


Loginscreen.png


After that, select the database name on the top left, and then click the import button:


Importscreen.png



After that, go find the .sql file you're looking to import:


Uploaded file.png


NOTE: Some .SQL files have the following lines in them and need to be removed or edited

"USE `essentialsmode`" or just "CREATE DATABASE IF NOT EXIST `nameofdb`"

Change these to match the database name, or just delete them and save the file before importing.


Upon importing the .sql file, you should see a screen like this to confirm the upload was successful:


End result.png






If you did not get a screen like this, please review you file for the problem that will be listed in the MYSQL import screen, or contact Citadel Servers personell for assistance.