This tutorial guides you through importing a MySQL script into MySQL Query Browser and phpMyAdmin. A .SQL script file is provided in a number of WebAssist products to give you the necessary database tables and structure without you needing to do any of the work.
Steps are provided for two of the most common MySQL database management applications. If you do not know which tool you should use, check to see if your Hosting Provider provides a phpMyAdmin control panel with your hosting package. In most cases, this should provide all the functionality you will need.
Note: As listed below in the Getting started section, an empty MySQL database is recommended. However, as long as your database does not contain any of the tables that are to be created by the .SQL script, everything should import fine.
To get started, you will need:
phpMyAdmin is commonly used for managing MySQL databases. Many hosting providers, such as GoDaddy, provide this tool for making database modifications. Although various hosting providers use different versions of phpMyAdmin, the steps shown here should be consistent throughout.
MySQL Query Browser is part of the MySQL GUI Tools available at
http://mysql.com/. These same steps can be used for most other MySQL administrator tools.