Topic awaiting preservation: Backup MySQL (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12523" title="Pages that link to Topic awaiting preservation: Backup MySQL (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: Backup MySQL <span class="small">(Page 1 of 1)</span>\$

KARN Bipolar (III) Inmate From: North Bay, Ontario, CA Insane since: Apr 2001	posted 11-25-2002 05:34 My host doesn't have a backup button... or anything.... I'm trying to backup the database of my forum.. any clues?
Emperor Maniac (V) Mad Scientist with Finglongers From: Cell 53, East Wing Insane since: Jul 2001	posted 11-25-2002 05:36 KARN: Do you have access to something like cron? ___________________ Emps FAQs: Emperor
Tyberius Prime Paranoid (IV) Mad Scientist with Finglongers From: Germany Insane since: Sep 2001	posted 11-25-2002 11:40 install phpmyadmin, if you haven't already. Choose 'dump database', 'structure and data', 'complete inserts' and the like. store the resulting file somewhere. voila. backup. so long, Tyberius Prime
Piper Paranoid (IV) Inmate From: California Insane since: Jun 2000	posted 11-25-2002 14:39 Hi KARN, If you have shell access you can use the following commands to backup/restore your MySQL database: Backup: mysqldump --add-drop-table -uUSERNAME -pPASSWORD DB > backup.txt Restore: mysql -uUSERNAME -pPASSWORD DB < backup.txt You can gzip backup.txt and download it to a safe place. Regards, Charlie
bitdamaged Maniac (V) Mad Scientist From: 100101010011 <-- right about here Insane since: Mar 2000	posted 11-25-2002 17:57 Also check with your host. Most do regular tape backups with snapshots of sites. Like with any type of system you'll lose the newest data but I bet they do have some sort of redundancy built in. Most backup systems don't require any sort of manual hits. That's leaving too much to chance. .:[ Never resist a perfect moment ]:.
KARN Bipolar (III) Inmate From: North Bay, Ontario, CA Insane since: Apr 2001	posted 11-26-2002 02:12 No I don't have shell access... I'll try the other options and see how it plays out...
Pugzly Paranoid (IV) Inmate From: 127.0.0.1 Insane since: Apr 2000	posted 11-26-2002 03:42 It's too bad you don't have shell access. I have a neat little shell script that runs via cron. It connects to MySQL, dumps the file to a gziped file above doc root, and sets permissions. I've actually got a newer version of the same script that emails the file to me as well. But phpmyadmin will allow you to do it manually, which sounds like the only way you're going to get it to work.

Topic awaiting preservation: Backup MySQL (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12523" title="Pages that link to Topic awaiting preservation: Backup MySQL (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: Backup MySQL <span class="small">(Page 1 of 1)</span>\$

KARN
Bipolar (III) Inmate

From: North Bay, Ontario, CA
Insane since: Apr 2001

posted 11-25-2002 05:34

My host doesn't have a backup button... or anything.... I'm trying to backup the database of my forum.. any clues?

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted 11-25-2002 05:36

KARN: Do you have access to something like cron?

___________________
Emps

FAQs: Emperor

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted 11-25-2002 11:40

install phpmyadmin, if you haven't already.
Choose 'dump database', 'structure and data', 'complete inserts' and the like. store the resulting file somewhere.
voila. backup.

so long,

Tyberius Prime

Piper
Paranoid (IV) Inmate

From: California
Insane since: Jun 2000

posted 11-25-2002 14:39

Hi KARN,

If you have shell access you can use the following commands to backup/restore your MySQL database:

Backup: mysqldump --add-drop-table -uUSERNAME -pPASSWORD DB > backup.txt
Restore: mysql -uUSERNAME -pPASSWORD DB < backup.txt

You can gzip backup.txt and download it to a safe place.

Regards,
Charlie

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted 11-25-2002 17:57

Also check with your host. Most do regular tape backups with snapshots of sites. Like with any type of system you'll lose the newest data but I bet they do have some sort of redundancy built in.

Most backup systems don't require any sort of manual hits. That's leaving too much to chance.

.:[ Never resist a perfect moment ]:.

KARN
Bipolar (III) Inmate

From: North Bay, Ontario, CA
Insane since: Apr 2001

posted 11-26-2002 02:12

No I don't have shell access... I'll try the other options and see how it plays out...

Pugzly
Paranoid (IV) Inmate

From: 127.0.0.1
Insane since: Apr 2000

posted 11-26-2002 03:42

It's too bad you don't have shell access. I have a neat little shell script that runs via cron. It connects to MySQL, dumps the file to a gziped file above doc root, and sets permissions. I've actually got a newer version of the same script that emails the file to me as well.

But phpmyadmin will allow you to do it manually, which sounds like the only way you're going to get it to work.