Database_only.sql May 2026
: It generates a standalone .sql file containing a dump of the site's database.
: It specifically leaves out application-level code, web assets (HTML/CSS/JS), or server-side configurations.
: INSERT INTO statements to populate the database with initial or backed-up data. DQL Commands : SELECT statements for data retrieval. pandas.read_sql — pandas 3.0.2 documentation - PyData | database_only.sql
: It is primarily intended for advanced users who wish to restore a database manually using tools like phpMyAdmin . 2. General SQL Usage
In the context of Akeeba Backup , is a specific backup profile option. : It generates a standalone
: These files are generally designed to be executed via a command-line interface or a database management tool (e.g., mysql -u user -p database < database_only.sql ). 3. Read-Only Access
: It typically contains the Data Definition Language (DDL) to create tables and Data Manipulation Language (DML) to insert records. DQL Commands : SELECT statements for data retrieval
: Unlike a "Full Site Backup," which includes an installer script and all site files, this option only produces the raw SQL data.