| # |
Jun 13th 2019, 15:40 |
 ricksaccous |
I think that folder might be used by cake internal plugins or something |
| # |
Jun 13th 2019, 15:39 |
ricksaccous |
but yeah seeds is actual data and migrations are for schema changes |
| # |
Jun 13th 2019, 15:39 |
ricksaccous |
i actually have no idea what that folder is for |
| # |
Jun 13th 2019, 15:38 |
noel |
Ok so seeds is actual data whereas migrations is schema changes.... so then what's the `config/schema` folder for? |
| # |
Jun 13th 2019, 15:38 |
noel |
Haha :slightly_smiling_face: I did actually delete the sphinxlog table initially. So not sure why it came back with entries when the rest didn't. |
| # |
Jun 13th 2019, 15:38 |
ricksaccous |
if you want all your initial data |
| # |
Jun 13th 2019, 15:38 |
ricksaccous |
also yeah you'll want to seed all your data as well |
| # |
Jun 13th 2019, 15:37 |
ricksaccous |
APPARENTLY YOU LIED |
| # |
Jun 13th 2019, 15:37 |
ricksaccous |
I assumed you were deleting that table though |
| # |
Jun 13th 2019, 15:37 |
ricksaccous |
so basically it knows what you have run/haven't run based on that phinxlog table |
| # |
Jun 13th 2019, 15:37 |
ricksaccous |
cool |
| # |
Jun 13th 2019, 15:36 |
noel |
ok that worked :slightly_smiling_face: |
| # |
Jun 13th 2019, 15:36 |
ricksaccous |
if you deleted your db |
| # |
Jun 13th 2019, 15:36 |
ricksaccous |
delete all entries from the phinxlog table |
| # |
Jun 13th 2019, 15:36 |
noel |
``` <?php use Migrations\AbstractMigration; class All extends AbstractMigration { public $autoId = false; public function up() { ``` |
| # |
Jun 13th 2019, 15:36 |
ricksaccous |
oh |
| # |
Jun 13th 2019, 15:36 |
ricksaccous |
<?php use Migrations\AbstractMigration; class CreateCompanies extends AbstractMigration { |
| # |
Jun 13th 2019, 15:36 |
noel |
there is a phinxlog table in the db |
| # |
Jun 13th 2019, 15:36 |
ricksaccous |
like |
| # |
Jun 13th 2019, 15:36 |
ricksaccous |
can you show me the top of the migration, is it namespaced? |
| # |
Jun 13th 2019, 15:35 |
noel |
nope... it's in config/Migrations |
| # |
Jun 13th 2019, 15:35 |
ricksaccous |
yeah it isn't finding it then.. are you putting it in a plugin? |
| # |
Jun 13th 2019, 15:35 |
noel |
Shouldn't it be a seed? Rather than a migration. It's really, initial db schema that I'm trying to store / restore. |
| # |
Jun 13th 2019, 15:34 |
noel |
doesn't list the migration filename there |
| # |
Jun 13th 2019, 15:34 |
slackebot1 |
`/Users/myproject/config/Migrations/schema-dump-default.lock` was successfully written ``` |
| # |
Jun 13th 2019, 15:34 |
noel |
``` using migration paths - /Users/myproject/config/Migrations using seed paths - /Users/myproject/config/Seeds using environment default using adapter mysql using database surge_be All Done. Took 0.0427s using migration paths - /Users/myproject/config/Migrations using seed paths - /Users/myproject/config/Seeds Writing dump file `/Users/myproject/config/Migrations/schema-dump-default.lock`... Dump file |
| # |
Jun 13th 2019, 15:33 |
ricksaccous |
if you don't see that your migration is not even being run |
| # |
Jun 13th 2019, 15:33 |
ricksaccous |
it should look similar to this: == 20190613135906 HandleCompanyStaffMemberForeignKeys: migrating == 20190613135906 HandleCompanyStaffMemberForeignKeys: migrated 0.3238s |
| # |
Jun 13th 2019, 15:32 |
ricksaccous |
then a success? |
| # |
Jun 13th 2019, 15:32 |
ricksaccous |
do you see the name of your migration |
| # |
Jun 13th 2019, 15:32 |
ricksaccous |
so when you run bin/cake migrations migrate |
| # |
Jun 13th 2019, 15:32 |
ricksaccous |
hm |
| # |
Jun 13th 2019, 15:31 |
noel |
and a schema-dump-default.lock file. |
| # |
Jun 13th 2019, 15:30 |
noel |
right |
| # |
Jun 13th 2019, 15:30 |
ricksaccous |
yeah there's only one migration then right? |
| # |
Jun 13th 2019, 15:30 |
noel |
yes but not by name... just `bin/cake migrations migrate` |
| # |
Jun 13th 2019, 15:30 |
ricksaccous |
i would do this on a test db btw XD |
| # |
Jun 13th 2019, 15:29 |
ricksaccous |
and then ran it? |
| # |
Jun 13th 2019, 15:29 |
ricksaccous |
then you deleted every table in your db |
| # |
Jun 13th 2019, 15:29 |
ricksaccous |
okay |
| # |
Jun 13th 2019, 15:29 |
noel |
yes, it was created and it looks correct |