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 ...
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 ...
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 ...
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 ...
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 ...
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 ...