CodIgniter - Setup db(create tables etc) for existing project

Question

I have a fully completed existing codeigniter project with me. I created a mysql db locally and changed dbnames in database.php.

Now, how to setup this db by creating tables etc as per the code.

I thought db/tables would be automatically created but when I opened page it said 'ci_sessions' table is not created.

For eg: in ruby on rails, once we have code, we can do

rake db:migrate

which will create all tables. I want this feature.

In Django, we can do

 python manage.py syncdb

which will create all tables.

In java, I will have an sql file, I will execute that file using db commands which will generate db table.

Anything like any of the above in codeigniter ?

MuntingInsekto · Accepted Answer · 2014-10-08 12:57:41Z

1

if the CI project is fully completed, you can export your database and import it on the server you will be using... about creating database or table thru php code you can check CI DB Forge Documentation or check this one

answered Oct 8, 2014 at 12:57

MuntingInsekto

1,5934 gold badges19 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2349115 Over a year ago

I dont have access to the db. I think the links you gave are useful during development of code. Since we have code, cant I execute single command that creates the db skeleton? For eg: in ruby on rails, once we have code, we can do rake db:migrate which will create all tables. I want this feature.

aseferov · Accepted Answer · 2014-10-08 13:05:58Z

0

in config.php file you need to change sess_use_database false or create table name ci_session

$config['sess_use_database']    = FALSE;
$config['sess_table_name']      = 'ci_session';

answered Oct 8, 2014 at 13:05

aseferov

6,4233 gold badges20 silver badges24 bronze badges

1 Comment

user2349115 Over a year ago

Hi, thats working, but please tell me if I am correct - the only way to create db/tables is to generate .sql file from the old db or directly dump from old db. No other way, right ?(like syncdb in python/Django).

unixmiah · Accepted Answer · 2014-10-08 13:41:01Z

0

That depends. When I was using Doctrine (an ORM layer for PHP/MySQL) with CodeIgniter I had to use a call on the URL to generate DB models. It generated models maps to all the tables in the database.

answered Oct 8, 2014 at 13:41

unixmiah

3,1631 gold badge16 silver badges27 bronze badges

Collectives™ on Stack Overflow

CodIgniter - Setup db(create tables etc) for existing project

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related