How to backup my database?


#1

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?


#2

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.


Norm