diemorales
12/21/2015 - 6:54 PM

mysql more-> https://gist.github.com/hofmannsven/9164408

mysql more-> https://gist.github.com/hofmannsven/9164408

mysql.sql
content_copyfile_download
-- dump db
mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql

-- import db
mysql u -username -p database_name < database_name.sql

-- grant
GRANT ALL ON dbname.* TO root@'localhost';

-- update fk
ALTER TABLE `t_name` DROP FOREIGN KEY `fk_tname_col`;
ALTER TABLE `t_name` ADD CONSTRAINT `fk_tname_col` FOREIGN KEY (`col`) REFERENCES `t_name_2` (`id`) ON DELETE CASCADE;