0
votes
1answer
78 views

Backup and bz2 large mysql datefile with innobackupex in the background

I'm using the following command to backup a large running mysql database (~500GB). innobackupex --user=user --password=***** --stream=tar ./db-backup | bzip2 - > backup.tar.bz2 Since the backup ...
1
vote
4answers
429 views

How to load large SQL file into mysql

I have a database backup of a MySQL database that is about 250MB. I made it with mysqldump I was trying to load it on another server like so: mysql -u xxxx -pxxxx data_mirror < dbdump.sql I was ...
1
vote
5answers
401 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
1
vote
2answers
362 views

How to restore just ONE mysql database from a collective backup

I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file. How can I tell mysql to import ONE of the databases contained in the dump file? -M ...