Backing up database

[besheer]

Out of all the following settings, what are the optimal options to choose when backing up the database in phpmyadmin?

SQL options
Add custom comment into header (\n splits lines):
Enclose export in a transaction
Disable foreign key checks

Database export options:
Add DROP DATABASE

Structure:
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add into comments
Creation/Update/Check dates
SQL export compatibility:

Data:
Complete inserts
Extended inserts
Use delayed inserts
Use ignore inserts
Use hexadecimal for binary fields
Export type:

[DrByte]

http://www.zen-cart.com/wiki/index.p...P_THE_DATABASE

[besheer]

Thank you.

And here it is:

TO BACKUP THE DATABASE

These are the ideal settings to do a backup via phpMyAdmin:

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)

[edit]
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

[brisbanetimeout]

I must be thick or something... I have version 1.3.0.1 and I have never done a back up and I cannot find the phpadmin to do the back up in... I am in Admin and I have looked in all menus and cannot find anything that mentions back up. One thread said there was a button called 'backup' on the main screen... well not on my screen ??

How do you do a back up ??

Ta
Dave

[DrByte]

phpMyAdmin is typically supplied by your hosting company ... you can usually access it from the same screen as where you create/manage databases

[brisbanetimeout]

Hosting compnay ???
Is it a file on the server ??
What folder is it in ??

Wouldnt it be easy if there was a button called 'Backup' in the Admin section...maybe under 'Tools' .. like that is where I would look...

[swguy]

Are you just running ZenCart on your own pc? If you're hosting it yourself, you can always download phpmyadmin yourself, and run it on your own machine. Downloadit from

http://www.phpmyadmin.net/home_page/index.php

Ultimately you will upload all your files to someone else's server - and this someone else will be your hosting company.

Good luck,
Scott

[brisbanetimeout]

Well... its on the net at www.timeoutmassage.com.au/zen ... I can log into the server and upload files ect onto the server... is this what you mean ??

[swguy]

Yes. Ask if these guys have phpmyadmin. They will be able to tell you
how to get to it.

Good luck,
Scott