Setting Up SQL Yog
2) A few screenshots of the installation (some are omitte):
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.
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.
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.