Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Create the database if it does not exist mysql -u root -p -e "CREATE DATABASE IF NOT EXISTS myapp_db;" -- Restore from dump file mysql -u root -p myapp_db < myapp_full_2025-05-02.sql -- Restore from compressed dump gunzip -c myapp_db_2025-05-02.sql.gz | mysql -u root -p myapp_db -- Restore with FK checks disabled (SQL inside the dump) -- SET FOREIGN_KEY_CHECKS=0; (add at top of dump file if needed)
Result
Open