the text written in the text editor is not saved as files, it is saved in the database. So specifically for the text editor, you would look inside your database for a table named "content". That's where that text is stored.

If you are not sure what you are doing, I strongly suggest you don't do anything to the database manually though.

Hi,
Thanks for your answer.
I don't see the "content" line in the database.
I've tried to open a backup .db file with an editor and I can see the content coded in html. I'll try to retrieve the parts I need this way... not so fun to do !!!

Vincent

oh no no no don't do anything like that you're going to break everything.

Let's start by asking why do you need to modify your content directly from the database? Why not from Concrete5's interface? Maybe we can find a better solution?

Ok : here is my problem.
I had a site with concrete 5.6 with a lot of pages and I wanted to change for concrete 5.8. (June 2017)
I decided to create a new site (not trying a migration from the old version to the new one).
I had two database by my provider and I used one for the older and one for the new site.
So I had the two sites working in // :
www.www.laboiteaphysique.fr/site/... (the old one)
www.www.laboiteaphysique.fr/site2/... the new one this one is OK)
So it was possible to create in the new site new pages and It was possible to copy manually the content of a page in the old one for recreating the same page in the new site. And visitors could still visit the old site.
About one year latter, I forgot to renew the payment for the database of the old site (I had problems with my health, a cancer, and I discover lately (I'm now feel quite better) that the old site didn't work anymore because of the lack of the database.
I'm changing my mind :
If I could recreate the old site on a local server it would be enough for me. I've tried the installation of concrete 5.6 :
in virtualbox running :
- windows 7 and wamp server
- debian 9 and lamp server
also in raspberry pi
and there allways a mess with the database...
And I wish (if I can install correctly concrete5.6) copy the files of the old site (I've got a copy) and also the database (I've a copy of .db files made with concrete5.6 at the date of june 2017).
I've followed different tutorials for this but there are always problems with the connexio to the database....
Vincent

Sorry to hear you have been unwell and glad to hear that you're better now.

First, at least we know you can't break anything since the database you want to access manually is from the old site so that's good :)

As far as I know, MySQL, the database engine usually used on Linux servers, doesn't use db file types. Still as far as I know, that's a Windows server file type.

This is going to sound stupid, but did you try to open it in Microsoft Access?

If the file is not insanely huge you could also send it to me and I can have a look if you want.

By the way, I'm a native French speaker if that can help?

First, thank you for your kindness about my health !

Writing in french would be easier for me ! But this thread could be useful for others users on Concrete5...

The .db file was created by the backup database option in Concrete5. I'l try as soon as possible to open it with Access (I'm a Linux user...)

Vincent

ok. well if you want me to have a look at the file later, feel free to send me a private message.

In fact these are not .db files but .sql files... (I have sometimes a problem of concentration cause I feel quickly tired.)
I'll try again to set a local concrete5 site, and I'll contact you again if necessary.

Thanks again for your answers and your disponibility !

Best regards

Vincent

.sql files are a text dump of a database, not the actual database storage. You can use a complete .sql file to recreate a database.

MySQL databases for concrete5 are usually stored in a directory with files of extension .frm and .idb

Whilst such directories can be copied between systems, there is also metadata that is not contained in those directories.

That you have .sql files is good news. Moving databases is best done by dumping to an .sql file on one system and importing the .sql file on the other system. You could potentially import the old .sql files you have to a new database.

Thanks for your answer !
I've got another problem : I'm trying to install an old version of concrete5 on my computer. The installation starts but resume with some warnings like :

Warning: Declaration of Concrete5_Model_AddBlockBlockTypePermissionAccess::save($args) should be compatible with Concrete5_Model_PermissionAccess::save() in /var/www/html/site/concrete/core/models/permission/access/categories/custom/add_block.php on line 3

Is it due to the difference of php version ?
How can I fix it ?

Best regards

Vincent