search

stephane-rbn / soundbase

Free online audio distribution platform that enables its users to upload, promote & share their originally-created sounds
MIT License
5 stars 0 forks source link

Make table names lowercase #16

Closed angristan closed 6 years ago

angristan commented 6 years ago

How to update your DB:

mysqldump -u root -p soundbase > soundbase-uppercase.sql
sed 's/`\(\w\+\)`/\L&/g' soundbase-uppercase.sql > soundbase-lowercase.sql
mysql -u root -p
drop database soundbase;
create database soundbase;
use soundbase;
source soundbase-lowercase.sql