Backup and restore Database

Automate MySQL backup to AWS S3

Automating MySQL backup to AWS S3 serves a dual purpose of enhancing efficiency and fortifying data resilience. The automation process eliminates the need for manual backups, ensuring a consistent and reliable schedule for data protection. By leve...

8 months ago

3 min read

Restore MySQL Database

Restoring or import a MySQL database from a saved copy can be done using the 'mysql' command-line tool. Here's the basic syntax:mysql -u [username] -p[password] [database_name] < [filename.sql] '-u': Specifies the MySQL user. '-p': Pr...

8 months ago

4 min read

Topics

Mastering Nginx PHP-FPM essentials: Building high-performance PHP applications SSL/TLS encryption and certificate management with Certbot Secure your server with Fail2Ban SSH: Understanding the Secure Shell Compressing and archiving File and directory permissions Bash script Crontab Backup and restore Database