Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Backing up the DB drama


Guest

Recommended Posts

Posted

Hi,

 

I 'm testing the osC app to see if everything works on XP Pro and so far, so good. The main drama I'm having is trying to backup the db. I click the button, the script runs and then displays a green msg saying success database backed up. When I look in the web server backup dir, there is no db, not a single file in there. My dir structure is as follows:

test>admin>backup.

 

Also, does anyone know how to import the db into MSSQL with the import/export data client? I can see and option for MySQL. Or how do I export a db from MySQL 8) ?

 

My admin config looks like this.

 

// define our webserver variables



//FS = Filesystem (physical)How do I enable this on ISS5?



//WS = Webserver (virtual) How do I enable this on ISS5?



 define('HTTP_SERVER', 'http://localhost/test); // eg, http://localhost or - https://localhost should not be NULL for productive servers

 define('HTTP_CATALOG_SERVER', 'http://localhost/test);

 //define('HTTPS_CATALOG_SERVER', 'https://localhost/test);

 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

 define('DIR_FS_DOCUMENT_ROOT', 'c:/inetpub/wwwroot/test); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

 //define('DIR_FS_DOCUMENT_ROOT', '$DOCUMENT_ROOT');

 define('DIR_WS_ADMIN', '/admin/');

 define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

 define('DIR_WS_CATALOG', '/catalog/');

 define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

 define('DIR_WS_IMAGES', 'images/');

 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

 define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

 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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

 define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

 define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

 //define('DIR_FS_CATALOG_IMAGES', 'c:/Inetpub/wwwroot/I-Sell/catalog/images/');

 define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 define('DIR_FS_CACHE', DIR_FS_ADMIN . 'tmp/');

// define our database connection

 define('DB_SERVER', 'localhost');

 define('DB_SERVER_USERNAME', 'test');

 define('DB_SERVER_PASSWORD', 'test');

 define('DB_DATABASE', 'catalog');

 define('USE_PCONNECT', 'false');

 define('STORE_SESSIONS', '');

 

Thanks for any help you can give.

Posted

You say there is nothing in /admin/backup and in the config file it says it should be /admin/backups. Have you checked that directory?

Posted
When I look in the web server backup dir, there is no db, not a single file in there. My dir structure is as follows:

test>admin>backup.

 

So the config looks right to you? You say it's set to admin/backups, didn't you mean test/admin/backups? Or is the config wrong?

Posted

sorry, that was a typo. It is in fact backups.

 

NB You can't edit your posts on this forum so there is no way to fix a typo! :evil:

Posted

Ok, it's working now. I just reinstalled the site and it work :lol:

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...