我希望自动更改SQL转储（无需知道原始数据库名称）-因此，如果SQL转储说，例如...

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;

我希望它自动扫描文件中的所有CREATE DATABASE行，并追加mysql以显示为prefix_mysql
对于文件中的所有CREATE DATABASE记录-这可能吗？-我可以在这里找到数据库名称，但不知道如何将它们联系在一起

find . -name \*.sql -type f -exec bash -c '
echo "found $# sql dumps"
for file; do
dbnames=( $(grep -Poe "CREATE DATABASE [^\`]*\`\K[^\`]*" "$file") )

printf "\n          file: %s\n" "$file"
printf "%2s database(s): %s\n" "${#dbnames[*]}" "${dbnames[*]}"

done
> ' 'find-sh' {} +

也尝试过

read -p "enter the cPanel username: " cpuser
cd "/home/$cpuser/public_html"
dbnames=($(grep $sqldump -Poe "CREATE DATABASE [^\`]*\`\K[^\`]*"))
for i in ${dbnames[@]}; do sed -i "s/$i/$cpuser_$i" $sqldump; done

无论我得到什么;

sed: -e expression #1, char 11: unterminated `s' command
sed: -e expression #1, char 13: unterminated `s' command
sed: -e expression #1, char 13: unterminated `s' command