A complete list of Region 1 DVDs is available for download from the Home Theater Info site. The comma-separated version of this list is ideal for importing into your MySQL database. To create a MySQL table matching the columns of this comma-separated DVD list, download this file: tableCSV.sql and use it instead of the table.sql file supplied with the script.

  Using the data from the list of all Region 1 titles, you can create a new file containing only the DVDs in your collection. This is done by either manually copying and pasting the desired lines from the complete list into a new file; or by using a spreadsheet program to import the complete DVD list, and then exporting only the desired rows to a new file.

  Once you have created this new file, you would then import it directly into your MySQL table for use with phpDVD. For example, let's assume that you have named this file mydvds.txt and that you wish to import it into a MySQL table named dvds (which is the default table name used by phpDVD.) Using the shell MySQL client, you would first have to log on to the MySQL server:

mysql -u username phpdvd -p

You can then use these commands to import the mydvds.txt file into the dvds database:

load data local infile 'mydvds.txt' into table dvds
fields terminated by ','
enclosed by '"'
lines terminated by '\n';

quit;