Backup & Restore
mysqldump, EK, database, (ya, specific, tables) ka, SQL, backup, CREATE, karta hai — TEXT-BASED, SQL, statements, ke, roop, mein, JO, DOBARA, RUN, karke, data, RESTORE, kiya, ja, sakta hai.
mysql, command, se, backup, file, RESTORE, ki, ja, sakti, hai — SCHEDULED, backups, (jaise, CRON, JOB, se, daily) production, systems, mein, ZAROORI, HAIN.
# Backup:
mysqldump -u root -p myapp > backup_2024-01-15.sql
# Restore:
mysql -u root -p myapp < backup_2024-01-15.sql
# Sirf specific tables:
mysqldump -u root -p myapp users orders > partial_backup.sql- mysqldump = SQL-format, backup, create, karta, hai
- mysql, command, se, backup, restore, ki, ja, sakti, hai
- Scheduled, backups, (cron, se), production, ke, liye, ZAROORI, HAIN
--single-transaction, flag, InnoDB, tables, ka, CONSISTENT, backup, leta, hai, BINA, tables, ko, LOCK, kiye — production, systems, PAR, backup, lete, waqt, ZAROORI, hai, taaki, applications, block, na, hon.
mysqldump --single-transaction -u root -p myapp > backup.sqlBinary, logs, (binlogs) HAR, change, ko, RECORD, karte, hain — daily, mysqldump, backup, ke, saath, binlogs, combine, karke, KISI, BHI, SPECIFIC, TIMESTAMP, tak, restore, kiya, ja, sakta hai, sirf, daily, snapshots, tak, LIMITED, na, rehke.