0
votes
0answers
19 views

Options to include with mysqldump when taking backup of hybrid databases

I'm planning on taking backups of all MySQL databases on a remote production server. The combined database size is around 2 GB. Most of the tables are InnoDB ~1.8 GB and the rest are MyISAM. Now I've ...
-1
votes
0answers
40 views

mysql service failed to start [closed]

I have dual Operating system on PC, windows 8 and Ubuntu 14.0, and I am mostly using Ubuntu because my MySQL database is hosted on Ubuntu. Recently when I am trying to restore my database, which is ...
2
votes
2answers
61 views

Two databases synced backup

I got a system that need two databases to work. I need a script to backup both databases at given point of time. I need databases to be in sync, so I need to be sure that backup does not allow changes ...
0
votes
1answer
19 views

Parallel mysqlimport Syntax Wrong?

I'm trying to import a large 70GB+ database (all InnoDB) using mysqlimport. This is a development system on Windows using WAMP server. MySQL 5.6.17. I'm getting the following error: mysqlimport: ...
0
votes
1answer
48 views

trouble running mysqldump on Ubuntu via cron job

I'm trying to set up a cron job to back up my database every night at midnight. Based on a few tutorials I've read, I've written a script that executes the following command: mysqldump -u my_username ...
1
vote
2answers
95 views

Server 2012 Scheduled Task CMD mysqldump not doing what is intended

I'm running a batch file to back up some mysql databases on a 2012 webserver. The batch file creates a folder, then runs the following for each db: mysqldump -u *username* -p*Password* *db_name* ...
0
votes
1answer
210 views

Can't install mysqldump on Ubuntu

Another technician recently reinstalled our mysql on our LAMP-server and now I can't use mysqldump anymore. # mysqldump The program 'mysqldump' is currently not installed. You can install it by ...
0
votes
0answers
38 views

What is appropriate configuration for mysqldump to use as backup

There are some resources on how to dump databases using mysqldump (1, 2, 3 or 4) , but most of them are like "just mysqldump the whole thing". My mysqldump result differs from one I obtain from my ...
0
votes
1answer
69 views

How to use screen with mysql import

I need to import a very large MySQL table on remote server. Usually I'm using mysql -u mysql_user -pMypass db_name < sql_data.sql But it takes about 5 hours to complete the task. I tried using ...
1
vote
1answer
158 views

MariaDB 10.0 slow work mysqldump

i have 1.800(innodb) DBs in my MariaDB 10.0, 'mysqldump' work very slowly! If i run 'mysqldump' starts the process: "SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE , EXTRA ...
0
votes
1answer
479 views

How do I connect to an AWS RDS with MySQL Workbench? [closed]

I've read this documentation and several other sources but to no avail: I cannot connect to my MySQL instance from MySQL Workbench. I can connect to my RDS instance through EC2, but I cannot dump ...
0
votes
1answer
81 views

Increase the speed of mysqldump

Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using: mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options ...
2
votes
1answer
486 views

mysqldump error #1557: corrupt event table?

I just noticed the following error from my old mysql backup scripts: % mysqldump -hsql -uXXXX -pXXXX --events --all-databases > /dev/null mysqldump: Couldn't execute 'show events': Cannot proceed ...
1
vote
1answer
454 views

How to calculate the size of an AWS RDS instance from a MySQL dump?

We are importing a large historical database into RDS from a mysqldump The gziped sql file was 3GB, the uncompressed sql file is 18GB. We created a 30GB AWS RDS instance and imported the file... the ...
3
votes
1answer
110 views

Restore database by files from broken Ubuntu server

I'm pretty lost right now. The RAID controller auf my server broke and all attached hard drives were corrupted. Luckily I copied the plain files off the server right before the crash (phew). I set ...
0
votes
0answers
78 views

mysqldump over ssh and mysql restore - security issue?

I've just found a one liner to mirror a local mysql database on a remote server, over ssh: mysqldump -uroot -proot zedatabase | ssh -p4551 geek@12.34.56.78 "mysql -udoom -pmySqlPassword zedatabase" ...
1
vote
1answer
41 views

Import SQL Dump from Command Line

I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the ...
3
votes
2answers
1k views

Couldn't execute 'show events' on mysqldump

While trying to backup all MySQL databases with mysqldump I get the following error: Couldn't execute 'show events': Access denied for user 'user'@'localhost' to database 'performance_schema'
2
votes
2answers
142 views

mysqldump has a “quick” option. Why isn't this enabled by default?

In the mysqldump docs I see a "--quick" option, however there is no indication as to why somebody would want this disabled. What are the disadvantages to enabling it or why is it even an option? ...
0
votes
2answers
50 views

how to restore sql file?

I have 2 MySQL servers. Server A is up to date. I run the following on Server A: mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql on Server B I run: mysql -u root ...
-2
votes
1answer
32 views

What are the various ways to backup an MySQL server? [closed]

I am trying to figure out how someone backed up our database. We had a person working for us who was able to backup the database on a server without having mysql client or mysqldump installed on the ...
0
votes
1answer
193 views

How to run a mysqldump automated with SAFELY stored mysql credentials?

I'm looking for a way to SAFELY run daily backups using mysqldump. Safely means not storing username/password in a text file or any other unencoded format. I know there is (apparently it isn't) a way ...
3
votes
1answer
52 views

Is it safe to lock tables on a mysql replica slave?

I have a master mysql database where the application writes and read production data, and then I setup a slave database just in case something goes wrong with the master database server (and I can do ...
1
vote
2answers
584 views

mysqldump isn't able to export a specific database, phpMyAdmin crashes

I'm experiencing problems with a database on my server (Note: All other databases work fine). Once I try to export it with mysqldump I get this error: # mysqldump -u root -pXXXXXXXXX databasename ...
2
votes
1answer
690 views

MySQL “Zombie”-table, cannot delete

I have two MySQL servers, running master/slave replication. At one point i had to write huge general.log on the slave. I had the glorious idea to write it to the datadir of MySQL. Mock me. Later I ...
1
vote
1answer
72 views

How to properly migrate mysql server?

Currently I am dealing with server migration. I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases. All I need is somehow safely and fast ...
0
votes
0answers
152 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
162 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
30 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 ...
0
votes
1answer
542 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 ...
1
vote
1answer
60 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
222 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
272 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
1answer
315 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
197 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
2answers
89 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
103 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
323 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
128 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?
1
vote
2answers
3k 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
2answers
250 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 ...
3
votes
2answers
5k 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
2k 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
592 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
626 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
439 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
294 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
74 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
583 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
1k 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 ...