2
votes
2answers
69 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
87 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 ...
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 ...
1
vote
2answers
630 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 ...
0
votes
2answers
303 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
6k 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 ...
1
vote
2answers
278 views

Saving MySQL databases without mysqldump

I need to back up some of my databases and migrate them over to a new server. I would use mysqldump , but the problem is that I'm having issues starting mysqld/mysql (part of the reason I'm ...
2
votes
5answers
1k views

Slow Mysql import

I import a database, and when i run mytop i see only one thread running an insert. On a big database of 80G that will take really big time, is there any tools or may be an option to increase number of ...
1
vote
1answer
476 views

Zenoss MySQL database backups are huge after multiversion upgrade

The Context: We ran Zenoss 2.2 for way too long, and decided it was time to upgrade to the current version, 3.2. I followed the upgrade steps here, and checked to make sure everything was working ...
2
votes
2answers
1k views

How to dump a mysql database and transfer to remote ftp in one line -for crontab-?

I need to do a weekly backup of a mySQL table and then transfer it to a remote machine using ftp. This is the command I have now in crontab: 0 18 * * 1 /usr/bin/mysqldump --add-drop-table ...
0
votes
3answers
264 views

Cronjob to Backup Database every day at 10pm

I managed to setup a cronjob: * 13 * * * date=`date +\%d-\%m-\%Y-\%s`; mysqldump -u root -pPassword1 db121 > /home/backup/xbackup_$date.sql; gzip /home/backup/xbackup_$date.sql I am hoping the ...
2
votes
1answer
764 views

Severe mysqldump performance degradation using Centos Linux, 8GB PAE and MySQL 5.0.77

We use MySQL 5.0.77 on CentOS 5.5 on VMWare: Linux dev.ic.soschildrensvillages.org.uk 2.6.18-194.11.4.el5PAE #1 SMP Tue Sep 21 05:48:23 EDT 2010 i686 i686 i386 GNU/Linux We have recently upgraded ...
1
vote
2answers
309 views

difference between mysql and mysqldump

I am going to importi a database.. (db.sql) I will use something like: mysql -u root -p db < db.sql Can you tell me what the difference is between this and mysqldump? Thanks
5
votes
3answers
3k views

Redirect output of mysqldump to scp

I worked with a linux pro years ago who did this nifty trick. He could do a mysqldump but redirect the output to an scp/ssh connection rather than writing to disk. We utilised this quiet a bit where i ...
1
vote
1answer
76 views

remotely dump & retrieve mysql db

I've just set up a new linux server to hold my MySQL DB currently running on a Win7 box. I have root access to both machines / DB. I would like to remotely (from the linux box) connect to the DB on ...
1
vote
5answers
359 views

Do I need to bring my website down just in order to use mysqldump?

I have a LAMP website with mysql backend with InnoDb engine for tables I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. ...
0
votes
2answers
2k views

MySQL differential dump? Other strategy for restore?

Is it possible to generate a differential dump with mysqldump - between two databases, or, ideally, between a database and a dumped version of that database? Here's the issue I've got - I have an ...