Consistency of MySQL dumps...
Marc Coyles
mcoyles at horbury.wakefield.sch.uk
Tue Oct 7 14:37:04 UTC 2008
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
More information about the freebsd-questions
mailing list