I'm attempting to export about 150GB of data from a database with hundreds of tables, and have found mysqldump to be very buggy.
After running a simple --all-databases dump succeeds, but the import always encounters random (and frequent) errors. These are generally syntax errors in the SQL statements because of incorrectly escaped quotation marks within the dump file.
I've done raw data transfers before by copying the actual data files, however the destination server I seek to import into does not allow me to access the file system.
Are there any other tools that are less buggy than mysqldump for very large exports/imports?