Using phpMyAdmin

We assume that you already have an SQL dump/schema file of your database on your computer, or you have it uploaded on your hosting account with us. To import the MySQL database using phpMyAdmin, please follow these steps: 1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article. 2. In phpMyAdmin, navigate to the Databases tab, and select the database in which you want to import the SQL dump. 3. Click on the Import tab. 4. On the next screen, you will see the Import options. You can import an uncompressed SQL dump file, or a file compressed in .zip, .gzip, or .bzip2 format. In case the SQL file is more than 20 MB, then you should use the database Import Wizard in the MySQL databases section of the hosting Control Panel. You can check the Importing a database article for additional information on using the Import Wizard. Click on the Browse button to select a file from your local computer. If the SQL file uses a character set other than UTF-8, you need to select the appropriate character set. In most cases you need to leave the default value of UTF-8. If the file is in format, other than SQL, select the appropriate format from the Format drop-down menu. 5. When ready to upload and import the file, click on the Go button.

1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article. 2. In phpMyAdmin, navigate to the Databases tab, and select the database that you want to export. 3. Click on the Export tab. 4. On the next screen, select the Custom option from the Export Method option list, and you will see a list with export options. Select all the tables that you wish to export from the Tables list.In the Output section, you need to select the Save output to file option. phpMyAdmin will suggest the appropriate character set, usually UTF-8. Select zipped or another export format from the Compression drop-down menu. Select SQL in the Format section. In the Format-specific options section, select Structure and data. In the Object creation options you need to make sure that the Add CREATE PROCEDURE/FUNCTION/EVENT statement option not selected. If you this option is left checked, you may receive an error when trying to import the database with a MySQL user that does not have permissions to create a database. 5. Click on the Go button.

1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article. 2. In phpMyAdmin, navigate to the Databases tab, and select the database in which you wish to execute SQL queries. 3. Navigate to the SQL tab. 4. On the next screen, type your SQL query in the Run SQL query/queries on database field. 5. Click on the Go button.

1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article. 2. In phpMyAdmin, navigate to the Databases tab, and select the database you wish to edit. 3. On the next screen, you will see a list of the tables in your MySQL database. You can perform operations such as drop, empty, optimize, repair, etc. on multiple tables by selecting the tables you want to manipulate and choosing the appropriate action from the With selected drop-down menu. You can also browse each table and edit the data in it by clicking on the name of the table. 4. After you click on a table, you will see the table structure and the data in it. You can use the Edit links to manage each table field.

1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article. 2. In phpMyAdmin, navigate to the Databases tab and select the database that you wish to copy. 3. Navigate to the Operations tab. 4. In the Copy database to field, type the name of the database in which you want to copy the data from the current database. You need to select Structure and data and uncheck the CREATE DATABASE before copying option. 5. Click on the Go button.

1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article. 2. In phpMyAdmin, navigate to the Databases tab and select the database in which you wish to search. 3. Navigate to the Search tab. 4. On the next screen, you will see the search menu. You need to type your search term in the Words or values to search for field and select the tables to search into. 5. Click on the Go button.