Unsure of how to backup mySQL Database

[TCwho]

I read the KB about the Database Backup Manager.... tells me to create folder etc...

but in my admin console it tells me to configure in my configure.php file.... but the KB never said anything about doing anything to the configure.php file????

 

everything is still in its default state right now....

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.thelighthousebooks.com'); // eg, http://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'https://ssl.perfora.net'); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', true); // secure webserver for checkout procedure?
define('HTTP_COOKIE_DOMAIN', 'www.thelighthousebooks.com');
define('HTTPS_COOKIE_DOMAIN', 'https://ssl.perfora.net/thelighthousebooks.com');
define('HTTP_COOKIE_PATH', '/catalog/');
define('HTTPS_COOKIE_PATH', '/catalog/');
define('DIR_WS_HTTP_CATALOG', '/catalog/');
define('DIR_WS_HTTPS_CATALOG', '/thelighthousebooks.com/catalog/');
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
define('DIR_FS_CATALOG', '/homepages/15/d113630270/htdocs/catalog/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

and where is a good place to put the backup folder??? under _private?

Yesturday I used phpMyAdmin to export the database but I was not sure of what options to use.....

[ozcsys]

By default your backup folder is admin/backups in your configure.php file

 

If you want it somewhere else then you will need to edit your configure.php file if that is fine for you then just make sure you have a backups folder in your admin directory and it has write permissions. If if does not have write permissions you will get the same error message as if it was not there at all.

[TCwho]

By default your backup folder is admin/backups in your configure.php file

 

If you want it somewhere else then you will need to edit your configure.php file if that is fine for you then just make sure you have a backups folder in your admin directory and it has write permissions. If if does not have write permissions you will get the same error message as if it was not there at all.

<{POST_SNAPBACK}>

 

 

!!!!!!!!!!

 

Thanks Richard. I have been waiting to ask this one for almost two weeks.........

 

That was simple enough eh :lol:

 

Do you recommened using https for admin? Right now I only have it setup for the normal catalog side of things.

[TCwho]

Hmmm???

 

another question for you...I used phpMyAdmin to export database yesturday and ...the size was 327KB(unzipped) ...but what I just created in backups is only 289KB(no compression used)

 

I wasnt to sure what to tick in phpMyAdmin but I just choose to backup everything everything I could see including :

 

Add DROP DATABASE

 

Structure

Add 'drop table'

Add AUTO_INCREMENT value

Enclose table and field names with backquotes

 

ADD INTO COMMENTS

Comments

 

DATA

Extended Inserts

 

...just curious as to why the file sizes are different....

[ozcsys]

!!!!!!!!!!

 

Thanks Richard.  I have been waiting to ask this one for almost two weeks.........

 

That was simple enough eh :lol:

 

Do you recommened using https for admin?  Right now I only have it setup for the normal catalog side of things.

<{POST_SNAPBACK}>

 

It is probably not a bad idea though it will slow things down a bit. Just change the top http: define to your secure path.

[TCwho]

I think we were posting at the same time.... :P

 

Will take you up on the recommedation to use secure transfer on admin side...

 

Did you get the very last post I made right before you posted ?

Hmmm???

 

another question for you...I used phpMyAdmin to export database yesturday and ...the size was 327KB(unzipped) ...but what I just created in backups is only 289KB(no compression used)

 

I wasnt to sure what to tick in phpMyAdmin but I just choose to backup everything everything I could see including :

 

Add DROP DATABASE

 

Structure

Add 'drop table'

Add AUTO_INCREMENT value

Enclose table and field names with backquotes

 

ADD INTO COMMENTS

Comments

 

DATA

Extended Inserts

 

...just curious as to why the file sizes are different....

 

(btw from spending enough time here...somewhere stored in my brain is ...some fuzzy knowledge of reading if you have a shared server.... secure admin is not recommended.....or am I mistaken?)