These are the commands I use to load Metadot into the database, If you are using MySQL 5, modifications need to be applied to the Metadot DB.
If you are still getting errors when loading database could you post them here, we might be able to help you better if we have a error message.
Try these commands below, remember to change "yourpassword" to the password of your chioce.
cd /home/e-smith/files/ibays/Primary/html/default_data/
mysql -uroot mysql < createdbanduser4x.sql
mysql -e "grant all privileges on metadotdb.* to metadot@localhost identified by 'yourpassword'"
mysql -e "flush privileges"
mysql -umetadot -pyourpassword metadotdb < sampledata.sql
Good Luck, Russell
P.S. Working on an updated Metadot Howto, hopefully should be finished soon