My databases are quite huge… 50mb+ and dreamhost’s phpmyadmin can’t export the DBs correctly… what other options do I have to back it up? probably use some 3rd party tools?
If you can ssh into your account then perhaps mysqldump can be used :-
mysqldump -u norm -p -h normdb.example.com dbnamehere >testing.sql
This creates a file of sql statements which you could use to create a new mysql database somewhere.
(If it is not clear the -u is the username,-p is the password which will be prompted for,-h is the hostname of the database and 'dbnamehere is the database you wish to copy.