Forums / Install & configuration / All Database Tables Deleted

All Database Tables Deleted

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Valerie Lynn

Wednesday 25 August 2004 1:49:15 pm

You know it's a BAD day when you are - reinstalling EZPublish using the wizard and you get to the part where you can choose delete all data from your database...and well, you do.

The problem is, my "database" was comprised of several different tables, 1 set for one application, another set for a second application and the newly created ez publish tables for - you guesed it - the EZPublish Application - all separated by the first two characters of the table names.

Word to the wise - ALL tables were deleted - not just tables associated with EZPublish.

Val
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
Is it dinnertime yet?

Bård Farstad

Wednesday 25 August 2004 1:57:18 pm

Ouch!

We should make eZ publish only delete the tables prefixed with ez.

I hope you had backup.

--bård

Documentation: http://ez.no/doc

Trond Åge Kvalø

Thursday 26 August 2004 6:51:29 am

Actually it would be best if eZpublish only deleted the tables it created at setup.

What if someone has their own tables that start with ez?

Maybe the prefix should be something more distinct?

just a few thoughts....

best regards
trondåge

trondåge

Bruce Alspaugh

Friday 27 August 2004 9:13:55 am

I'm suprised that in the install wizard you are not given the option to specify what the table prefix should be. A lot of hosting providers only allow you to have one database so you have to share it with multiple applications. If you can specify your own prefix, EZPublish can more easily play nice nicely with other applications. When it comes time to delete tables, you can tell it to delete only those with a certain prefix.

Trond Åge Kvalø

Tuesday 14 September 2004 6:54:24 am

You'd think that one should be able to learn from other peoples mistakes, but naahhh....

Now our tables are gone too :-/

We do of course have backup, but still, it's quite a nuisance to restore everything.

So does the eZ crew have an ETA for the excellent feature that Bruce described in the post above?

best regards

trondåge

eZ debug

Timing: Jan 30 2025 19:41:18
Script start
Timing: Jan 30 2025 19:41:18
Module start 'content'
Timing: Jan 30 2025 19:41:18
Module end 'content'
Timing: Jan 30 2025 19:41:18
Script end

Main resources:

Total runtime0.2943 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0087 588.0469370.2891
Module start 'content' 0.00870.0147 958.33591,005.5625
Module end 'content' 0.02340.2708 1,963.89843,893.8438
Script end 0.2942  5,857.7422 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00471.5967200.0002
Check MTime0.00140.4679200.0001
Mysql Total
Database connection0.00130.425710.0013
Mysqli_queries0.197967.23041410.0014
Looping result0.00140.46241390.0000
Template Total0.270391.910.2703
Template load0.00070.237810.0007
Template processing0.269691.615010.2696
Override
Cache load0.00050.170510.0005
Sytem overhead
Fetch class attribute can translate value0.00190.640510.0019
XML
Image XML parsing0.00030.088310.0003
General
dbfile0.01033.4866200.0005
String conversion0.00000.001730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs