[symfony-users] Re: database on a different server than symfony
Hello, I'll try and explain by example: Let's assume you have a MySQL server located at 192.168.1.101, and you are connecting to the database symfony-db with the username user and password pass. You can modify the connection parameters one of two ways. One, you can run the symfony command: symfony configure:database mysql:host=192.168.1.101;dbname=symfony-db user pass Of course, you will have to modify the parameters based on the way you have your database set up and how you will connect to it. This will generate the config/databases.yml file, which is what symfony reads at runtime. You can edit this file directly, which (assuming the same information as above) would look like this: all: doctrine: class: sfDoctrineDatabase param: dsn: mysql:host=192.168.1.101;dbname=symfony-db username: user password: pass Please bear in mind that there are LOTS of different configurations, this is only one example. It also assumes that you are using Doctrine vs. propel for your ORM. I highly recommend checking out Symfony's documentation, as they have a lot of information on this subject. A good place to start: http://www.symfony-project.org/reference/1_4/en/07-Databases Thanks, Hale Sostock On Dec 4, 12:29 am, DEEPAK BHATIA toreachdee...@gmail.com wrote: Hi, I currently have symfony and database on the same server. But I want to move the database to different server. Please help me in this regard. Regards Deepak Bhatia -- You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
[symfony-users] Re: database on a different server than symfony
You can edit the yamel configuration file (database.yml) as they say ... or you can use the command line to it the command symfony configure:database On 4 dic, 00:29, DEEPAK BHATIA toreachdee...@gmail.com wrote: Hi, I currently have symfony and database on the same server. But I want to move the database to different server. Please help me in this regard. Regards Deepak Bhatia -- You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
[symfony-users] Re: database on a different server than symfony
you have to edit the database.yml file which exist in config folder all: propel: class:sfPropelDatabase param: classname: PropelPDO dsn:mysql:dbname=database_name;host=server_name 0r IP_Address username: mysql_username password: mysql_password encoding: utf8 persistent: true pooling:true thats all you have to do cheers On Dec 4, 12:42 pm, Eno symb...@gmail.com wrote: On Fri, 4 Dec 2009, DEEPAK BHATIA wrote: I currently have symfony and database on the same server. But I want to move the database to different server. http://www.symfony-project.org/reference/1_4/en/07-Databases -- -- You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.