128 questions
1
vote
1
answer
53
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
466
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
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
619
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
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 ...
0
votes
1
answer
268
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
504
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
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
0
votes
2
answers
8k
views
Laradock mysqldump not found when executing artisan backup:run (Spatie Laravel Backup)
I have deployed a Laravel application with Laradock.
I want to point out that the database connection works fine (users can register, login, ... etc.).
In order to back up the application, I have ...
- 10.8k
1
vote
2
answers
817
views
Restoring mysql backup through windows batch file, which calls the .sql file
Im trying to restore a mysql database from a back up. I was able to do it on command prompt directly using
mysql> -u username -ppassword < E:\replication\DestinationTest\restore.sql.
This ...
- 69
0
votes
1
answer
243
views
Can I backup multiple mysql databases (All InnoDB) without using mysqldump and just using file/folder backup
Is there any way where I can take a backup of some files/folders to take the backup of all my Mysql databases. I am using Acronis Cloud Backup tool and I dont find any option where I can backup mysql ...
- 3,540
0
votes
2
answers
376
views
mysqldump problem in Crontab and bash file
I have created a cron tab to backup my DB each 30 minutes...
*/30 * * * * bash /opt/mysqlbackup.sh > /dev/null 2>&1
The cron tab works well.. Each 30 minutes I have my backup with the ...
- 57
1
vote
0
answers
151
views
Empty file with my automatic script to do back-up of my data base (manually it's ok)
I try to save my database from my wordpress on a EC2 instance in AWS.
Manually it's ok if i do :
mysqldump -u root -p*mypassword* bitnami_wordpress > bdd.sql</i>
But if i do this script (...
4
votes
0
answers
2k
views
Backup MySQL database to google drive automatically
I have an application in laravel and I want to take a backup of a MySQL database and upload it to my Google Drive automatically. Can you please guide me how can I do that without Third party API.
- 649
0
votes
0
answers
312
views
mysqlpump parallelism and errors with foreign constraints
I'm current on MySQL 5.7.26, and am trying to mysqlpump to take dumps of my database. I have successfully used mysqldump previously.
Doing the mysqlpump and piping that to a slave instance results in ...
- 7,379
0
votes
1
answer
661
views
Changing Wordpress Theme in Staging Environment
I have a live newspaper WordPress website with about 10 users updating it daily with about 2000+ unique visitors a day. I have a sum of about 30 posts a day added to my db and i host my own pictures.
...
- 681
0
votes
1
answer
454
views
backup database using mysqldump with php not working
please i want to backup my database using php.
i have tried many answered question on this similar problem but still not working.
$username = "***";
$password = '******';
$database = 'mydatabase';
$...
- 85
3
votes
1
answer
2k
views
what is the difference between master binary log and slave binary log in MySQL? How can I achieve same binary logs on both servers?
I have master and slave servers. Replication done. Now I did follow the below steps on both servers.
mysql> show binary logs;
+------------------+-----------+
| Log_name | File_size |
+----...
0
votes
1
answer
448
views
How can I achieve 'incremental backup with 1 hour timing' period in mysql using Ansible Playbook based on binlog?
I have two servers. master and slave which moderated for replication. replication process is working good. Here I wants to use "incremental dump" option for every one hour and upload that to s3 bucket ...
2
votes
1
answer
2k
views
How to back up each table from multiple MySQL databases in Windows?
I have multiple MySQL databases on WIndows Server and I would like to backup all these databases by creating a folder with the name of the database and inside the .SQL file folder for each table of ...
- 27
0
votes
1
answer
37
views
MySQL copy table to another database (not the same network)- backup?
I have a working database - and I want to copy all its data (or even just 1 table from it) and create a backup on disk and also create a "backup" database on another location (not the same computer). ...
- 101
0
votes
1
answer
5k
views
Restore mysql database using binary log file (log-bin) on Windows
Using binary log file to restore mysql database is very useful, especially in misoperation. Below is my method to do this on Windows. If this question helps you, please mark it as "Useful", thanks.
- 467
0
votes
0
answers
128
views
Java MySQL dump including stored procedures and functions without using mysqldump
My Java application needs to be able to run on a remote system without the MySQL cli installed on it and can only interface with the MySQL database using a MySQL connection ( no ssh ). I can't use ...
- 421
1
vote
3
answers
3k
views
How to restore a MySQL database "safely"
How should you go about restoring (and backing) up a MySQL database "safely"? By "safely" I mean: the restore should create/overwrite a desired database, but not risk altering anything outside that ...
- 4,300
2
votes
1
answer
282
views
PHP run script then redirect once complete
in PHP how can I redirect my page once scrpit has run with a successful case 0 but stay on current page for anything else?
exec( $command, $output = array(), $worked );
switch( $worked ) {
case ...
- 620