0
votes
0answers
15 views

How to verify dumpedfiles.sql is taken correctly with no errors

I had a problem before on one of my servers, Database backup was taken using: mysqldump --single-transaction and one day i needed to restore the daily backup and found the dumpedfile.sql is ...
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
votes
2answers
251 views

mysqldump in cron not working [duplicate]

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 ...
1
vote
2answers
282 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 ...
4
votes
2answers
179 views

Can I mysqldump an entire DB connection?

I am hosted on a Media Temple DV 3.5 server and looking to upgrade from mysql 5.0.90 to the latest mysql so I can use triggers and foreign keys. I am a bit nervous to do so because I don't have a ...
2
votes
1answer
766 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 ...