Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Laravel Database Migrations

  1. #1
    Join Date
    Sep 2003
    Posts
    3,040

    Default Laravel Database Migrations

    Laravel allow you to easily create database with database migration.

    First you need to edit

    Code:
    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

    Code:
    php artisan migrate
    This command will read migrations file stored in folder

    Code:
    app/database/migrations/
    and create corresponding database tables.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  2. #2
    Join Date
    Nov 2009
    Posts
    76,596

    Default

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

    I run this command:

    Code:
    php artisan migrate:make create_users_table
    But received following error:


  3. #3
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    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

    Code:
    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.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  4. #4
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    I run the command.

    Code:
    php artisan migrate
    Find below the result.


  5. #5
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    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.
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  6. #6
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    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:

    Code:
    php artisan migrate
    I got below message:

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

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

    again run below command

    Code:
    php artisan migrate
    But still error got



  7. #7
    Join Date
    Sep 2003
    Posts
    3,040

    Default

    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

    Code:
    git status
    git diff
    Remove the file in app/database/migrations


    That is not in GIT (that is the one you created).
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  8. #8
    Join Date
    Nov 2009
    Posts
    76,596

    Default

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

  9. #9
    Join Date
    Sep 2003
    Posts
    3,040

    Default

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

    When you run

    Code:
    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


    Code:
    git status
    and

    Code:
    git diff
    Become PHP Expert in 30 days
    FreeMarriage.com - Free Online Matrimonial
    FlashWebHost.com - Professional Web Hosting, Designing.

  10. #10
    Join Date
    Nov 2009
    Posts
    76,596

    Default

    I run those commands, and got following results:

    Code:
    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$

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •