An admin interface that builds itself from the dbbasic modules you install; its pages follow file paths, like CGI.

0 downloads

Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-admin.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-admin.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-admin.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 Add automatic TSV discovery and admin handlers 5e2fd8f 1 year, 1 month ago History
backup.html · 26.2 KB · 652 lines
1<!DOCTYPE html>
2<html lang="en">
3<head>
4 <meta charset="UTF-8">
5 <meta name="viewport" content="width=device-width, initial-scale=1.0">
6 <title>Backup & Restore - DBBASIC Studio</title>
7 <link rel="stylesheet" href="../../static/css/admin.css">
8</head>
9<body>
10 <div class="studio-container">
11 <header class="studio-header">
12 <div class="logo">
13 <span class="logo-icon">⚡</span>
14 <span class="logo-text">DBBASIC Studio</span>
15 </div>
16 <div class="header-actions">
17 <span class="project-name">myblog/</span>
18 <button class="btn-icon" title="Deploy">🚀</button>
19 <button class="btn-icon" title="Settings">⚙️</button>
20 </div>
21 </header>
22
23 <div class="studio-layout">
24 <nav class="sidebar">
25 <a href="../../index.html" class="nav-item">
26 <span class="nav-icon">📊</span>
27 <span class="nav-label">Dashboard</span>
28 </a>
29 <a href="code.html" class="nav-item">
30 <span class="nav-icon">💻</span>
31 <span class="nav-label">Code</span>
32 </a>
33 <a href="database.html" class="nav-item">
34 <span class="nav-icon">🗄️</span>
35 <span class="nav-label">Database</span>
36 </a>
37 <a href="posts/list.html" class="nav-item">
38 <span class="nav-icon">📝</span>
39 <span class="nav-label">Posts</span>
40 </a>
41 <a href="users/list.html" class="nav-item">
42 <span class="nav-icon">👥</span>
43 <span class="nav-label">Users</span>
44 </a>
45 <a href="themes.html" class="nav-item">
46 <span class="nav-icon">🎨</span>
47 <span class="nav-label">Themes</span>
48 </a>
49 <a href="media.html" class="nav-item">
50 <span class="nav-icon">🖼️</span>
51 <span class="nav-label">Media</span>
52 </a>
53 <div class="nav-divider"></div>
54 <a href="review.html" class="nav-item">
55 <span class="nav-icon">✅</span>
56 <span class="nav-label">Review</span>
57 <span class="nav-badge">3</span>
58 </a>
59 <a href="metrics.html" class="nav-item">
60 <span class="nav-icon">📈</span>
61 <span class="nav-label">Metrics</span>
62 </a>
63 <a href="analytics.html" class="nav-item">
64 <span class="nav-icon">📊</span>
65 <span class="nav-label">Analytics</span>
66 </a>
67 <a href="jobs.html" class="nav-item">
68 <span class="nav-icon">⏰</span>
69 <span class="nav-label">Jobs</span>
70 </a>
71 <a href="logs.html" class="nav-item">
72 <span class="nav-icon">📋</span>
73 <span class="nav-label">Logs</span>
74 </a>
75 <a href="deploy.html" class="nav-item">
76 <span class="nav-icon">🚀</span>
77 <span class="nav-label">Deploy</span>
78 </a>
79 <a href="backup.html" class="nav-item active">
80 <span class="nav-icon">💾</span>
81 <span class="nav-label">Backup</span>
82 </a>
83 <a href="settings.html" class="nav-item">
84 <span class="nav-icon">⚙️</span>
85 <span class="nav-label">Settings</span>
86 </a>
87 </nav>
88
89 <main class="main-content">
90 <div class="content-header">
91 <div>
92 <h1>Backup & Restore</h1>
93 <div class="breadcrumb">Home / Backup</div>
94 </div>
95 <div class="header-actions">
96 <button class="btn-primary">💾 Create Backup Now</button>
97 </div>
98 </div>
99
100 <!-- Backup Status -->
101 <div class="card backup-status-card">
102 <div class="backup-status">
103 <div class="status-icon success">✓</div>
104 <div class="status-content">
105 <h2>Backups are Up to Date</h2>
106 <div class="status-details">
107 Last backup: <strong>Today at 2:00 AM</strong> • Next backup: <strong>Tomorrow at 2:00 AM</strong>
108 </div>
109 </div>
110 </div>
111 </div>
112
113 <!-- Quick Actions -->
114 <div class="backup-actions-grid">
115 <div class="card action-card">
116 <div class="action-icon">💾</div>
117 <h3>Create Backup</h3>
118 <p>Create a full backup of your site right now</p>
119 <button class="btn-primary">Create Backup</button>
120 </div>
121
122 <div class="card action-card">
123 <div class="action-icon">⬆️</div>
124 <h3>Restore from Backup</h3>
125 <p>Restore your site from a previous backup</p>
126 <button class="btn-secondary">View Backups</button>
127 </div>
128
129 <div class="card action-card">
130 <div class="action-icon">⬇️</div>
131 <h3>Download Backup</h3>
132 <p>Download a backup file to your computer</p>
133 <button class="btn-secondary">Download Latest</button>
134 </div>
135
136 <div class="card action-card">
137 <div class="action-icon">☁️</div>
138 <h3>Remote Backup</h3>
139 <p>Configure automatic off-site backups</p>
140 <button class="btn-secondary">Configure</button>
141 </div>
142 </div>
143
144 <!-- Recent Backups -->
145 <div class="card">
146 <div class="table-header">
147 <h2>Recent Backups</h2>
148 <select class="filter-select">
149 <option>All Backups</option>
150 <option>Automatic</option>
151 <option>Manual</option>
152 </select>
153 </div>
154
155 <div class="table-container">
156 <table class="data-table">
157 <thead>
158 <tr>
159 <th>Date</th>
160 <th>Type</th>
161 <th>Size</th>
162 <th>Files</th>
163 <th>Status</th>
164 <th>Actions</th>
165 </tr>
166 </thead>
167 <tbody>
168 <tr>
169 <td>
170 <div class="backup-date">
171 <strong>Today, 2:00 AM</strong>
172 <div class="backup-meta">Jan 15, 2025</div>
173 </div>
174 </td>
175 <td><span class="badge badge-blue">Automatic</span></td>
176 <td>142 MB</td>
177 <td>2,456 files</td>
178 <td><span class="badge badge-green">✓ Complete</span></td>
179 <td>
180 <div class="action-buttons">
181 <button class="btn-icon" title="Restore">⟲</button>
182 <button class="btn-icon" title="Download">⬇️</button>
183 <button class="btn-icon" title="Delete">🗑️</button>
184 </div>
185 </td>
186 </tr>
187 <tr>
188 <td>
189 <div class="backup-date">
190 <strong>Yesterday, 2:00 AM</strong>
191 <div class="backup-meta">Jan 14, 2025</div>
192 </div>
193 </td>
194 <td><span class="badge badge-blue">Automatic</span></td>
195 <td>138 MB</td>
196 <td>2,445 files</td>
197 <td><span class="badge badge-green">✓ Complete</span></td>
198 <td>
199 <div class="action-buttons">
200 <button class="btn-icon" title="Restore">⟲</button>
201 <button class="btn-icon" title="Download">⬇️</button>
202 <button class="btn-icon" title="Delete">🗑️</button>
203 </div>
204 </td>
205 </tr>
206 <tr>
207 <td>
208 <div class="backup-date">
209 <strong>Jan 14, 10:30 AM</strong>
210 <div class="backup-meta">Before deploy</div>
211 </div>
212 </td>
213 <td><span class="badge badge-purple">Manual</span></td>
214 <td>137 MB</td>
215 <td>2,442 files</td>
216 <td><span class="badge badge-green">✓ Complete</span></td>
217 <td>
218 <div class="action-buttons">
219 <button class="btn-icon" title="Restore">⟲</button>
220 <button class="btn-icon" title="Download">⬇️</button>
221 <button class="btn-icon" title="Delete">🗑️</button>
222 </div>
223 </td>
224 </tr>
225 <tr>
226 <td>
227 <div class="backup-date">
228 <strong>Jan 13, 2:00 AM</strong>
229 <div class="backup-meta">Jan 13, 2025</div>
230 </div>
231 </td>
232 <td><span class="badge badge-blue">Automatic</span></td>
233 <td>135 MB</td>
234 <td>2,431 files</td>
235 <td><span class="badge badge-green">✓ Complete</span></td>
236 <td>
237 <div class="action-buttons">
238 <button class="btn-icon" title="Restore">⟲</button>
239 <button class="btn-icon" title="Download">⬇️</button>
240 <button class="btn-icon" title="Delete">🗑️</button>
241 </div>
242 </td>
243 </tr>
244 </tbody>
245 </table>
246 </div>
247 </div>
248
249 <!-- Backup Configuration -->
250 <div class="card">
251 <h2>Backup Configuration</h2>
252
253 <div class="setting-item">
254 <div class="setting-info">
255 <div class="setting-label">Automatic Backups</div>
256 <div class="setting-description">Create backups automatically on a schedule</div>
257 </div>
258 <div class="setting-value">
259 <label class="toggle">
260 <input type="checkbox" checked>
261 <span class="toggle-slider"></span>
262 </label>
263 </div>
264 </div>
265
266 <div class="setting-item">
267 <div class="setting-info">
268 <div class="setting-label">Backup Schedule</div>
269 <div class="setting-description">When to run automatic backups</div>
270 </div>
271 <div class="setting-value">
272 <select class="form-select" style="width: 200px;">
273 <option>Every 6 hours</option>
274 <option>Every 12 hours</option>
275 <option selected>Daily at 2:00 AM</option>
276 <option>Weekly</option>
277 </select>
278 </div>
279 </div>
280
281 <div class="setting-item">
282 <div class="setting-info">
283 <div class="setting-label">Retention Policy</div>
284 <div class="setting-description">How long to keep old backups</div>
285 </div>
286 <div class="setting-value">
287 <select class="form-select" style="width: 200px;">
288 <option>7 days</option>
289 <option>14 days</option>
290 <option selected>30 days</option>
291 <option>90 days</option>
292 <option>Forever</option>
293 </select>
294 </div>
295 </div>
296
297 <div class="setting-item">
298 <div class="setting-info">
299 <div class="setting-label">What to Backup</div>
300 <div class="setting-description">Select what to include in backups</div>
301 </div>
302 <div class="setting-value">
303 <div class="checkbox-group">
304 <label class="checkbox-label">
305 <input type="checkbox" checked>
306 <span>Database (TSV files)</span>
307 </label>
308 <label class="checkbox-label">
309 <input type="checkbox" checked>
310 <span>Media Files</span>
311 </label>
312 <label class="checkbox-label">
313 <input type="checkbox" checked>
314 <span>Code Files</span>
315 </label>
316 <label class="checkbox-label">
317 <input type="checkbox">
318 <span>Logs</span>
319 </label>
320 </div>
321 </div>
322 </div>
323
324 <div class="config-actions">
325 <button class="btn-primary">Save Configuration</button>
326 </div>
327 </div>
328
329 <!-- Remote Storage -->
330 <div class="card">
331 <h2>Remote Storage</h2>
332 <p class="card-description">Store backups off-site for extra protection</p>
333
334 <div class="remote-storage-options">
335 <div class="storage-option">
336 <div class="storage-icon">☁️</div>
337 <div class="storage-info">
338 <h3>Amazon S3</h3>
339 <div class="storage-status">Not configured</div>
340 </div>
341 <button class="btn-secondary-small">Configure</button>
342 </div>
343
344 <div class="storage-option">
345 <div class="storage-icon">☁️</div>
346 <div class="storage-info">
347 <h3>Backblaze B2</h3>
348 <div class="storage-status">Not configured</div>
349 </div>
350 <button class="btn-secondary-small">Configure</button>
351 </div>
352
353 <div class="storage-option">
354 <div class="storage-icon">🖥️</div>
355 <div class="storage-info">
356 <h3>SFTP Server</h3>
357 <div class="storage-status">Not configured</div>
358 </div>
359 <button class="btn-secondary-small">Configure</button>
360 </div>
361
362 <div class="storage-option">
363 <div class="storage-icon">💻</div>
364 <div class="storage-info">
365 <h3>Rsync Remote</h3>
366 <div class="storage-status">Not configured</div>
367 </div>
368 <button class="btn-secondary-small">Configure</button>
369 </div>
370 </div>
371 </div>
372
373 <!-- Backup Command -->
374 <div class="card">
375 <h2>Manual Backup Commands</h2>
376 <div class="command-box">
377 <div class="command-header">
378 <span>Create backup via command line:</span>
379 <button class="btn-icon-small">📋 Copy</button>
380 </div>
381 <pre><code>$ tar -czf backup-$(date +%Y%m%d-%H%M%S).tar.gz data/ uploads/ routes/ templates/
382$ ls -lh backup-*.tar.gz</code></pre>
383 </div>
384
385 <div class="command-box">
386 <div class="command-header">
387 <span>Restore from backup:</span>
388 <button class="btn-icon-small">📋 Copy</button>
389 </div>
390 <pre><code>$ tar -xzf backup-20250115-020000.tar.gz
391$ systemctl reload myblog</code></pre>
392 </div>
393 </div>
394
395 <!-- Backup Data -->
396 <div class="card">
397 <h2>Backup Metadata</h2>
398 <div class="data-source">
399 <div class="data-source-icon">📄</div>
400 <div class="data-source-info">
401 <div class="data-source-title">data/backups.tsv</div>
402 <div class="data-source-description">
403 Backup history tracked in TSV. Each backup = one row with timestamp, size, file count, status.
404 Backups stored in <code>backups/</code> directory.
405 </div>
406 <div class="data-source-meta">
407 4 backups • 550 MB total
408 </div>
409 </div>
410 <button class="btn-secondary-small">View TSV</button>
411 </div>
412 </div>
413 </main>
414
415 <aside class="ai-assistant">
416 <div class="ai-header">
417 <span class="ai-icon">🤖</span>
418 <span class="ai-title">AI Assistant</span>
419 <button class="ai-toggle">−</button>
420 </div>
421
422 <div class="ai-content">
423 <div class="ai-messages">
424 <div class="ai-message ai-message-assistant">
425 <div class="message-content">
426 I can help you set up automated backups, configure remote storage, or restore from a previous backup. What would you like to do?
427 </div>
428 </div>
429 </div>
430
431 <div class="ai-suggestions">
432 <div class="suggestion-title">Try asking:</div>
433 <button class="suggestion-btn">"Set up S3 backups"</button>
434 <button class="suggestion-btn">"Test restore process"</button>
435 <button class="suggestion-btn">"Optimize backup size"</button>
436 </div>
437
438 <div class="ai-input">
439 <textarea placeholder="Ask AI about backups..." rows="3"></textarea>
440 <button class="btn-primary">Send</button>
441 </div>
442 </div>
443 </aside>
444 </div>
445 </div>
446
447 <style>
448 .backup-status-card {
449 background: linear-gradient(135deg, #d1fae5 0%, #a7f3d0 100%);
450 border: none;
451 }
452
453 .backup-status {
454 display: flex;
455 align-items: center;
456 gap: 1.5rem;
457 }
458
459 .status-icon {
460 width: 4rem;
461 height: 4rem;
462 border-radius: 50%;
463 display: flex;
464 align-items: center;
465 justify-content: center;
466 font-size: 2rem;
467 flex-shrink: 0;
468 }
469
470 .status-icon.success {
471 background: var(--color-success);
472 color: white;
473 }
474
475 .status-content h2 {
476 margin: 0 0 0.5rem 0;
477 color: #065f46;
478 }
479
480 .status-details {
481 color: #047857;
482 }
483
484 .backup-actions-grid {
485 display: grid;
486 grid-template-columns: repeat(4, 1fr);
487 gap: 1.5rem;
488 margin-bottom: 2rem;
489 }
490
491 .action-card {
492 text-align: center;
493 padding: 2rem 1.5rem;
494 }
495
496 .action-icon {
497 font-size: 3rem;
498 margin-bottom: 1rem;
499 }
500
501 .action-card h3 {
502 margin: 0 0 0.5rem 0;
503 }
504
505 .action-card p {
506 color: var(--color-text-muted);
507 font-size: 0.875rem;
508 margin-bottom: 1.5rem;
509 }
510
511 .backup-date strong {
512 display: block;
513 margin-bottom: 0.25rem;
514 }
515
516 .backup-meta {
517 font-size: 0.75rem;
518 color: var(--color-text-muted);
519 }
520
521 .checkbox-group {
522 display: flex;
523 flex-direction: column;
524 gap: 0.5rem;
525 }
526
527 .config-actions {
528 margin-top: 2rem;
529 padding-top: 2rem;
530 border-top: 1px solid var(--color-border);
531 }
532
533 .card-description {
534 color: var(--color-text-muted);
535 margin-bottom: 1.5rem;
536 }
537
538 .remote-storage-options {
539 display: grid;
540 grid-template-columns: repeat(2, 1fr);
541 gap: 1rem;
542 }
543
544 .storage-option {
545 display: flex;
546 align-items: center;
547 gap: 1rem;
548 padding: 1.5rem;
549 background: var(--color-bg);
550 border-radius: 0.5rem;
551 border: 1px solid var(--color-border);
552 }
553
554 .storage-icon {
555 font-size: 2rem;
556 }
557
558 .storage-info {
559 flex: 1;
560 }
561
562 .storage-info h3 {
563 margin: 0 0 0.25rem 0;
564 font-size: 1rem;
565 }
566
567 .storage-status {
568 font-size: 0.875rem;
569 color: var(--color-text-muted);
570 }
571
572 .command-box {
573 background: #1e293b;
574 color: #e2e8f0;
575 border-radius: 0.5rem;
576 overflow: hidden;
577 margin-bottom: 1rem;
578 }
579
580 .command-box:last-child {
581 margin-bottom: 0;
582 }
583
584 .command-header {
585 display: flex;
586 justify-content: space-between;
587 align-items: center;
588 padding: 0.75rem 1rem;
589 background: #0f172a;
590 border-bottom: 1px solid #334155;
591 font-size: 0.875rem;
592 }
593
594 .command-box pre {
595 margin: 0;
596 padding: 1rem;
597 overflow-x: auto;
598 }
599
600 .command-box code {
601 font-family: 'Monaco', 'Menlo', monospace;
602 font-size: 0.875rem;
603 line-height: 1.6;
604 }
605
606 .toggle {
607 position: relative;
608 display: inline-block;
609 width: 48px;
610 height: 24px;
611 }
612
613 .toggle input {
614 opacity: 0;
615 width: 0;
616 height: 0;
617 }
618
619 .toggle-slider {
620 position: absolute;
621 cursor: pointer;
622 top: 0;
623 left: 0;
624 right: 0;
625 bottom: 0;
626 background-color: var(--color-border);
627 transition: 0.3s;
628 border-radius: 24px;
629 }
630
631 .toggle-slider:before {
632 position: absolute;
633 content: "";
634 height: 18px;
635 width: 18px;
636 left: 3px;
637 bottom: 3px;
638 background-color: white;
639 transition: 0.3s;
640 border-radius: 50%;
641 }
642
643 .toggle input:checked + .toggle-slider {
644 background-color: var(--color-primary);
645 }
646
647 .toggle input:checked + .toggle-slider:before {
648 transform: translateX(24px);
649 }
650 </style>
651</body>
652</html>