mysqldump : MySQL's Client Backup Utility
-1
votes
2answers
31 views
mysqldump in cron not working
I am trying to do a mysqldump on the cron for every 5 minutes but it seems that it is not working. I try to execute the mysqldump and it works fine.
mysqldump
mysqldump -uroot -ppassword ...
0
votes
0answers
22 views
Mysql won't start after replacing data in datadir.
so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
0
votes
1answer
55 views
How to dump remote database without using mysqlDump
I have a similar problem from this question How to dump remote database without mysqldump?
How ever when I run
ssh -f L 3306:localhost:3306 user@remoteserver -N
I am receive the following error
...
0
votes
1answer
21 views
Database replication with old data
I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
1
vote
2answers
43 views
how to execute bash script with crontab in centos?
My bash file is not executed by cronjob created as root. The cronjob setup looks as it follows
0 0 * * * mysql_backup.sh
does need to be decalared with the bash command 0 0 * * * bash ...
0
votes
2answers
23 views
Weird mysqldump behaviour
I'm trying to use mysqldump on a remote host.
My local IP is 111.111.111.111, and the remote IP is 222.222.222.222
I run this command:
mysqldump --host=222.222.222.222 -u user test_db
This doesn't ...
0
votes
0answers
32 views
mysqldump not working/running via cron job
I have a crontask which runs at 1am every morning and dumps all databases.
0 1 * * * /var/backups/dumpit.sh 2>&1>> /var/backups/dumpit.log
The dumpit.sh source:
#!/bin/bash
...
0
votes
1answer
49 views
How Do I Restore a MySQL Database from Time Machine Backup?
I develop locally on a Mac, and my computer completely died yesterday. The hard drive is gone, apparently not recoverable.
I have a current backup on Time Machine.
So my question is:
How exactly do ...
0
votes
1answer
50 views
Restoring mysql dumps from incrementals
This is probably bordering on a silly question, but if I recently restored a Full mysql DB dump via cat dump.mysql |mysql dbname to a new instance of mysql in order to migrate; and I want to restore ...
2
votes
1answer
117 views
automysqlbackup on cPanel server not ignoring eximstats
I am backing up my cPanel server databases with automysqlbackup, in /etc/automysqlbackup.conf I have set: CONFIG_db_exclude=( 'information_schema' 'cphulkd' 'eximstats' 'leechprotect' 'mysql' 'modsec' ...
0
votes
0answers
68 views
Migrate existing mysql server data to percona xtradb cluster
I currently have one server which is a mysql server. I want to get the data from it, into a new 3 node percona xtradb cluster i've set up.
I am wondering if there's any alternatives to simply doing a ...
1
vote
0answers
107 views
MySQL ZRM restore failed with mysql error unknown command \0
I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'.
...
1
vote
1answer
70 views
unable to restore mysql database, getting ERROR 1153 (08S01)
trying to restore pressflow database and getting this error, I even tried it with --max_allowed_packet, still getting same error:
[root@6shdbm01 tmp]# mysql --max_allowed_packet=1024M pressflow < ...
0
votes
3answers
116 views
mysqldump --single-transaction with dump files separated by table?
Using mysqldump, how can I create a consistent backup of a MySQL (InnoDB) database and have the dump files be separated by table?
To create a consistent backup using mysqldump, I know there is ...
0
votes
1answer
50 views
How to proceed setting up a secondary mysql linux slave?
I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
0
votes
3answers
90 views
MySQL backup and save in external server
I have MySQL 5 installed in a Ubuntu server. I want backup the database for:
latest 7 days
weekly
and store those backups in another server. I prefers the tool runs in the same server that host ...
1
vote
1answer
101 views
Making a mysql dump causes web application to hang.
Can the following command on a live server
mysqldump -h XXXX -u root -pXXXXX --skip-opt --flush-privileges
--flush-logs --routines --triggers --allow-keywords
--create-options --add-locks ...
0
votes
1answer
49 views
Is it possible to dump a postgresql db and restore it in mysql?
I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
0answers
25 views
Non-root user backup MySQL databases as cron job [duplicate]
Possible Duplicate:
How do I create a read only MySQL user for backup purposes with mysqldump?
I have seen different scripts to dump MySQL databases on a per user basis, but I need some ...
-3
votes
2answers
107 views
crontab -e on Red Hat 4.1.2-48 [closed]
The following command on crontab does not work at all.
0 12 * * * mysqldump -hserverhpost -uuser -ppass db > /path/to/backu/$(date +%d-%m-%Y)
I read extensively about this and i cannot see what ...
1
vote
2answers
242 views
MySQL lost connection error on mysqldump
I have a 1 TB MySQL database that I'd like to dump and reload. Most of the data is in one table. A lot of data has been deleted, so I'm pretty sure if I dump it with mysql, rebuild the database, ...
0
votes
1answer
45 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
votes
1answer
65 views
Downloading a MySQL database from phpMyAdmin or cPanel stops at 10MB [closed]
When I try to download my database (it's around 110MB) from phpMyAdmin or cPanel, the download stops at around 10-18MB.
I've also tried to download one table at once, but one table is 63MB.
I don't ...
0
votes
2answers
90 views
MySQL Tweaking for performance
[mysqld]
myisam_repair_threads=4
key_buffer = 64M
myisam_sort_buffer_size = 32M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
table_cache = 1024
...
4
votes
1answer
138 views
mysql error 1062 'duplicate entry' when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
0
votes
1answer
140 views
linux cron mysqldump: php exec() vs shell script vs direct command in crontab
The system is running CENTOS 5.8, Apache 2.2.3, MySQL 5.0.95, PHP 5.3.3
We run mysqldump daily for a few databases. It's run via a php script called in crontab.
They are run at the same time and ...
1
vote
1answer
151 views
rsnapshot - not correctly archiving mysql databases
My rsnapshot configuration:
snapshot_root /.snapshots/
backup /home/user localhost/
backup_script /usr/local/backup_mysql.sh localhost/mysql/
Using this file:
NOW=$(date ...
2
votes
2answers
869 views
Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”
Backstory
Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql.
Reinstalled ...
8
votes
4answers
692 views
How to efficiently dump a huge MySQL innodb database?
I got an Ubuntu 10.04 production MySQL database server where total size of database is 260 GB while size of root partition is itself 300 GB where DB is stored, essentially means around 96% of / is ...
0
votes
2answers
164 views
MySQL Dump Viewer
I'm a linux user, however, I'm provided with a Windows laptop in the office. I could fire up a small web server with PHPmyadmin or even upload to a remote system and import into a database, however, ...
0
votes
1answer
157 views
Wildcard backup MySQL databases
There are quite a few discussion on the Interweb on how to backup based on the wildcard table name, but how about wildcard database name?
e.g.
If I have databases named
foo1
foo2
foo3
.
.
fooN
...
0
votes
2answers
90 views
How to delete older dump in automysqlbackup.sh
I use with success automysqlbackup.sh script. All is fine. Dump's are rotate in daily/weekly/monthly folders. But is it the option to delete dump older than 3 month or sth. like that? I tried to found ...
1
vote
0answers
188 views
mysqld service crashes on restart, after importing mysqldump #innodb
I have 2 mysql servers. Let's call them server01 & server02. Both have the same configuration: mysqladmin Ver 8.42 Distrib 5.1.61, for redhat-linux-gnu on x86_64
[client]
...
0
votes
3answers
62 views
How to export a certain number of MySql databases with one command
I need to export around 20 databases in a MySql server which contain around 100 different databases, is it possible to export a list of database names into separate files using a console command? ...
2
votes
3answers
235 views
Mysql dump of slave w/o missing Master data
I am fairly new to the whole replication process of mysql so this may be an easy question to answer. I have a master and and slave. I need to set up another slave so obviously I will need to make the ...
1
vote
0answers
692 views
How do I set my root account in mysql to be accessed locally?
I am running into a bit of a problem here. I have a mysql server setup on an Ubuntu 12.04 distro. After the initial install I have been using MySQL Workbench to do all my db creation and ...
0
votes
1answer
294 views
How to take mysql replication backup
I have a MySQL master-master replication setup with a slave for each master(only one master used for read/writes at a time) on Ubuntu server. Wondering what would be the best way to schedule backup of ...
1
vote
0answers
576 views
Mysql - innoDb - is in the future! Current system log sequence number
I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before.
But still a few times an hour I get
Sep 1 ...
1
vote
0answers
161 views
Mysql innoDB corruption after server crash
Yesterday my server died because an outage in the data center. Today it's back up, but having some problems with mysql.
First of all my mysql server was not able to start. For this reason I deleted ...
-1
votes
1answer
115 views
Automatic backup from SSH-server [closed]
I am in needed of a script (. Bat) who log on to an SSH server, and perform a backup of my mysql database with the help of mysqldump.
This is to be run on a Windows computer and run three times per ...
1
vote
1answer
110 views
mysqldump tab into tar.gz
I'd like to use mysqldump with the -T function and somehow compress it in one step, to save writing the uncompressed files to disk (it's a really big database).
mysqldump -T/directory databasename
...
1
vote
1answer
190 views
Migrate databases from MySQL 4.1 InnoDB to current version of MySQL 5.5
I need to stop a old server running with MySQL 4.1 with lots of database on it (MyISAM and InnoDB), and to migrate to a new one (5.1.63 installed on a fresh Squeeze). It's a shared hosting servers so ...
4
votes
2answers
143 views
How to get a valuation about the size of mysql table dump
Hi to everyone someone know how to get an estimate about the size of one mysql table?
I mean I am planning to make a backup of all the mysql's table on all my server
but I'd like to know how big ...
7
votes
3answers
772 views
Do InnoDB tables got locked during mysqldump when mixed with MyISAM?
I'm looking for a backup solution for my mysql servers and I need as less downtime as possible. I have the following:
MySQL servers
they are not replicated
each server stands for it's own
This ...
0
votes
1answer
82 views
selectively import “record sets” from one mysql instance to another
I have a mysql server hosting a production database, and routinely I make snapshots of it, which we can also use as a staging environment.
Sometime bad things happen, e.g. we delete a row (and all ...
0
votes
2answers
76 views
Disallowing certain user from dumping database (MySQL)
Under the privileges that can be assigned to a user, I can't find whether to allow or disallow a user from being able to dump a database.
I want to disallow a user from taking backup of a database.
1
vote
4answers
518 views
Mysqldump causes “Too many connections”
A scheduled backup using mysqldump on one of our databases is causing Too many connections. The database is of both InnoDB and MyISAM tables with size of around 500Mb.
The Too many connections appears ...
0
votes
0answers
207 views
can we convert postgresql dump to mysql dump thorough commandline?
Can I convert a PostgreSQL dump file into a MySQL dump? I tried but I get syntax error.
cd\
c:
cd "C:\Program Files\MySQL\bin"
mysql -u root -proot
pause
I run this batch file after I put this
...
0
votes
1answer
163 views
MySQL slave server from dumps
I've created a slave server from live machine which is acting as a master now.
I use the following procedure to create it:
mysqldump --opt -Q -B --master-data=2 --all-databases > dump.sql
then ...
1
vote
1answer
166 views
Create dump of database schema remotely
I have a connection to remote Mysql database. (i'm using MySQL Workbench).
I'd like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it ...
