The Joomla! Forum ™

Download

Demo


Board index » Joomla! 2.5 - Ask Support Questions Here » Language - Joomla! 2.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 8 posts ] 
  Print view Previous topic | Next topic 
Author Message
Rutger1973
PostPosted: Sat Apr 21, 2012 8:20 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Aug 20, 2008 11:27 am
Posts: 11
Hi Guys

Question... I have made a simple website in 2.5.4 without any exciting stuff. Bassically, just a website with 5 pages and 2 languages. However, when I make an export of the DB it is a DB of 1.4 MB? I have emptied the trash and I saw that i.5 Joomla website with more content have a DB of around 150 -200 Kb. How can this be?

I make an .sql export using PHPmyAdmin. Is there something taht I should should change or do differently? With older versions of Joomla I have always worked like this.

thx
Top
 Profile  
 
infograf768
PostPosted: Sun Apr 22, 2012 6:19 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Fri Aug 12, 2005 3:47 pm
Posts: 16637
Location: **Translation Matters**
Something wrong in your db. Are you sure you deleted all trashed items for every manager?

FYI, the multilang demo site DB ( http://multilingual-joomla-demo.cloudaccess.net/ ) is 128k as .sql.gz and 744kb as non-compressed .sql

_________________
Jean-Marie Simonet / infograf · http://www.info-graf.fr
Multilanguage in 2.5: http://help.joomla.org/files/EN-GB_multilang_tutorial.pdf
---------------------------------
Joomla Translation Coordination Team • Joomla! Production Working Group
Top
 Profile  
 
Rutger1973
PostPosted: Mon Apr 23, 2012 3:22 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Aug 20, 2008 11:27 am
Posts: 11
Yes, I am sure I have remove the trash of all articles and modules. It shrunk from 1.7 to 1.4 Mb. I do see that there are all kinds of different prefixes in the DB. I don't know if that's normal?
Top
 Profile  
 
infograf768
PostPosted: Tue Apr 24, 2012 7:58 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Fri Aug 12, 2005 3:47 pm
Posts: 16637
Location: **Translation Matters**
Ah.. that's it.
Look at your Global Configuration for the table prefix used.

Then delete all tables who do not have that prefix in your db (make a back-up of the db first).

_________________
Jean-Marie Simonet / infograf · http://www.info-graf.fr
Multilanguage in 2.5: http://help.joomla.org/files/EN-GB_multilang_tutorial.pdf
---------------------------------
Joomla Translation Coordination Team • Joomla! Production Working Group
Top
 Profile  
 
Rutger1973
PostPosted: Tue Apr 24, 2012 9:03 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Aug 20, 2008 11:27 am
Posts: 11
Yes, indeed that helped a lot. However, still it is about 850 kb and that seems a lot. I have the impression that somehow, I am doing something worng because I am (still) getting an error message:

SQL-query: Documentatie

CREATE ALGORITHM = UNDEFINED DEFINER = `testee01_eeuwige`@`localhost` SQL SECURITY DEFINER VIEW `rg9k0_jf_languages` AS SELECT `l`.`lang_id` AS `lang_id` , `l`.`lang_code` AS `lang_code` , `l`.`title` AS `title` , `l`.`title_native` AS `title_native` , `l`.`sef` AS `sef` , `l`.`description` AS `description` , `l`.`published` AS `published` , `l`.`image` AS `image` , `lext`.`image_ext` AS `image_ext` , `lext`.`fallback_code` AS `fallback_code` , `lext`.`params` AS `params` , `lext`.`ordering` AS `ordering`
FROM (
`rg9k0_languages` `l`
LEFT JOIN `rg9k0_jf_languages_ext` `lext` ON ( (
`l`.`lang_id` = `lext`.`lang_id`
) )
)
ORDER BY `lext`.`ordering` ;

MySQL retourneerde: Documentatie
#1227 - Access denied; you need the SUPER privilege for this operation
Top
 Profile  
 
infograf768
PostPosted: Wed Apr 25, 2012 9:19 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Fri Aug 12, 2005 3:47 pm
Posts: 16637
Location: **Translation Matters**
jf_languages is not a Joomla table.

_________________
Jean-Marie Simonet / infograf · http://www.info-graf.fr
Multilanguage in 2.5: http://help.joomla.org/files/EN-GB_multilang_tutorial.pdf
---------------------------------
Joomla Translation Coordination Team • Joomla! Production Working Group
Top
 Profile  
 
Rutger1973
PostPosted: Wed Apr 25, 2012 8:40 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Aug 20, 2008 11:27 am
Posts: 11
Yes! Thank you for that tip...! I have removed this table and the import went smooth. Turned out it was some kind of left-over table from Joomfish I tried to install.

Still...size is quit large for a simple content website don't you think?
Top
 Profile  
 
infograf768
PostPosted: Thu Apr 26, 2012 7:12 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Fri Aug 12, 2005 3:47 pm
Posts: 16637
Location: **Translation Matters**
Rutger1973 wrote:
Still...size is quit large for a simple content website don't you think?


I do not think so, see above:

posting.php?mode=quote&f=617&p=2795970

_________________
Jean-Marie Simonet / infograf · http://www.info-graf.fr
Multilanguage in 2.5: http://help.joomla.org/files/EN-GB_multilang_tutorial.pdf
---------------------------------
Joomla Translation Coordination Team • Joomla! Production Working Group
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 8 posts ] 


Board index » Joomla! 2.5 - Ask Support Questions Here » Language - Joomla! 2.5

Who is online

Users browsing this forum: No registered users and 14 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group