Tag: database

93 What's the best practice for handling data migration and organization across development environments? 2014-06-12T00:42:34.907

31 What's the best practice for upgrading a versioned Craft site? 2014-06-12T00:55:44.120

11 How to profile Craft CMS 2014-07-09T20:21:37.780

9 Is there a way to delete all entries in a section? 2014-06-30T19:41:48.450

9 Migrating a whole website between Craft instances 2014-07-14T20:56:13.470

8 Manual update without database backup 2014-07-03T01:40:41.583

8 Installation Error "1046 No database selected" 2014-07-12T05:27:42.410

7 Export database from control panel or Sequel Pro? What's the difference? 2014-07-15T17:50:31.887

7 Craft install stuck on "Oops" screen 2014-08-01T11:57:40.947

7 How many entries could the Craft database hold before it slows down? 2016-01-10T19:10:44.963

6 Cannot connect to database with credentials provided in db.php 2014-06-16T15:49:28.663

6 "Eager loading" of relations like Yii's "with" function 2014-10-16T12:30:15.807

6 Query table in a different database 2015-04-01T19:46:47.973

6 Get related entry data within a plugin (ElementCriteriaModel) without extra queries 2015-04-02T11:52:00.067

6 Good practice to "Clear Caches" before you "Backup Database"? 2016-01-28T19:32:54.053

5 Using a plugin, how can I manipulate entry data? 2014-06-19T02:47:09.573

5 Is it safe to mass delete users from the database directly 2014-07-16T20:48:37.213

5 How to create a migration for the main Craft DB? 2014-10-21T03:09:49.333

5 Many entry fields, only one db request? 2015-01-31T09:01:55.790

5 Returning specific fields with elementCriteriaModel 2015-04-14T11:22:06.390

5 How could I make related entries load faster? 2015-08-20T06:47:17.797

4 How can I use multi-environment configuration to set each root URL? 2014-06-25T05:04:17.290

4 How do I create database tables for a craft cms plugin on install? 2014-07-26T17:39:52.177

4 Plugins: Managing Related Records 2014-08-09T01:32:52.257

4 Does Craft Support MariaDB? 2014-10-21T18:31:01.350

4 craft_searchindex table keeps crashing 2014-12-17T09:47:06.763

4 DB Update Trigger 2014-12-31T00:12:23.553

4 Moving to another database: "Specified key was too long" 2015-02-02T01:13:16.647

4 Complex custom SQL query with multiple relationships (Craft DB) 2015-03-30T08:05:48.180

4 Incorporating data from an external database into Craft pages 2015-06-23T13:59:48.303

4 Deleted Locale, Entries all gone now 2015-08-19T14:13:31.103

4 Craft CMS Database Structure and Schema Schematics 2015-11-03T18:54:53.887

4 Database import in admin Control Panel 2016-02-09T10:22:15.777

4 Many db requests with relationship fields 2016-02-23T10:19:22.340

4 Subdomain Setup 2016-05-21T23:29:23.390

4 Query only returning 100 records at a time? 2016-07-27T03:23:36.027

4 Craft CMS Backup DB 2016-07-27T13:55:41.497

4 What's the correct way to relate element types to a custom element type? 2016-12-19T14:55:47.610

4 Self-hosting requirements/scaling 2017-04-12T17:46:12.947

3 CDbException: What does this mean? 2014-07-16T06:47:34.953

3 PHP Fatal error: Allowed memory size of X bytes exhausted 2014-07-22T15:41:53.177

3 How to export client-entered content for a specific channel to keep my local database in sync with staging 2014-08-03T20:52:36.327

3 Migrations for Deployment 2014-10-06T00:43:50.557

3 Why am I getting only one result with "craft()->db->createCommand()"? 2014-11-13T21:06:09.807

3 Change message if database error 2014-12-02T17:40:52.943

3 Models v Records - confused 2014-12-17T18:46:46.790

3 Manually clean database cache 2015-01-08T13:44:44.337

3 Populating craft database from non-craft data 2015-02-03T12:43:07.033

3 Inserting multiple records in a plugin 2015-03-09T21:54:07.493

3 Updated Information Requested | Craft CMS & MariaDB 2015-04-10T17:13:04.707

3 Entries as Flat Files 2015-07-21T14:14:55.323

