im currently been told to do this backup in case the hosting took a major fall or something, kinda got me worried so here i am
i see the compress for www folder which included both my html/php information among anything that webbased.
now im a the mysql stage using phpmyadmin i have selected the database via going to export but there are many options so i wanted to run by you all to see whcih were the bestt if HEAVEN forBid you guys disappear and im rendered to go to another hosting provider (please god No!!)
Export
SQL - i assume this is the best one to choose????????
Options
Add custom comment into header (\n splits lines) (BLANK)
Enclose export in a transaction (BLANK CHECKBOX)
Disable foreign key checks (BLANK CHECKBOX)
SQL compatibility mode
NONE
ANSI
DB2
MAXDB
MYSQL323
MYSQL40 - This one?
Database export options
Add DROP DATABASE (BLANK CHECKBOX)
Structure (CHECKED CHECKBOX)
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION (BLANK CHECKBOX)
Add IF NOT EXISTS (CHECKED CHECKBOX)
Add AUTO_INCREMENT value (CHECKED CHECKBOX)
Enclose table and field names with backquotes (CHECKED CHECKBOX)
Add CREATE PROCEDURE / FUNCTION (BLANK CHECKBOX)
Add into comments
Creation/Update/Check dates (BLANK CHECKBOX)
Data (CHECKED CHECKBOX)
Complete inserts (BLANK CHECKBOX)
Extended inserts (BLANK CHECKBOX)
Maximal length of created query (BLANK)
Use delayed inserts (BLANK CHECKBOX)
Use ignore inserts (BLANK CHECKBOX)
Use hexadecimal for BLOB(CHECKED CHECKBOX)
Export type
INSERT (Selected)
UPDATE
REPLACE
as for the rest of this im confused on what to choose? Please advise me GURUS and to think i thought i was one this this option. also im sorry for the large post but i couldnt think of a easier way to show this
Thanks in Advance
i see the compress for www folder which included both my html/php information among anything that webbased.
now im a the mysql stage using phpmyadmin i have selected the database via going to export but there are many options so i wanted to run by you all to see whcih were the bestt if HEAVEN forBid you guys disappear and im rendered to go to another hosting provider (please god No!!)
Export
SQL - i assume this is the best one to choose????????
Options
Add custom comment into header (\n splits lines) (BLANK)
Enclose export in a transaction (BLANK CHECKBOX)
Disable foreign key checks (BLANK CHECKBOX)
SQL compatibility mode
NONE
ANSI
DB2
MAXDB
MYSQL323
MYSQL40 - This one?
Database export options
Add DROP DATABASE (BLANK CHECKBOX)
Structure (CHECKED CHECKBOX)
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION (BLANK CHECKBOX)
Add IF NOT EXISTS (CHECKED CHECKBOX)
Add AUTO_INCREMENT value (CHECKED CHECKBOX)
Enclose table and field names with backquotes (CHECKED CHECKBOX)
Add CREATE PROCEDURE / FUNCTION (BLANK CHECKBOX)
Add into comments
Creation/Update/Check dates (BLANK CHECKBOX)
Data (CHECKED CHECKBOX)
Complete inserts (BLANK CHECKBOX)
Extended inserts (BLANK CHECKBOX)
Maximal length of created query (BLANK)
Use delayed inserts (BLANK CHECKBOX)
Use ignore inserts (BLANK CHECKBOX)
Use hexadecimal for BLOB(CHECKED CHECKBOX)
Export type
INSERT (Selected)
UPDATE
REPLACE
as for the rest of this im confused on what to choose? Please advise me GURUS and to think i thought i was one this this option. also im sorry for the large post but i couldnt think of a easier way to show this
Thanks in Advance
Last edited: