How to Import Database SQL & Configure Apache .htaccess Rewrites

A step-by-step guide to importing the MySQL database structure and ensuring clean URL routing works properly.

Importing Large SQL Files

If phpMyAdmin shows a timeout or file size error:

• Compress the .sql file into a .zip or .gz before uploading in phpMyAdmin.
• Alternatively, import via command line / SSH:

  mysql -u username -p database_name < database.sql

• Ensure database collation is set to utf8mb4_unicode_ci.

Enabling Apache mod_rewrite

ScriptNest uses clean URL routing (e.g. /project/slug instead of /project.php?slug=...). Ensure your server has mod_rewrite enabled and your virtual host has AllowOverride All.