To backup\export a database from your QWK.net Shared Hosting account you will need your login credentials. 

1. Go to customers.qwk.net, click on account management and log in.

2. Once you are in your control panel, locate and click on the phpMyAdmin icon.

3. Click the Launch icon to the right of the specific database you want to back up.

4. Select the database that needs to be exported from the drop down box (located on the left hand side)

* "information_schema" is the default database and is not the database you created.  If you would like you could back up this database as well.

5. Click the Export tab on the top.

·         Export Method: Quick - display only the minimal options

·         Format: SQL

6. Click Go.

·         This will display the database in SQL format

·         Copy the text that is displayed

·         Paste the text into notepad

·         Save the file with the extension .sql

This article will outline the steps required to create a MySQL Database on your QWK.net Shared Hosting Account. You will need your login credentials to create this database.

1. Go to customers.qwk.net, select Account Management and log in.

2. Scroll down and click the MySQL Server icon.

3. Here you will see a list of any existing MySQL databases already on your account. At the bottom there will be the words 'Add Database', click add.

4. Enter the name of your database and click next.

• The database name will be youraccount_whatyouspecify, you will want to keep track of this as it will be the database name that you give any software that syncs to this database.

5. Now you will be asked to set up a user name, password, and user role. After filling out all of the information click 'Add user'.

• User name: youraccount_whatyouspecify, again you will need the full user name for your MySQL Database to operate properly.
• Password: Keep track of this, as you will need to provide it to any software you want to sync to the database.
• User role: Please give some thought to what role you give the user, if you need help understanding what the different roles are feel free to refer to this article.

6. Click finish and you are done. The last thing you will want to make note of is the Host Name at the top of the page, you will need this information to connect any software to your database.
 

Permissions are very important to protecting your data from being compromised. If you are using bad code to talk to your database certain malicious users can insert or inject SQL code that can allow them access to your database or wipe out all of your data. The best practice for permissions is to understand what an application requires and allow it exactly what it needs.

• If it is an RSS reader then all it needs is read access, if it is a forum application it may need read/write to update posts.
• Larger applications like WordPress and Joomla need DBA rights due to things they do during their install.

The difference between the three levels of permissions is what a user is allowed to do:

• Read: This user can execute commands like SELECT and FROM. These commands only display and/or read data.
• Read/Write: This user can execute commands like SELECT and INSERT INTO. These commands can both read and write data.
• DBA: This user can execute all commands of the previous users but can also do DROP, ALTER, and CREATE. These commands can create database structure.

When installing applications, it is best to use the DBA as they typically need to create tables. After an application is installed you can create other users with read/write access and grant them permission to access the database, thus adding a layer of security to your Database application.

You will need your QWK.net Shared Hosting account login credentials.

1. Go to customers.qwk.net, click on account management and log in.

2. Click on the phpMyAdmin icon.

3. Click the launch icon next to the database you wish to dump.

4. Log in, these will be the credentials that your programs use to access this database (Not your QWK.net Shared Hosting account credentials).

• Please refer to this article if you need help creating a new user to access your database.

5. Click the export link in the menu under localhost.

6. Select the database(s) that you wish to export under the Export field. You do not want to export the 'information_schema'.

7. Also on this screen you will see all of your options for exporting the file. There is no limit to how many exports you need to do, so if you export into the wrong file type you can easily come back and dump it again.

• You will likely want to check the box next to 'Save as file' so that you have a literal file on your FTP rather than having a screen pop up with all of the database information.

8. Once all of your options are selected hit 'Go' at the bottom right of the screen.

This article will outline the steps to create and grant permissions to users for your Databases on your QWK.net Shared Hosting Account. To complete these steps you will need the Database Name and your QWK.net Shared Hosting Account login credentials.

1. Go to customers.qwk.net, click on account management and log in.

2. Select the MySQL Server icon.

3. Select the Database that you need to create a user for.

4. On the bottom field you will see all database users that currently exist on that Database, click the 'add' icon to create a new user.

5. Here you will be able to either create a new user or grant permissions to a user that was created for a different Database, click Add/Grant.

• Be careful when determining what permissions to grant your user. Please refer to this article for information on what these permissions allow.
• Make sure to keep track of what you choose for a user name and password so that you can give the information to the program that will be using the Database.

6. Once the user has been added/granted permissions, they will show up in the Database Users field.

To upload a database to your QWK.net Shared Hosting account you will need your login credentials and an empty database to upload the old database file to. If you need help creating a new database, please refer to this article.

1. Go to customers.qwk.net, click on account management and log in.

2. Click on the PHPMyAdmin icon.

3. Sign into the new database.

4. Click the Import link.

5. Click 'browse' to find the database file on your machine.

6. Click submit.

• Depending on how large your database file is, it may take a few minutes to upload. 
• You will be notified if there are any errors.

7. After a successful upload you will receive a confirmation message.