Date: Tue, 7 Oct 2008 15:36:41 +0100 From: "Marc Coyles" <mcoyles@horbury.wakefield.sch.uk> To: <freebsd-questions@freebsd.org> Subject: Consistency of MySQL dumps... Message-ID: <008101c9288a$1cffbdd0$56ff3970$@wakefield.sch.uk>
next in thread | raw e-mail | index | archive | help
Here's one that's puzzling me... If I use /usr/local/bin/mysqldump to make a backup of a database, the file it produces fails to restore with "Check syntax near..." error. If I then head into cPanel, to their "Backup" menu, and take a backup of the database from there, the file it produces also fails to restore with "Check syntax near..." error, but at a COMPLETELY different point thru the restore. If I head into cPanel, to phpmyadmin, and do an export from there... the file restores PERFECTLY without errors. Sooo... how can I write a script that'll backup a MySQL database and produce a useable file?? This problem is occurring on 2 of my 8 databases... it appears the chosen software used to produce the dump of MySQL data is the culprit... what is the best commandline (ie: cron-able) tool to use for the task? Marc A Coyles - Horbury School ICT Support Team Mbl: 07850 518106 Land: 01924 282740 ext 730 Helpdesk: 01924 282740 ext 2000
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?008101c9288a$1cffbdd0$56ff3970$>