Posted by: majestique
Posted on: 2006-03-16 12:38:00
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?
Posted by: ardco
Posted on: 2006-03-16 14:46:00
You could search this forum and the wiki for mysql backup mb dump and similar. But here's a start from the ole kbase:
http://blog.dreamhosters.com/kbase/index.cgi?area=2931
Good luck,
BobS
Posted by: norm1037
Posted on: 2006-03-16 15:18:00
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.