Damn, selalu aj lupa yg satu ini. Mending gw tulis aj deh.. Backup mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] sample : mysqldump -u sadmin -p pass21 Customers > custback.sql Restoremysql -u USER -p DBNAME < dump.sql
Problem : wanna convert a plain password in a field in mysql into md5 formatSolution :1. export mysql selected field to text2. convert field md5 hows? ok start solution 1 : SELECT password INTO OUTFILE ‘C:/result.txt’LINES TERMINATED BY ‘\n’FROM users; explanation :– password : the field u want to export-users the table solution 2 : …
Convert a plain password in a field in mysql into md5 format Read More »
Hari ini (18/01/2008) SUN resmi mengakuisisi MySQL senilai US$ 1 miliar.Kaget setengah mampus gua.. Lah wong selama ini banyak ngembangin applikasi pakai MySQL.Lah trus kalau di beli SUN gmn kl jadi Licensed? Kacau kan. Taro deh misal jadi dual license seperti misal Redhat (Enterprise & Fedora Core) tetep aja ga enak. Yang open sourcenya pasti …
