Mysql database backup after domain expired?


#1

one of my domain is expired, so I can not access it via mysql.domain.com

so how can I get back my database? from cpan interface? I can’t find the option.

thanks.


#2

Find out which machine your account is on; you can do this by Manage Users in the panel, and your userlist will include machine names.

SSH (or telnet) to machinename.dreamhost.com

Do the following command to dump the database to a file:
/usr/bin/mysqldump --all-databases -dbSERVER.DOMAIN.com -uUSERNAME -p > gl.sql

Then you can FTP to machine.dreamhost.com and get your file.

-Scott


#3

but my domain is expired, i can’t access it.

so you mean dbSERVER.DOMAIN.com equals machinename.dreamhost.com ?


#4

It sounded like you still had other domains here. Is this true?

If you can still SSH or Telnet into your other domain and do the mysqldump to the dbserver.dreamhost.com.

-Scott