Mysql database too large with Mobile - TeraWURFL plugin

Hi,

First, I wouild like to thank you for your great component!

The Mobile Joomla! 0.9.11 works great for my jommla CMS 1.5.22 with php5 and mysql5. But I had to desactivate the Mobile - TeraWURFL plugin because my Mysql database is too large (around 35MB).  All my TeraWurfl tables are in utf8_general_ci Collation and I don't know if this is the reason.

My Question is : Is there any way to reduce the size of the TeraWurfl tables in my database and how to do it ?

Regards,
Franck

No, there isn't.

Thanks for your reply,
I will find a solution with my hosting provider to get a wider DB...

Have a nice day

Actually, there is a way to install MobileJoomla without TeraWURFL plugin (it was described in FAQ).

Yes indeed there is but the question was is there a way to make it smaller.

Hi dryabov and bazza14,

In fact, since the TeraWURFL sql is quite large, is there another way to have these files outside the Database in order to keep the joomla Database relatively small...for exemple as plugin file extension outside the Database...

...or in the future version of MobileJoomla, is there a way to choose another mysql database than the joomla mysql database (a configuration parameter inside the TeraWURFL plugin to configure another mysql hosting path) ?

Thanks for all you time you spend in supporting this wonderful Joomla extension...
Franck

myvirtuallady wrote:


You can move all the TeraWURFL's tables and procedures to another database and set database name, user and pass in plugins/mobile/terawurfl.php:

Hi dryabov,

Great ! This is the solution I expected for.
Thank you so much for this option. I am really happy to use MobileJoomla in its full version.

Bravo and have a nice day,
Franck 

can be explained the steps, sorry im beginner

1) Go into phpmyadmin and copy you Joomla database as terawurfl.

2) Go into information_schema database and run the query

select concat("drop table ",table_name,";") from tables where substr(table_name,1,4) = 'jos_' and
substr(table_name,1,13) != 'Jos_terawurfl';

Note: I am assuming you are running Joomla database with prefix 'jos_', if not then change the above accordingly

3) Copy all the drop statements into clipboard.

4) Go into terawurl database and run SQL with statements copied from the clipboard. At this stage you have a database with just the terawurfl tables.

5) Now go back to nformation_schema database and run the query

select concat("drop table ",table_name,";") from tables where substr(table_name,1,13) = 'Jos_terawurfl';

6) Copy the drop statements to clipboard.

7) Now go to your Joomla database and run the SQL with statements copied from the clipboard. At this stage you have a database with just the joomla tables.

The above process would have taken out the terawurfl tables and put them in a separate database.