128 questions
1
vote
1
answer
52
views
Find all files older txen X days in a directory tar them and move them to other location
I have a bash script for backing up some databases to the location: /media/backup-disk/mysql-backup It runs from cron every 30min and a script contains:
#!/bin/sh -e
/usr/bin/mysqldump --defaults-file=...
- 11
0
votes
1
answer
152
views
MySQL 8 can not restore dump
I have a Databases and like to backup and restore my backups. My Database is more complex, but I will give a short example what is not working.
CREATE DATABASE `bug`CHARACTER SET utf8mb4 COLLATE ...
- 11
0
votes
1
answer
464
views
Navicat backup restoring - [Err] Failed to create View
I was testing the restoring of my database backup
and when it comes to the views, most of them are restored but for some views it gives me an Error
I went to check the view, the view has a select ...
- 1
2
votes
1
answer
617
views
How to import data into master/replica structure in MySQL
I have a file called db.sql; this file contains the data for one database. I want to import this data into a database called db in the newly established master/replica structure.
I used mysql -u USER -...
- 937
0
votes
1
answer
353
views
Is it possible to take Differential Backup in Mysql and later restore it with full backup
I want to take differential backup of a MYSQL DB, this backup should contain the data after the last full backup was taken. and then I should be able to restore both full and latest differential ...
0
votes
1
answer
1k
views
mysqldump and "Can't find record" table errors on restore
I've been using the following mysqldump command to backup my mariadb databases for several years, and never had a problem restoring. Until today. Here is the command I've been using for one of the ...
- 499
0
votes
1
answer
616
views
Does a MySQL backup save custom functions, events, and queries?
I successfully did a backup of my database, dropped the DB in workbench and created a new one, and attempted to restore it. First, it didn’t restore until I ran the creation of a custom function first ...
0
votes
1
answer
1k
views
How to figure out my dump_binary_path in my device? Using spatie laravel-backup package for Laravel 9
I'm currently using the spatie laravel-backup for backup my database.
But when I execute the command
php artisan backup:run
I get this error :
Backup failed because The dump process failed with ...
- 65
0
votes
0
answers
80
views
How to backup database using mysqldump?
I'm trying to take a backup of a mysql database using the following code:
@echo off
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%b-%%a-%%c)
For /f "tokens=1-2 ...
-1
votes
1
answer
342
views
How to create a logical backup of a relational table in mysql workbench using mysqldump?
How do I put these codes in MySQL workbench to create a logical backup of a BOOK table without using the command line? I put the codes below in the workbench and it shows an error: "mysqldump&...
- 1
0
votes
1
answer
266
views
Is there a way to downgrade mysqlbackup?
I have a client that backed up his data with MEB 4.0.0, so now I need to extract the contents of the image, but because I'm using mysql Enterprise Backup 8.0 I can't since it's not compatible.
Is ...
- 21
-1
votes
1
answer
687
views
Increase a variable in a loop and for each increment, apply for each new thread
How to increase a variable every time I create a new Thread and store that value? I want to do mysqlbackup in each thread for different databases, and I will get the curBytes/totalBytes completed on ...
-1
votes
1
answer
502
views
mysqldump produce a corrupted sql file (apparently on tables with stored generated column) (MySQL v8.0.21)
I am using MySQL v8.0.21 and mysqldump v8.0.23.
I have a table with the following schema:
mysql> desc resource_downloads;
+-------------+--------------+------+-----+---------+------------------+
| ...
- 2,546
0
votes
2
answers
1k
views
I have a backup of the Wordpress folder but not the SQL database, is it possible for me to recover the website for local use?
I have a backup of the entire Wordpress folder of one of my old websites but, unfortunately, I forgot to also make a backup of the database for it. It's been years since the website expired so there's ...
0
votes
1
answer
146
views
Create table/view without checking if referred table/view exists
I have a MySql Database connected to a VB.Net application. All I want is to create the database automatically using my application. I currently use MySqlBackup.Net available in NuGet Packages to ...
- 980