| # |
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 |
| # |
Jun 13th 2019, 15:29 |
ricksaccous |
to assure your migration was created? |
| # |
Jun 13th 2019, 15:29 |
ricksaccous |
did you end up checking your config/Migrations folder |
| # |
Jun 13th 2019, 15:27 |
noel |
oops.. repeat message |
| # |
Jun 13th 2019, 15:27 |
noel |
Not really understanding migrations. I created a migration from my db using `bin/cake bake migration_snapshot`, then I cleared my db to test the migration and ran `bin/cake migrations migrate` |
| # |
Jun 13th 2019, 15:25 |
admad |
When you need to work with large number of records like for e.g. bulk updates use the db layer directly instead of ORM |
| # |
Jun 13th 2019, 15:24 |
admad |
@val it's not a "problem". Just how PHP works. Objects take more memory than arrays. You shouldn't be pulling/creating 153000 entities at a time. |