Craft CMS Stack Exchange
Craft CMS Stack Exchange

Questions tagged [database]

363 questions
12
votes
1 answer

How to profile Craft CMS

I would like to turn on a profiler in Craft CMS so I can see what DB queries are being run and how long they take. Is this possible?
GlennJ
  • 575
  • 3
  • 12
7
votes
2 answers

craft_searchindex table keeps crashing

On my local machine, every time I've added a new field and want to add content to it for the first time I get the following error: CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 145 Table …
Steven Vandemoortele
  • 397
  • 3
  • 12
6
votes
1 answer

Does Craft Support MariaDB?

I am hoping craft supports MariaDB. Also, since version 10, InnoDB transaction engine in MariaDB has been replaced with XtraDB. Will this work with Craft?
user2022284
  • 233
  • 1
  • 5
6
votes
1 answer

Craft 3: Can't backup database ("mysqldump: command not found")

I just tried to export the DB on the Database Backup page. Unfortunately, I got an error message saying "There was a problem backing up your database. Please check the Craft logs." So I checked the logs, and found this... Could not create backup:…
Lindsey D
  • 23,974
  • 5
  • 53
  • 110
4
votes
1 answer

Complex custom SQL query with multiple relationships (Craft DB)

For the Sprout Reports plugin I need to write a custom SQL query to get some Craft data. (We use this plugin so our client can easily generate CSV exports at any time from the CP). As there are multiple relations with both Entries and Users, the…
24creative
  • 276
  • 1
  • 6
4
votes
3 answers

Craft 3 cannot find mysqldump command, console works

I want to use Feed Me with Craft to import my old database, but neither Feed Me nor Craft can find mysqldump. I know this is a known problem, and I have successfully added the path to $PATH and verified that this is set in my .bash_profile. When I…
Crafty Cat
  • 335
  • 1
  • 10
4
votes
2 answers

MSSQL Support for Craft?

Is there a MSSQL support for Craft CMS? Or any plugin that can help to connect to a MSSQL database? Thank you!
Nancy Lussier
  • 41
  • 1
4
votes
1 answer

Craft CMS Database Structure and Schema Schematics

Is there somewhere that we can find a the schematics of crafts database structure/schema. We are looking into developing a database migration workflow between development and production environments. Thanks
IColorfield
  • 91
  • 5
3
votes
4 answers

Populating craft database from non-craft data

Is it possible to populate the Craft content database table with entries from a non-craft database (which isn't a live database, it's a local copy). I've set up my channels etc for the incoming data which corresponds to the data from my other db.
Dr_Codswallop
  • 169
  • 9
3
votes
1 answer

craft_searchindex is MyISAM all others InnoDB

Looking at my database today notice this one table is MyISAM and also seems huge relative to all other tables with 147,835 rows. Is that normal? Shouldn't all tables be InnoDB? What would cause one to be MyISAM?
cmcjane
  • 439
  • 2
  • 10
3
votes
1 answer

Craft version number in database?

My provider upgraded to PHP7 and deleted all files outside of the public folder, where I had the system files (...). Is it possible to find out from the database which version (of Craft 2) I need to restore the website?
Marcel
  • 149
  • 6
3
votes
1 answer

Data encryption

For maximum security I'd like to implement data encryption in Craft CMS for all data stored in the database. So if it gets hacked the data is pretty much useless. What's a way to accomplish this? Or is there any plugin that takes care of this? I…
Jan Van Echelpoel
  • 93
  • 5
3
votes
4 answers

Craft can't connect to db

Hope you guys can help. I was working on my Craft site locally and now trying to upload it to the server but no matter what it says "Craft can’t connect to the database with the credentials in craft/config/db.php" I have created the database in…
rcho
  • 81
  • 1
  • 4
3
votes
1 answer

Database import in admin Control Panel

Is it somehow possible to import a dumped database from the admin control panel? I'm currently dumping my database in the control panel and import the dumped file in the phpmyadmin interface. I'd prefer dumping and importing in the control panel
Marco Schuler
  • 620
  • 3
  • 13
3
votes
2 answers

CDbException: What does this mean?

This just happened, but just one time. Any idea why? CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query. The SQL statement executed was: SELECT id, groupId,…
osh
  • 605
  • 2
  • 7
  • 16
1
2 3