Laravel Database Migrations

[admin]

Laravel allow you to easily create database with database migration.

First you need to edit

app/config/database.php

and set the database.

To create database migration, see

http://laravel.com/docs/4.2/migrations

Once database migrations are created, you can run it, so database will be created in MySQL database.

To create MySQL database from existing Database migration file, run

php artisan migrate

This command will read migrations file stored in folder

app/database/migrations/

and create corresponding database tables.

[sherlyk]

As per the instructions in http://laravel.com/docs/4.2/migrations

I run this command:

php artisan migrate:make create_users_table

But received following error:

[admin]

First of all, you need to run this from project folder, not some random folder.

As for imagehostnow project, all database migrations are created, check folder

app/database/migrations/

Since all database migration files are already there, you only need to migrate with the command i given in above post, that will create tables as per migration files already created.

Check these database migrations files, so you get an idea how it is created, also read laravel documentation.

[sherlyk]

I run the command.

php artisan migrate

Find below the result.

[admin]

Good. Now google and try to find out why that error happend. Try to fix it yourself.

You may also verify all database information is properly set in laravel configuration file.

[sherlyk]

I have connected to mysql server and created a new db called 'imagehostnow' and edited the database info in app/config/database.php file.

Inserted database name, username and password.

Then I run following command:

php artisan migrate

I got below message:

Then I set permission for www/imagehostnow.com/app/storage/ folder using below command:

chmod -R 777 ~/www/imagehostnow.com/vendor/monolog

again run below command

php artisan migrate

But still error got

[admin]

This is because you try to create database migration file with exactly same name as we have before. To find out which file you created, run

git status
git diff

Remove the file in app/database/migrations


That is not in GIT (that is the one you created).

[sherlyk]

How do I remove files from app/database/migrations ?

[admin]

No, don't remove then. They are the database structure needed for application.

When you run

php artisan migrate

The command will look in that folder and read files one by one sorted by date and create database tables as required.

Now the problem is, you added one extra file here, that is not needed. To find which one you added, post result of

git status

and

git diff

[sherlyk]

I run those commands, and got following results:

sherly@HOME:~/www/imagehostnow.com$ php artisan migrate
**************************************
*     Application In Production!     *
**************************************

Do you really wish to run this command? yes
PHP Fatal error:  Cannot redeclare class CreateUsersTable in /home/sherly/www/imagehostnow.com/app/database/migrations/2015_01_14_052730_create_users_table.php on line 28
Error in exception handler: The stream or file "/home/sherly/www/imagehostnow.com/app/storage/logs/laravel.log" could not be opened: failed to open stream: Permission denied in /home/sherly/www/imagehostnow.com/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php:84sherly@HOME:~/www/imagehostnow.com$ git status
On branch master
Your branch is up-to-date with 'origin/master'.

Changes not staged for commit:
  (use "git add <file>..." to update what will be committed)
  (use "git checkout -- <file>..." to discard changes in working directory)

    modified:   app/config/database.php
    modified:   app/storage/.gitignore
    modified:   app/storage/cache/.gitignore
    modified:   app/storage/logs/.gitignore
    modified:   app/storage/meta/.gitignore
    modified:   app/storage/sessions/.gitignore
    modified:   app/storage/views/.gitignore
    modified:   bootstrap/start.php

Untracked files:
  (use "git add <file>..." to include in what will be committed)

    app/config/database.php~
    app/database/migrations/2015_01_14_052420_create_users_table.php
    app/database/migrations/2015_01_14_052730_create_users_table.php

no changes added to commit (use "git add" and/or "git commit -a")
sherly@HOME:~/www/imagehostnow.com$ git diff
diff --git a/app/config/database.php b/app/config/database.php
index 3498fa8..27bd248 100644
--- a/app/config/database.php
+++ b/app/config/database.php
@@ -55,9 +55,9 @@ return array(
                'mysql' => array(
                        'driver'    => 'mysql',
                        'host'      => 'localhost',
-                       'database'  => 'forge',
-                       'username'  => 'forge',
-                       'password'  => '',
+                       'database'  => 'imagehostnow',
+                       'username'  => 'root',
+                       'password'  => 'flashwebhost',
                        'charset'   => 'utf8',
                        'collation' => 'utf8_unicode_ci',
                        'prefix'    => '',
diff --git a/app/storage/.gitignore b/app/storage/.gitignore
old mode 100644
new mode 100755
diff --git a/app/storage/cache/.gitignore b/app/storage/cache/.gitignore
old mode 100644
new mode 100755
:...skipping...
diff --git a/app/config/database.php b/app/config/database.php
index 3498fa8..27bd248 100644
--- a/app/config/database.php
+++ b/app/config/database.php
@@ -55,9 +55,9 @@ return array(
                'mysql' => array(
                        'driver'    => 'mysql',
                        'host'      => 'localhost',
-                       'database'  => 'forge',
-                       'username'  => 'forge',
-                       'password'  => '',
+                       'database'  => 'imagehostnow',
+                       'username'  => 'root',
+                       'password'  => 'flashwebhost',
                        'charset'   => 'utf8',
                        'collation' => 'utf8_unicode_ci',
                        'prefix'    => '',
diff --git a/app/storage/.gitignore b/app/storage/.gitignore
old mode 100644
new mode 100755
diff --git a/app/storage/cache/.gitignore b/app/storage/cache/.gitignore
old mode 100644
new mode 100755
diff --git a/app/storage/logs/.gitignore b/app/storage/logs/.gitignore
old mode 100644
new mode 100755
diff --git a/app/storage/meta/.gitignore b/app/storage/meta/.gitignore
old mode 100644
new mode 100755
diff --git a/app/storage/sessions/.gitignore b/app/storage/sessions/.gitignore
old mode 100644
new mode 100755
diff --git a/app/storage/views/.gitignore b/app/storage/views/.gitignore
old mode 100644
new mode 100755
diff --git a/bootstrap/start.php b/bootstrap/start.php
index 84559be..b6ecab2 100644
--- a/bootstrap/start.php
+++ b/bootstrap/start.php
@@ -26,7 +26,7 @@ $app = new Illuminate\Foundation\Application;
 
 $env = $app->detectEnvironment(array(
 
-       'local' => array('homestead'),
+       'local' => array('homestead', 'sherlyf'),
 
 ));
 
~
~
~
~
~
~
~
~
sherly@HOME:~/www/imagehostnow.com$