Re: Slightly OT - Backing up mySQL...
| From: | Felix Kronlage | Date: | Sun, 06 May 2001 15:57:38 +0000 |
| Subject: | Re: Slightly OT - Backing up mySQL... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-51625@lists.php.net to get a copy of this message | ||
On Sun, May 06, 2001 at 08:38:23AM -0700, Nick Terzich wrote:
> Does anyone have any experience backing up mySQL from
> a "shared" web hosting account? I don't have root
> access to the database... will this keep me from
> running a shell script to do the back up?
If you have shell-access you can use mysqldump to do a dump
of the database. Later you can use
'mysql -u user -p < dumpfile' to restore the database.
Check the man-page for mysqldump for details.
-fkr
--
gpg-fingerprint: 076E 1E87 3E05 1C7F B1A0 8A48 0D31 9BD3 D9AC 74D0
|http://www.hazardous.org/ | whois -h whois.ripe.de
FKR-RIPE |
|all your base are belong to us | shame on me | fkr@IRCnet |