I am a CTO with over 5 years of experience in start-up and over 10 years in working at managing position for big companies. I am also a full-stacks developer with over 12 years in system design, product development and technology product deployment. User experience and system security are the things I care about most.
Backup MySQL database with mysqldump
Option 1: mysqldump an entire mysql instance
Everything written in one file: table structures, indexes, triggers, stored procedures, users, encrypted passwords. Other mysqldump options can also export different styles of INSERT commands, log file and position coordinates from binary logs, database creation options, partial data (–where option), and so forth.
mysqldump -h... -u... -p... --hex-blob --routines --triggers --all-databases | gzip > MySQLData.sql.gz
What to Do If You Forget Your Android Phone’s PIN, Pattern, or Password
Android secures your device by asking you for a PIN, pattern, or full password. What happens if you forget the security method you set up? If you’re lucky, you can get back in easily—but that may not be possible. Even if you use a fingerprint or Face Unlock to secure your Android phone, neither of […]
How to Install and Use ADB, the Android Debug Bridge Utility
ADB, Android Debug Bridge, is a command-line utility included with Google’s Android SDK. ADB can control your device over USB from a computer, copy files back and forth, install and uninstall apps, run shell commands, and more. We’ve covered some other tricks that require ADB in the past, including backing up and restoring your smartphone […]
How to Add a Website to the Home Screen on iPhone and Android
Your Android phone, iPhone, or iPad home screen isn’t just for apps. Whatever device you’re using, you can add a website shortcut to the home screen for easy access. In some cases, you can even make the website work like an app. How to Add a Website to the Home Screen on iPhone or iPad […]