ν‹°μŠ€ν† λ¦¬ λ·°

β†˜ Database/β”— Mysql

[ Mysql ] λ°μ΄ν„°λ² μ΄μŠ€ λ€ν”„μ‹œ μ—λŸ¬ 해결방법 "The user specified as a definer ('user'@'%') does not exist" when using LOCK TABLES

Kithub 2019. 8. 28. 10:55
λ°˜μ‘ν˜•

μ•„λž˜ μ˜΅μ…˜μ„ μΆ”κ°€ 

--single-transaction

 mysqldump -d --single-transaction -uroot -p1234 testdb > testdb.sql

 

λ°˜μ‘ν˜•

'β†˜ Database > β”— Mysql' μΉ΄ν…Œκ³ λ¦¬μ˜ λ‹€λ₯Έ κΈ€

[ Mysql ] ν•œμ»¬λŸΌμ„ 리슀트둜 뽑기(with GROUP BY , GROUP_CONCAT)  (1) 2019.09.23
λŒ“κΈ€