-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathdbconfig.txt
62 lines (35 loc) · 2.9 KB
/
dbconfig.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
···············································································
CONFIGURACIÓN BASE DE DATOS ###################################################
···············································································
sergio@sergio-VirtualBox:~$ sudo su -
root@sergio-VirtualBox:/# mysql
mysql> CREATE DATABASE cveloper;
mysql> CREATE USER 'cveloper'@'localhost' IDENTIFIED BY 'cveloper';
mysql> GRANT ALL PRIVILEGES ON cveloper.* TO 'cveloper'@'localhost' WITH GRANT OPTION;
mysql> exit
root@sergio-VirtualBox:~# mysql -u cveloper -pcveloper cveloper < /home/sergio/proyectos_symfony/cveloper.sql
root@sergio-VirtualBox:~# mysqldump -u cveloper -pcveloper cveloper > /home/sergio/proyectos_symfony/cveloper.sql
root@sergio-VirtualBox:~# ^D
sergio@sergio-VirtualBox:~$
···············································································
SINCRONIZACIÓN BASE DE DATOS ##################################################
···············································································
PARA VOLVER A GENERAR LA BASE DE DATOS:
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console doctrine:database:create
SI HAY ENTIDADES NO MIGRADAS ANTES:
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console make:migration
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console doctrine:migrations:migrate
SI SE HA MODIFICADO ALGUNA ENTIDAD YA MIGRADA:
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console doctrine:migrations:diff
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console doctrine:migrations:migrate
···············································································
DATOS DE PRUEBA - FIXTURES ####################################################
···············································································
ESTÁN DEFINIDOS EN:
cveloper/src/DataFixtures/XxxxxxFixtures.php
CARGA DESDE CONSOLA:
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console doctrine:fixtures:load
···············································································
RUTAS DISPONIBLES - ROUTER ####################################################
···············································································
sergio@sergio-VirtualBox:/.../cveloper$ php bin/console debug:router