Stack Overflow
Stack Overflow

Questions tagged [mysql-backup]

133 questions
418
votes
14 answers

Export and Import all MySQL databases at one time

I want to keep a backup of all my MySQL databases. I have more than 100 MySQL databases. I want to export all of them at the same time and again import all of them into my MySQL server at one time. How can I do that?
NewUser
  • 12,713
  • 39
  • 142
  • 236
19
votes
7 answers

'mysqldump' is not recognized as an internal or external command

currently im trying to make backup and restore mysql database in my laravel project. I am using this laravel package https://github.com/backup-manager/laravel for backup package. i already follow the intructions, but when i am trying to backup my…
RK26
  • 373
  • 1
  • 5
  • 20
15
votes
2 answers

Disabling AWS RDS backups when creating/updating instances?

I am creating new RDS MySQL instances from snapshots and updating their configurations both via the API and through the UI. Regardless of how I create or update instances, these actions automatically trigger new snapshots to be created through some…
jmsb
  • 4,846
  • 5
  • 29
  • 38
13
votes
1 answer

mysqldump not creating create database syntax

I am using mysql database. I am using mysqldump to create a dump of my database. I want the database to be dumped such that there is a drop database if exists command followed by create database command. I am using the following command (on my…
sasidhar
  • 7,523
  • 15
  • 49
  • 75
11
votes
1 answer

Download MySql Backup/Snapshot from Amazon RDS

I have hosted my MySql Database on Amazon RDS on my Production Instance. I have another RDS instance for Development purpose. Now I am looking for best/fastest way to restore database backup/snapshot from Production Instance to Development Instance,…
Manish Sapkal
  • 5,591
  • 8
  • 45
  • 74
10
votes
4 answers

How to install mysqlbackup?

I would like to use mysqlbackup to do incremental backups. However I can't figure out how to install it. I have mysql-server installed. The documentation (http://dev.mysql.com/doc/mysql-enterprise-backup/3.7/en/mysqlbackup.incremental.html) seems to…
pacman
  • 2,050
  • 4
  • 16
  • 17
7
votes
1 answer

Force row_format on mysqldump

I am converting a whole server to use Barracuda file format and dynamic row format. Here's what I did: full mysqldump configured *innodb_file_per_table = 1* and *innodb_file_format=barracuda* resetted all mysql data. imported all dumped…
Johnny Everson
  • 8,343
  • 7
  • 39
  • 75
5
votes
1 answer

MySQL backup using AutoMySQLBackup from slave to remote machine

I am trying to setup daily backup for MySQL database from slave server or MySQL instance. My database is a mixture of InnoDb and MyISAM tables. I have installed AutoMySQLBackup on another machine. I am trying to take a full backup and a daily…
jayprakashstar
  • 395
  • 2
  • 12
4
votes
0 answers

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.
a.ak
  • 659
  • 2
  • 12
  • 26
4
votes
1 answer

There are no commands defined in the "backup" namespace

I have tried installing Laravel Backup for Database paulvl/backup I have followed the instructions on how to install and configure it to my Laravel application. I am however stuck at the point where you actually run the backup command. I get this…
Chris Otaalo
  • 131
  • 2
  • 10
3
votes
0 answers

What's the fastest way to import a 1TB .sql file? Too slow currently

My DB got corrupt with errors like, InnoDB log sequence number is in the future and so went to a backup copy that I had and exported an SQL file that needs to be re-imported. The .sql file is close to 800GB and the actual Db was around 1.3TB in…
Sam
  • 532
  • 6
  • 12
3
votes
1 answer

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 | +------------------+-----------+ | mysql-bin.000001 | …
Vasantha Kumar G
  • 33
  • 9
3
votes
1 answer

Automysqlbackup - Could not open required defaults file: /etc/mysql/debian.cnf

Trying to install AutoMySQLBackup on Ubuntu sudo apt-get update sudo apt-get upgrade apt-get install automysqlbackup I get the following error: Setting up automysqlbackup (2.6+debian.3-1ubuntu1) ... Could not open required defaults file:…
aeb16
  • 31
  • 1
  • 2
3
votes
2 answers

Automated or regular backup of mysql data

I want to take regular backups of some tables in my mysql database using / plain php / my second favorite language. I want it to be automated so that the backup can be restored later on in case something goes…
e4c5
  • 52,766
  • 11
  • 101
  • 134
3
votes
1 answer

How to backup specific MySQL table using C#

I have been doing backup of MySQL tables using MySqlBackup.dll in C#. I have no idea on how to backup specific table inside a MySQL schema. How can I backup only one or two specific tables using C#?
ThEpRoGrAmMiNgNoOb
  • 1,256
  • 3
  • 23
  • 46
1
2 3
…
8 9