1) Download the composer.phar and then download the package using the following command. https://new.drupal.org/download 
php composer.phar create-project drupal/cms
2) Check and move /web/sites/default/files/2024-12 & media-icons from manual to zip.
9) Delete utf8mb4_0900_ai_ci collation from sql as it restricts the installation on MariaDB.
3) Delete this table inserts from following tables cachetags, cache_access_policy, cache_bootstrap, cache_config, cache_container, cache_data, cache_default, cache_discovery, cache_entity, cache_menu, cache_render. Drupal creates it on login.
5) Do not change "default_config_hash" from sql since it remains same across installations for same version.
4) No need to generate system.js_cache_files and drupal_css_cache_files. It's same for all install.
6) Set the value for temporary as s:0:"" in `config` table for "system.file" row. On our servers we get it as /tmp but on some servers /tmp is not accessible due to open_basedir which causes temporary file creation issue. So if we set it as empty Drupal will generate it automatically when needed(Not needed since version 8.8.0).
7) Remove serialized entries of "twig_extension_hash" and "twig_cache_prefix" from key_value table as it creates itself.
2) Delete all watchdog INSERTS And also change its AUTO INCREMENT =1 ; 
8) PHP REQUIREMENT LINK: https://www.drupal.org/docs/system-requirements/php-requirements as of drupal 11.x
https://new.drupal.org/docs/drupal-cms/get-started/install-drupal-cms/move-your-site-to-a-hosting-provider
10) The script is throwing error on ampps even in manual. Hence we have restricted it
11) [IMP] Keep putenv function in settings.php as it is required to set the gobally installed composer path.
12) [IMP] Download composer.phar everytime and copy it in our path. This is to give composer path in settings.php file when global path is empty.