Maintenance Page

Backup and Restore Commands.

  • mysqldump –user=? –password=? –host=localhost –port=3306 aircrafttrafficsurvey baseline_location | gzip > data/baseline_location_data.sql.gz
  • mysqldump –user=? –password=? –host=localhost –port=3306 aircrafttrafficsurvey baseline_location_batch_scorecard_results | gzip > data/baseline_location_batch_scorecard_results_data.sql.gz
  • mysqldump –user=? –password=? –host=localhost –port=3306 aircrafttrafficsurvey baseline_location_results | gzip > data/baseline_location_results_data.sql.gz
  • mysqldump –user=? –password=? –host=localhost –port=3306 aircrafttrafficsurvey flight_details_30_batch_agg | gzip > data/flight_details_30_batch_agg_data.sql.gz
  • c:\wamp64\bin\mariadb\mariadb10.3.14\bin\mysql –user=? –password=? –host=localhost –port=3306 aircrafttrafficsurvey < “C:\Users\rherson1\ServerBackup\analysis_band.sql_data.sql\analysis_band.sql_data.sql”
  • c:\wamp64\bin\mariadb\mariadb10.3.14\bin\mysql –user=?–password=? –host=localhost –port=3306 aircrafttrafficsurvey < “C:\Users\rherson1\ServerBackup\baseline_location_data.sql\baseline_location_data.sql”
  • c:\wamp64\bin\mariadb\mariadb10.3.14\bin\mysql –user=?–password=? –host=localhost –port=3306 aircrafttrafficsurvey < “C:\Users\rherson1\ServerBackup\baseline_location_batch_scorecard_results_data.sql\baseline_location_batch_scorecard_results_data.sql”
  • c:\wamp64\bin\mariadb\mariadb10.3.14\bin\mysql –user=?–password=? –host=localhost –port=3306 aircrafttrafficsurvey < “C:\Users\rherson1\ServerBackup\baseline_location_results_data.sql\baseline_location_results_data.sql”
  • c:\wamp64\bin\mariadb\mariadb10.3.14\bin\mysql –user=?–password=? –host=localhost –port=3306 aircrafttrafficsurvey < “C:\Users\rherson1\ServerBackup\flight_details_30_batch_agg_data.sql\flight_details_30_batch_agg_data.sql”

Pages: 1 2 3