Determining the Database Your Miva Store is Using on Linux

This articles goes over how to figure out what MySQL database your Miva store is using. This is for Miva Merchant on our shared and Dedicated servers.  To view more information on these solutions, please review http://www.hosting.com/services/platform-services.

1. Login to the server via SSH
2. Run the following command:
   1. updatedb&
3. Run the following command until it says the last command is completed:
   1. jobs
4. Once step 3 shows completed, run the following command:
   1. locate merchdb.dat
5. Change directories to the path of the merchdb.dat that is in the parent directory of your web root. For example, if /home/mysite/public_html/ is your webroot and /home/mysite/mivadata/merchdb.dat is a result, change directories to /home/mysite/mivadata.
6. Open merchdb.dat in a text editor. The syntax of its contents are as follows:
   1. mysql|userName@localhost|database_Name|username_Password|
7. The database_Name is the value you need to determine the database tied to this particular Miva store.