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 _______________________________________________ email@example.com mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"