database backup

[MeltDown]

a lot of the hacks say make sure to back up your database before installing this hack (in case something goes horribly wrong)....

what is the best, fastest, easiest way to backup the "database" and what files do I specifically need to back up?

...And what about the BackUp MYSQL Plugin? It certainly is the most simple way to backup the database. Is it thorough? I have it installed and use it but have never needed to reload one of my backups.

[gsdcypher]

thanks.

ok. found the myphpadmin and i choose export database.

on this screen it says:

export: and sql is selected. i can also select others? but i should leave sql selected?

sql options: do i need any or none?

database options: do i need to check add drop database?

structure: what should i check?

data: what should i check? what should i set for max length?

save file as: should it be compressed?

just trying to do it right. thanks!

[nick04263]

From the Tutorials Section:

How can I do a database-backup with phpMyAdmin?


The ideal settings to do a backup via phpMyAdmin are shown below.

NOTE: BEFORE clicking on "Export", you should select your database from the dropdown, so that its tables are displayed. THEN click on the "Export" tab.

- CHECKED: Structure
- CHECKED: Add DROP TABLE
- CHECKED: Add AUTO_INCREMENT value
- CHECKED: Enclose table and fieldnames with backquotes
- CHECKED: Data
- CHECKED: Complete Inserts
- CHECKED: Extended Inserts
- CHECKED: Use hexadecimal for binary fields
- Export Type: INSERT
- CHECKED: Save as File
- Filename Template: __DB__
- Compression: "gzipped" (or whatever you prefer... gzip makes smaller files)



TO RESTORE THE DATABASE:
- open phpMyAdmin
- select the database you wish to restore INTO, from the dropdown menu
- click on the "SQL" tab (in newer phpMyAdmin versions, you might have to click the "Import" tab instead, to get the "Browse" button mentioned next:)
- click on the Browse button, and select the file you downloaded when making the backup
- click Go

[Merlinpa1969]

your best bet is to install the backup module that was described above,

then always make sure to backup before adding any module,

( hack is usually a dirty word for websites ) lol

once you have the backup module in place you can then do the DB backup from the ZC admin,

as for downloading your files,
yes it is always a good idea to make a complete backup on your desktop but this isnt something that you need to do often, since the files dont change on a daily basis

[gsdcypher]

thanks again.

if i download the MOD ;-) then unzip it, i just ftp it to my cart folder and run it from admin? that sounds easy??? do i ftp in bin or ascii?

[Merlinpa1969]

just use auto

[gsdcypher]

sweet. it worked. it think... we'll see we i need to restore it. lol.

thanks.