Big Database import

[pryce]

[TUTORIAL] How to backup database with mysqldump - EXPORT and IMPORT your database

MAKE A BACKUP | EXPORT 1. Get the privileges: Access your terminal via SSH with root 2. Create the backups folder and access the path: $ cd /home && mkdir db-backups && cd db-backups 3. Export your database: $ mysqldump -u [user-name] -p [db-name] > backup-my-db.sql 4. Confirm access: Enter the database password and wait for the export to complete. 5. Finally, simply access your files through SFTP in /home/db-backups/ and download your database. RECOVER A BAC…