Database_only.sql -
: Unlike a "Full Site Backup," which includes an installer script and all site files, this option only produces the raw SQL data.
: It specifically leaves out application-level code, web assets (HTML/CSS/JS), or server-side configurations. database_only.sql
: 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 : Unlike a "Full Site Backup," which includes
: 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 | DQL Commands : SELECT statements for data retrieval
: Provides an option to restrict queries to read-only access (only SQL SELECT statements allowed), which is sometimes categorized under "database only" permissions to prevent structural changes.
: It is primarily intended for advanced users who wish to restore a database manually using tools like phpMyAdmin . 2. General SQL Usage