[Snippet] (for VPS) Get Database Config from Settings.php

1
2
3
4
5
6
7
8

file_reading_from=$(echo "sites/default/settings.php");
database_str_line=$(cat "${file_reading_from}" | grep "'database' =>" | grep -v "*");
username_str_line=$(cat "${file_reading_from}" | grep "'username' =>" | grep -v "*");
password_str_line=$(cat "${file_reading_from}" | grep "'password' =>" | grep -v "*");
database=$(echo "${database_str_line}" | sed -n "s/'database' => '\([^']*\)'.*/\1/p");
username=$(echo "${username_str_line}" | sed -n "s/'username' => '\([^']*\)'.*/\1/p");
password=$(echo "${password_str_line}" | sed -n "s/'password' => '\([^']*\)'.*/\1/p");
echo -e "\n\n \e[1;31m File from: \t   ${file_reading_from} \e[0m \n \e[1;31m Database: \t ${database} \e[0m \n \e[1;31m Username: \t ${username} \e[0m  \n \e[1;31m Password: \t ${password} \e[0m \n\n";

1

mysqldump -u $username -p $database_name > _database_export.sql

1

mysql -u root -p DATABASE_NAME <"YOUR-FILE.mssql"