3 How do I build a LIKE query with DbCommand/Query Builder? 2015-09-24T22:10:59.550

3 General speed/performance on large Craft build 2015-12-14T15:28:16.937

3 Getting metadata/column names for empty resultset 2016-02-22T16:34:59.633

3 MSSQL Support for Craft? 2016-03-11T00:04:38.350

3 Unknown error in users section, after importing sql dump. Need help understanding logs 2017-03-09T08:16:07.730

3 Updating Craft in Laravel Valet dev enviornment 2017-03-11T02:41:05.803

3 Poor performance on midsized site / Queries without index? 2017-04-11T17:14:03.223

3 Deploying CraftCMS to Digital Ocean 2017-04-15T10:40:04.197

3 date in database -1 day as on frond-end 2017-06-01T07:24:41.443

3 Deleted matrix block means deleted data? 2017-11-04T23:59:48.073

3 Workflow for re-using data structures and setups across projects? 2017-12-27T11:11:54.517

2 Native development log / API access? 2014-06-24T17:23:51.240

2 CDbCommand failed to execute 2014-07-02T14:56:24.973

2 User activation link issue 2014-07-16T10:26:25.273

2 Simple way to use craft for databaseless prototypes 2014-08-01T00:12:28.783

2 Importing Members from ExpressionEngine 2014-08-22T04:33:00.483

2 Can you use Craft to build a relational web app database in a Knapp or Caspio style? 2014-08-25T20:36:39.537

2 How to clear the database of unused fields? 2014-10-10T10:27:20.653

2 Search Contact Person Plugin via Ajax 2014-10-28T16:18:08.020

2 Move entry from one structure to another with parenting 2014-10-29T11:30:09.597

2 When does Craft change or delete template caches? 2014-10-31T04:05:05.270

2 Minimum database privileges for Craft front-end? 2014-10-31T05:26:32.330

2 craft_searchindex is MyISAM all others InnoDB 2014-11-07T00:11:04.260

2 Relation row insertion in DB (plugin) 2014-11-27T15:36:33.630

2 Caching tables not clearing out 2014-12-01T14:34:43.277

2 Subdomain database configuration picking up root domain config 2014-12-11T22:19:14.547

2 Multi-Environment Config using port in database server 2015-01-05T17:04:26.933

2 What's the easiest way to migrate my local site data to my live site? 2015-01-12T03:29:25.443

2 Can I change TEXT to MEDIUMTEXT/LONGTEXT in database? 2015-01-16T07:01:57.597

2 Console command runing from Cron job failing after Craft update 2015-01-16T08:38:49.863

2 Working with non-craft database table 2015-01-26T23:42:49.390

2 Utilizing/ Converting another database with craft 2015-04-17T00:41:12.953

2 MANY_MANY relationships in plugins 2015-04-26T06:35:57.517

2 Eager loading relations in Plugins Element Type 2015-05-02T17:37:04.193

2 "Internal Server Error - Cannot find the target folder." When trying to edit an article 2015-06-03T08:21:03.597

2 Class 'Craft\DbCommand' not found 2015-06-15T20:14:36.507

2 How to Use defineAttributes To Specify NOT NULL and DEFAULT '1' in MySQL Record 2015-06-22T04:40:22.587

2 Mysql error when defining related tables 2015-07-28T07:23:07.700

2 db password problem 2015-08-14T10:58:26.017

2 Craft CMS Plugin Save Record to DB from Variable 2015-08-14T16:18:42.877

2 Where are Matrix Entries Fields Relationships in the Database? 2015-08-29T22:25:09.643

2 Dealing with existing data in a separate database 2015-09-05T12:09:21.733

2 Will craft attempt to reconnect to MySQL if the connection drops? 2015-09-11T09:29:59.987

2 Translated entry page can not be found (404) 2015-10-10T10:06:52.220

2 How to UNION Craft blog articles array with Social Media plugin (non craft table) 2015-10-14T17:03:26.570

2 CDbException after updating field type 2015-10-21T18:19:59.057

2 Laravel Homestead & Craft: Craft can’t connect to the database with the credentials in craft/config/db.php 2015-10-25T17:03:28.667

2 Table 'craft.craft_elementindexsettings' doesn't exist 2016-01-06T14:49:56.193