Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/lavocat.quebec/private_html/scripts/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

#!/usr/bin/env node

// MySQL Database Backup Script for lavocat.quebec
const fs = require('fs');
const path = require('path');
const { execSync } = require('child_process');

const BACKUP_DIR = '/home/gositeme/backups/lavocat.quebec';
const DB_NAME = 'gositeme_avocat';
const DOMAIN = 'lavocat.quebec';

console.log('💾 Starting MySQL database backup for lavocat.quebec...');

// Create backup directory if it doesn't exist
if (!fs.existsSync(BACKUP_DIR)) {
  fs.mkdirSync(BACKUP_DIR, { recursive: true });
  console.log('✅ Created backup directory');
}

// Generate backup filename with timestamp
const timestamp = new Date().toISOString().replace(/[:.]/g, '-');
const backupFilename = `mysql-production-${timestamp}.sql`;
const backupPath = path.join(BACKUP_DIR, backupFilename);

try {
  // Check if mysqldump is available
  try {
    execSync('which mysqldump', { stdio: 'ignore' });
  } catch {
    console.error('❌ mysqldump is not installed. Please install MySQL client tools.');
    process.exit(1);
  }

  // Create backup
  console.log('📋 Creating MySQL database backup...');
  
  // Use the actual database credentials
  const mysqlUser = process.env.MYSQL_USER || 'gositeme_avocat';
  const mysqlPassword = process.env.MYSQL_PASSWORD || 'TDZEMAwNvFznSKQeDkjY';
  
  let mysqldumpCommand;
  if (mysqlPassword) {
    mysqldumpCommand = `mysqldump -u ${mysqlUser} -p${mysqlPassword} --single-transaction --routines --triggers ${DB_NAME} > "${backupPath}"`;
  } else {
    mysqldumpCommand = `mysqldump -u ${mysqlUser} --single-transaction --routines --triggers ${DB_NAME} > "${backupPath}"`;
  }
  
  execSync(mysqldumpCommand, { stdio: 'inherit' });
  
  // Get file size
  const stats = fs.statSync(backupPath);
  const fileSizeInMB = (stats.size / (1024 * 1024)).toFixed(2);
  
  console.log('✅ MySQL database backup completed successfully!');
  console.log(`📁 Backup file: ${backupPath}`);
  console.log(`📊 File size: ${fileSizeInMB} MB`);
  
  // Clean up old backups (keep last 10)
  console.log('🧹 Cleaning up old backups...');
  const files = fs.readdirSync(BACKUP_DIR)
    .filter(file => file.startsWith('mysql-production-') && file.endsWith('.sql'))
    .map(file => ({
      name: file,
      path: path.join(BACKUP_DIR, file),
      mtime: fs.statSync(path.join(BACKUP_DIR, file)).mtime
    }))
    .sort((a, b) => b.mtime - a.mtime);
  
  // Keep only the last 10 backups
  if (files.length > 10) {
    const filesToDelete = files.slice(10);
    filesToDelete.forEach(file => {
      fs.unlinkSync(file.path);
      console.log(`🗑️  Deleted old backup: ${file.name}`);
    });
  }
  
  console.log(`📊 Total MySQL backups: ${files.length}`);
  
} catch (error) {
  console.error('❌ Backup failed:', error.message);
  console.log('💡 Make sure MySQL is running and credentials are correct');
  process.exit(1);
}

// Optional: Create a compressed backup
const createCompressedBackup = () => {
  try {
    const compressedFilename = `mysql-production-${timestamp}.sql.gz`;
    const compressedPath = path.join(BACKUP_DIR, compressedFilename);
    
    console.log('🗜️  Creating compressed backup...');
    execSync(`gzip -c "${backupPath}" > "${compressedPath}"`, { stdio: 'inherit' });
    
    const stats = fs.statSync(compressedPath);
    const fileSizeInMB = (stats.size / (1024 * 1024)).toFixed(2);
    
    console.log('✅ Compressed backup created!');
    console.log(`📁 Compressed file: ${compressedPath}`);
    console.log(`📊 Compressed size: ${fileSizeInMB} MB`);
    
    // Clean up uncompressed backup
    fs.unlinkSync(backupPath);
    console.log('🗑️  Removed uncompressed backup');
    
  } catch (error) {
    console.error('❌ Compressed backup failed:', error.message);
  }
};

// Create compressed backup if requested
if (process.argv.includes('--compress')) {
  createCompressedBackup();
}

console.log('\n📋 Backup completed successfully!');
console.log('💡 To restore from backup:');
console.log(`   mysql -u [username] -p [database_name] < "${backupPath}"`);
console.log('💡 To create compressed backup:');
console.log('   node scripts/backup-mysql.js --compress');
console.log('💡 Set MySQL credentials as environment variables:');
console.log('   export MYSQL_USER=your_username');
console.log('   export MYSQL_PASSWORD=your_password');