[Vuluts]

@youssefbasha go to the directory where your website is and then use the following command to backup your database.

mysqldump –u mysql_username –p[password] databasename > dump_file.sql

Ex. mysqldump –u root –prootpassword youssefbasha > backup.sql

This will dump your database "database_name" to "dump_file.sql" file.

To restore your database, grab the backup.sql and insert to your VPS

mysql database_name < database_backup.sql

Ex. mysql youssefbasha < backup.sql