StoneCypher/How to load the WhatIsMyBrowser user agent database.md

## How to load the WhatIsMyBrowser user agent database.md

      
    Raw
  

              How to load the WhatIsMyBrowser user agent database.md
            
          
    How to load WIMB database
mysql -u your_user -p
(when prompted, put in password; now mysql prompt)
create database user_agents;
exit
mysql -u your_user -p user_agents < create-table-whatismybrowser_useragent.sql
mysql -u your_user -p user_agents -e "ALTER TABLE whatismybrowser_useragent DISABLE KEYS;"
mysql -u your_user -p user_agents < whatismybrowser-user-agent-database.sql
mysql -u your_user -p user_agents -e "ALTER TABLE whatismybrowser_useragent ENABLE KEYS;"