Skip to content

Instantly share code, notes, and snippets.

@StoneCypher

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

Last active February 26, 2020 19:37
Show Gist options
  • Save StoneCypher/ef13c9f893dfe41f7865222ab997eacc to your computer and use it in GitHub Desktop.
Save StoneCypher/ef13c9f893dfe41f7865222ab997eacc to your computer and use it in GitHub Desktop.
Download ZIP
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;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment