Setting Up SQL Yog

Welcome! Please note that although the steps below are customized for Moodle, you can certainly use them for other Web 2.0 tools like blogs, content management systems, as well as other databases. I encourage you to experiment, as well as adapt these materials under Creative Commons ShareAlike-NonCommercial copyright license.

1.  Setting Up SQLYog

1) Download SQLYog

2) A few screenshots of the installation (some are omitte):

2.  Working with SQLYog

1) Create a NEW Connection by clicking NEW button

When prompted for the name of the connection, type in LOCALHOST for the name or the domain name of the server where MySQL is installed.

2) You’ll be able to connect using these settings…note that it’s a good idea to setup a password for your MySQL…you can do that in your WAMP config files.

3) Once you are connected, you will be at the following screen:

4) To create a new database to house your Moodle tables(or any Web 2.0 app), you can press Ctrl-D or right-click on the root user and choose NEW DATABASE. For fun, let’s call it “Moodle” without quotes.

5) Enter the new database name in the pop-up menu.

6) Note that “Moodle” is now one of the databases that appears in our list. You can now shut down SQLYog since that’s all we needed it for—to create the Moodle database. While there are many other uses for SQLYog, this is it for now.

3.  Back Up Your Moodle Database

After you have installed Moodle successfully, you can use SQLYog to quickly backup your Moodle database. Here’s how:

1) Log in to your system by going to SQLYog, entering the appropriate admin/password and type in the name of your Moodle database (e.g. “Moodle” without quotes).

2) Right-click on the Moodle database and select BACKUP DATABASE AS A SQL DUMP

3) Choose “Moodle” from the left side (that’s the database container holding all your moodle related tables and data), then BROWSE to where you are going to save the file and give it a filename, as shown below:

4) In the case that your database is lost, or you are restoring from backup to a new server, you’ll see your Moodle database is missing.

4.  Restoring from Backup

5) At this point, you can simply right-click in the database area of SQL YOG and choose restore from SQL dump.

After you choose RESTORE FROM SQL DUMP, you will see the following screen:

Browse to your SQL dump file, wherever you saved it, and choose then click on EXECUTE.

You will see the following restore take place:

When the restore is complete, you will see something similar to the following:

Click CLOSE. Don’t be surprised if you don’t see the Moodle database in the list of databases. Disconnect and then re-connect…on re-connecting, you will see your restored database.

Subscribe to Around the