Guest Posted September 6, 2005 Share Posted September 6, 2005 Hi Folks, V2 had a databse backup utility in the Admin Section, but I can't see anything similar in V3. Point me in the right direction someone, please :mellow: Quote Link to comment Share on other sites More sharing options...
roban Posted September 6, 2005 Share Posted September 6, 2005 I haven't seen one. Backup from PHPMyAdmin Quote Link to comment Share on other sites More sharing options...
kinetic Posted September 6, 2005 Share Posted September 6, 2005 CubeCart 3 does not have a database back up feature as this was assumed to be a security risk because people would back up and download the sql file but then would not delete the backup file from their server even tho they were warned to delete it as leaving your backed up sql file in your backup directory is a HUGE security risk especially since passwords were not encrypted in the database in v2 flavors... to back up your database login to your cpanel (if you have it) and go into mysql and click on the phpmyadmin link from there click export at the top click the select all and make any other clicks for options like extended inserts etc and save as a file (give it a name) and save the sql file on your hard drive hope this helps Quote Link to comment Share on other sites More sharing options...
Guest Posted September 6, 2005 Share Posted September 6, 2005 It would be so good if we could have a secure backup that works like in V2. I have no problem with phpMyAdmin, but my clients wouldn't handle it. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 6, 2005 Share Posted September 6, 2005 Have tried exporting and running sql which results in............ You have an error in your SQL syntax near 'default int(1) DEFAULT '0' NOT NULL , KEY moduleId (moduleId) )' at line 1. Query: CREATE TABLE CubeCart_Modules ( moduleId int(11) DEFAULT '' NOT NULL auto_increment, module varchar(10) DEFAULT '' NOT NULL , folder varchar(30) DEFAULT '' NOT NULL , status smallint(1) DEFAULT '0' NOT NULL , default int(1) DEFAULT '0' NOT NULL , KEY moduleId (moduleId) ) As I know slightly less than zero about SQL, any help would be greatly appreciated. Cheers, Ally. Quote Link to comment Share on other sites More sharing options...
Guest Denver Dave Posted September 6, 2005 Share Posted September 6, 2005 It would be nice to have the database backup commands from phpMyAdmin in a script file. I'm not sure how we would do the flow control, but instead of backing up numerous databases on several servers - perhaps we could just run a script and maybe click the enter to save. Anyone doing this? Another option which would be great would be to FTP to another server. Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted September 8, 2005 Share Posted September 8, 2005 Aly, It might be to do with reserved words being used as field names. Read this thread. Estelle. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.