<p>Loading nav data</p>

By Nabeel

• February 27, 2010

phpVMS comes with a set of navigation data, in the install folder. There are two files:

• navdata.sql
• navdata.sql.gzip

The gzip'd version is the same as the .sql verison, it's just zipped, since it may be easier to import as it being compressed.

How to install?

When you download the zip file, there is one SQL file included. You have to import this either in phpMyAdmin or on the command line. View this page for more instructions (scroll to "Restoring your MySQL Database). Below that are instructions for phpMyAdmin as well. I recommend doing it from the command line, if possible, since it is a rather large file - close to 100,000 entries, at about 6mb total.

From the command line:

mysqlimport -uYOUR_DB_USERNAME -pYOUR_DB_PASSWORD DB_NAME navdata.sql

Using an import utility

If you can't import using one of the methods above, you can use Big Dump (heh heh) utility. It's just one file which you upload, and point to the navdata.sql file.

Table Prefix

If your table prefix differs from the default "phpvms_", import the navdata.sql file, then change the name of the table to "YOURPREFIXnavdata". For example, if your table prefix is "vms_", run the following on the MySQL command line:

RENAME phpvms_navdata TO vms_navdata

Alternatively, you can use phpMyAdmin (select the table, then "Operations" -> "Rename Table")