CyberX

mobile

How to rename database after Maria DB dump success

There are some ugly solutions for database management like Maria DB thats won't recover your mysql dump correct. For example it will ignore path where you want to write dump and change database randomly.

Fortunately, we have a terminal command to rebase tables:


mysql -uroot -proot misatkeDB -sNe 'show tables' | while read table; 
do mysql -uroot -proot -sNe "RENAME TABLE misatakeDB.$table TO target.$table"; 
done

You have to change user and password and wait for some minutes to accomplish.

Reviews

You can write here as guest with moderation. Please confirm your person if you have an account or register.

Add a review as guest
Lets draw:

How to check MySQL dat database size

Some times, when we use not standard solutions for database management like Maria DB, we have not any solutions with GUI to see some information such as Data Bases size allocated on drive and we you need to know some special and useful commands.

For example with next code we can see how many size of Data Base are busy on drive.


SELECT table_schema "*", 
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Code bellow after execution show detail information about Data Bases size.

Reviews

You can write here as guest with moderation. Please confirm your person if you have an account or register.

RevolveR CMS v.1.3.0 :: Forum beta module released

So. A lot of work was done about last three days and I need to introduce RevolveR CMS version 1.3.0 update with Forum module.

RevolveR forum
RevolveR forum module

Not all things are quite for now and I should make some work under design, interface and functions but there are one more working module in RevolveR CMS thats was in plans at start of programming this system.

Revolver CMS Forum module preview
Revolver CMS Forum module preview

Ok! RevolveR forum for now allow you to create boards and conversations inside. All topics and comments are editable.

Some things I am not to release for now but make it later is an interface detalization(last post view in conversation) and interface improvements intended to convenience usage such as reply and quote buttons. All of it will be released in few days(I think).

Also I have to code some conversation moving functional around boards.

Thats all good news. Package available from GitHub: https://github.com/xShiftx/RevolveR_CMS

In few weeks also I have to write documentation and post it here. Please come back later.

Reviews

You can write here as guest with moderation. Please confirm your person if you have an account or register.

RevolveR CMS v.1.2.7 update :: total bug fixes

19th Jully. Finaly developers of Chromium browser provide me some considerations about a bug in browser. Error was occured with bounce effect thats cause infinite loop in Chromium. Now it fixed and front-end components used by RevolveR CMS not affected this bug.

So. I have also small digest about RevolveR CMS compability. This system is not designed for old browsers and old linux servers. It's a try of innovation and minimalistics revolution with happy end because I have many time and big dreams. For now from April(3.5 Month) I was release all system functionality without any problems. Threre are not a lot of time should be spent to design forum and ecommerce modules. Most problem is a theme developers thats I did not look at horizont.

Actually I think to devel some color switches for base theme and one single page skin for RevolveR CMS. Thats all. Another thing are payment requred because I'd like beer and girls to.

Version 1.2.7 also includes improved search with snippets like a Google search but more simple in logic plan.

Reviews

You can write here as guest with moderation. Please confirm your person if you have an account or register.

Introduction of DBX engine: mysqli query executor

Today I have a time to upgrade DBX engine thats is a part of RevolveR CMS to version 1.1.1. All changes I was integrate to CMS core are ported to different and independednt version of Data Base X.

By default for now DBX allows you not only execute DB queries from structure based arrays, for now it is allows you use files based on hash tables cache. Added new and more simple queries like Inject with witch you can use one instruction for intellectual INSERT or auto UPDATE.

For examples please see revolver core or distro index.php page contains examples and unit test info. All of it very simple to learn.

DBX v.1.1.1 availible from github here: https://github.com/xShiftx/Revolver_DBX.

Reviews

You can write here as guest with moderation. Please confirm your person if you have an account or register.