Thanks so much for your continued support.
Sure thing. So, attempting to follow the instructions here:
The first step is to export the database. I do indeed have access to the command line (or so I think). MySQL is installed onto a Windows Server 2008 R2 virtual machine and I have access to the “MySQL 5.7 Command Line Client” with this.
I have entered the required password when accessing and now have access to the CMD line utility for MySQL.
The DB was installed when installing Moodle some time ago – I can’t remember the exact steps I’m afraid.
I am connecting from the same machine (logged on via RDP to the Windows 2k8R2 virtual server.
Yes, I attempted to simplify the process by connecting to the DB using XAMPP (which integrates PHPMyAdmin if I am correct?) However, because there were now two versions of MySQL on the server this was causing conflict – I couldn’t fathom out how to safely remove the old MySQL and switch to use XAMPP to run the current Moodle DB successfully. So I gave up on that idea.
Apart from that, stop the XAMPP MySQL service from the XAMPP control panel so it doesn't interfere with the MySQL service running your Moodle database, and start the shell interface from the XAMPP control panel. After that try running the command below
mysql -u your-moodle-db-user -p your-moodle-db-name -e "show tables;"
It will prompt your for the password of the Moodle database user. Also ensure that the MySQL service in which the Moodle database is located is up and running so the command above can connect to the correct MySQL service.
Thank you – I have tried that, and nothing appears to happen – I don’t get an error, it doesn't ask for a password and it doesn’t display any tables. Could this be something to do with the Moodle DB being set to "mysqli"?
This is an output from my Moodle “config.php” file if that helps at all:
// 1. DATABASE SETUP
// First, you need to configure the database where all Moodle data //
// will be stored. This database must already have been created //
// and a username/password created to access it. //
$CFG->dbtype = 'mysqli'; // 'pgsql', 'mariadb', 'mysqli', 'mssql', 'sqlsrv' or 'oci'
$CFG->dblibrary = 'native'; // 'native' only at the moment
$CFG->dbhost = 'localhost'; // eg 'localhost' or 'db.isp.com' or IP
$CFG->dbname = 'moodle_db'; // database name, eg moodle
$CFG->dbuser = 'moodle_db'; // your database username
$CFG->dbpass = 'password_here'; // your database password
$CFG->prefix = 'mdl_'; // prefix to use for all table names
$CFG->dboptions = array(
'dbpersist' => false, // should persistent database connections be
// used? set to 'false' for the most stable
// setting, 'true' can improve performance
'dbsocket' => false, // should connection via UNIX socket be used?
// if you set it to 'true' or custom path
// here set dbhost to 'localhost',
// (please note mysql is always using socket
// if dbhost is 'localhost' - if you need
// local port connection use '127.0.0.1')
'dbport' => '3307', // the TCP port number to use when connecting
// to the server. keep empty string for the
// default port